| Server IP : 74.208.127.88 / Your IP : 216.73.216.126 Web Server : Apache/2.4.41 (Ubuntu) System : Linux ubuntu 5.4.0-163-generic #180-Ubuntu SMP Tue Sep 5 13:21:23 UTC 2023 x86_64 User : www-data ( 33) PHP Version : 7.4.3-4ubuntu2.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/html/muebles/application/model/nppBackup/ |
Upload File : |
<?php
class sql extends dbconn {
public function __construct()
{
$this->initDBO();
}
//empleo
public function list_job()
{
$db = $this->dblocal;
try
{
$stmt = $db->prepare("select * from job order by id_cust desc limit 100");
$stmt->execute();
$stat[0] = true;
$stat[1] = "List job";
$stat[2] = $stmt->fetchAll(PDO::FETCH_ASSOC);
return $stat;
}
catch(PDOException $ex)
{
$stat[0] = false;
$stat[1] = $ex->getMessage();
$stat[2] = [];
return $stat;
}
}
public function new_customer($name,$country,$phone,$gender)
{
$db = $this->dblocal;
try
{
$kind=2;
$stmt = $db->prepare("insert into supplier(name,country,phone,gender) values (:name,:country,:phone,:gender)");
$stmt->bindParam("name",$name);
$stmt->bindParam("country",$country);
$stmt->bindParam("phone",$phone);
$stmt->bindParam("gender",$gender);
$stmt->execute();
$stat[0] = true;
$stat[1] = "Registro De Proveedor";
return $stat;
}
catch(PDOException $ex)
{
$stat[0] = false;
$stat[1] = $ex->getMessage();
return $stat;
}
}
public function list_customer()
{
$db = $this->dblocal;
try
{
$stmt = $db->prepare("select * from supplier where status = 1");
$stmt->execute();
$stat[0] = true;
$stat[1] = "List customer";
$stat[2] = $stmt->fetchAll(PDO::FETCH_ASSOC);
return $stat;
}
catch(PDOException $ex)
{
$stat[0] = false;
$stat[1] = $ex->getMessage();
$stat[2] = [];
return $stat;
}
}
//baja de proveedores lista
public function list_customer2()
{
$db = $this->dblocal;
try
{
$stmt = $db->prepare("select *,date_format(date_down, '%d-%m-%Y') as date_down from supplier where status = 0");
$stmt->execute();
$stat[0] = true;
$stat[1] = "List customer";
$stat[2] = $stmt->fetchAll(PDO::FETCH_ASSOC);
return $stat;
}
catch(PDOException $ex)
{
$stat[0] = false;
$stat[1] = $ex->getMessage();
$stat[2] = [];
return $stat;
}
}
public function edit_customer($id,$name,$country,$phone,$gender)
{
$db = $this->dblocal;
try
{
$stmt = $db->prepare("update supplier set name = :name, country = :country, phone = :phone , gender = :gender where id_cust = :ids ");
$stmt->bindParam("ids",$id);
$stmt->bindParam("name",$name);
$stmt->bindParam("country",$country);
$stmt->bindParam("phone",$phone);
$stmt->bindParam("gender",$gender);
$stmt->execute();
$stat[0] = true;
$stat[1] = "Actualizacion de Proveedor";
return $stat;
}
catch(PDOException $ex)
{
$stat[0] = false;
$stat[1] = $ex->getMessage();
return $stat;
}
}
//BAJA DE proveedores
public function edit_customer2($id_cust,$name,$country,$phone,$gender,$reason,$zero,$date_down)
{
$db = $this->dblocal;
try
{
$stmt = $db->prepare("update supplier set name = :name, country = :country, phone = :phone , gender = :gender,reason=:reason, status=:zero, date_down=:date_down where id_cust = :id_cust ");
$stmt->bindParam("id_cust",$id_cust);
$stmt->bindParam("country",$country);
$stmt->bindParam("name",$name);
$stmt->bindParam("phone",$phone);
$stmt->bindParam("gender",$gender);
$stmt->bindParam("zero",$zero);
$stmt->bindParam("reason",$reason);
$stmt->bindParam("date_down",$date_down);
$stmt->execute();
$stat[0] = true;
$stat[1] = "Baja de PROVEEDOR OK";
return $stat;
}
catch(PDOException $ex)
{
$stat[0] = false;
$stat[1] = $ex->getMessage();
return $stat;
}
}
//BAJA DE categorias
public function edit_category2($id_cust,$name,$zero, $date_down)
{
$db = $this->dblocal;
try
{
$stmt = $db->prepare("update category set name = :name, status=:zero, created_at=:date_down where id = :id_cust ");
$stmt->bindParam("id_cust",$id_cust);
$stmt->bindParam("name",$name);
$stmt->bindParam("zero",$zero);
$stmt->bindParam("date_down",$date_down);
$stmt->execute();
$stat[0] = true;
$stat[1] = "Baja de category OK";
return $stat;
}
catch(PDOException $ex)
{
$stat[0] = false;
$stat[1] = $ex->getMessage();
return $stat;
}
}
public function delete_customer($id)
{
$db = $this->dblocal;
try
{
$stmt = $db->prepare("delete from supplier where id_cust = :id");
$stmt->bindParam("id",$id);
$stmt->execute();
$stat[0] = true;
$stat[1] = "Success delete customer";
return $stat;
}
catch(PDOException $ex)
{
$stat[0] = false;
$stat[1] = $ex->getMessage();
return $stat;
}
}
//categorias ..................
//actualizacion categoria
public function edit_category($nameitem,$id)
{
$db = $this->dblocal;
try
{
$stmt = $db->prepare("update category set name= :value where id= :id");
$stmt->bindParam("value",$nameitem);
$stmt->bindParam("id",$id);
$stmt->execute();
$stat[0] = true;
$stat[1] = "Success Edit!";
return $stat;
}
catch(PDOException $ex)
{
$stat[0] = false;
$stat[1] = $ex->getMessage();
return $stat;
}
}
//Guardar categoria
public function new_category($item_name, $created_at){
$db = $this->dblocal;
try
{
$stmt = $db->prepare("insert into category ( name , created_at ) values ( :name , :created_at )");
$stmt->bindParam("name",$item_name);
$stmt->bindParam("created_at",$created_at);
$stmt->execute();
$stat[0] = true;
$stat[1] = "Success save!";
return $stat;
}
catch(PDOException $ex)
{
$stat[0] = false;
$stat[1] = $ex->getMessage();
return $stat;
}
}
//eliminar categoria
public function delete_category($id)
{
$db = $this->dblocal;
try
{
$stmt = $db->prepare("delete from category where id = :id");
$stmt->bindParam("id",$id);
$stmt->execute();
$stat[0] = true;
$stat[1] = "Success delete!";
return $stat;
}
catch(PDOException $ex)
{
$stat[0] = false;
$stat[1] = $ex->getMessage();
return $stat;
}
}
//todas las categorias
public function list_category()
{
$db = $this->dblocal;
try
{
$stmt = $db->prepare("SET @rownum = 0; SELECT *,@rownum := @rownum + 1 AS urutan FROM `category` where status = 1 order by created_at asc");
$stmt->execute();
$stat[0] = true;
$stat[1] = "List OK";
$stat[2] = $stmt->fetchAll(PDO::FETCH_ASSOC);
return $stat;
}
catch(PDOException $ex)
{
$stat[0] = false;
$stat[1] = $ex->getMessage();
$stat[2] = [];
return $stat;
}
}
//todas las categorias bajas
public function list_category2()
{
$db = $this->dblocal;
try
{
$stmt = $db->prepare("SELECT * FROM `category` where status = 0 order by created_at asc");
$stmt->execute();
$stat[0] = true;
$stat[1] = "List OK";
$stat[2] = $stmt->fetchAll(PDO::FETCH_ASSOC);
return $stat;
}
catch(PDOException $ex)
{
$stat[0] = false;
$stat[1] = $ex->getMessage();
$stat[2] = [];
return $stat;
}
}
}