| Server IP : 74.208.127.88 / Your IP : 18.117.85.73 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/pos11/core/app/model/ |
Upload File : |
<?php
class ConfigurationData {
public static $tablename = "configuration";
public function ConfigurationData(){
$this->title = "";
$this->content = "";
$this->image = "";
$this->user_id = "";
$this->is_public = "0";
$this->created_at = "NOW()";
}
public function add(){
$sql = "insert into ".self::$tablename." (name,short_name,is_active) ";
$sql .= "value (\"$this->name\",\"$this->short_name\",$this->is_active)";
Executor::doit($sql);
}
public static function delById($id){
$sql = "delete from ".self::$tablename." where id=$id";
Executor::doit($sql);
}
public function del(){
$sql = "delete from ".self::$tablename." where id=$this->id";
Executor::doit($sql);
}
// partiendo de que ya tenemos creado un objecto ConfigurationData previamente utilizamos el contexto
public function update(){
$sql = "update ".self::$tablename." set name=\"$this->name\",short_name=\"$this->short_name\",is_active=\"$this->is_active\" where id=$this->id";
Executor::doit($sql);
}
public static function updateValFromName($name,$val){
$sql = "update ".self::$tablename." set val=\"$val\" where short=\"$name\"";
Executor::doit($sql);
}
public static function getById($id){
$sql = "select * from ".self::$tablename." where id=$id";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
public static function getById1(){
$sql = "select * from ".self::$tablename." where id=1";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
public static function getByIdRFC(){
$sql = "select * from ".self::$tablename." where id=8";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
public static function getByIdEmisor(){
$sql = "select * from ".self::$tablename." where id=9";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
public static function getByIdCalle(){
$sql = "select * from ".self::$tablename." where id=10";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
public static function getByIdInt(){
$sql = "select * from ".self::$tablename." where id=11";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
public static function getByIdExt(){
$sql = "select * from ".self::$tablename." where id=12";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
public static function getByIdColonia(){
$sql = "select * from ".self::$tablename." where id=13";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
public static function getByIdCity(){
$sql = "select * from ".self::$tablename." where id=14";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
public static function getByIdCp(){
$sql = "select * from ".self::$tablename." where id=16";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
public static function getByIdClaveSat(){
$sql = "select * from ".self::$tablename." where id=24";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
public static function getByIdRegimenSat(){
$sql = "select * from ".self::$tablename." where id=26";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
public static function getByIdUnidadSat(){
$sql = "select * from ".self::$tablename." where id=25";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
//****************datos fiscales demo*************************
public static function ArchCerDemo(){
$sql = "select * from ".self::$tablename." where id=37";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
public static function ArchKeyDemo(){
$sql = "select * from ".self::$tablename." where id=38";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
public static function PassDemoMulti(){
$sql = "select * from ".self::$tablename." where id=39";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
public static function UserDemo(){
$sql = "select * from ".self::$tablename." where id=40";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
public static function PassDemo(){
$sql = "select * from ".self::$tablename." where id=41";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
public static function RegimenfiscalDemo(){
$sql = "select * from ".self::$tablename." where id=42";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
//****************datos fiscales cliente*************************
public static function ArchCer(){
$sql = "select * from ".self::$tablename." where id=34";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
public static function ArchKey(){
$sql = "select * from ".self::$tablename." where id=35";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
public static function Regimenfiscal(){
$sql = "select * from ".self::$tablename." where id=36";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
//************fin datos fiscales*****************
public static function getByIdConf($no){
$sql = "select * from ".self::$tablename." where id='$no'";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
public static function getByPreffix($id){
$sql = "select * from ".self::$tablename." where short=\"$id\"";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
public static function getByPreId($id){
$sql = "select * from ".self::$tablename." where id=$id";
$query = Executor::doit($sql);
return Model::one($query[0],new ConfigurationData());
}
public static function getAll(){
$sql = "select * from ".self::$tablename;
$query = Executor::doit($sql);
return Model::many($query[0],new ConfigurationData());
}
public static function getPublics(){
$sql = "select * from ".self::$tablename." where is_active=1";
$query = Executor::doit($sql);
return Model::many($query[0],new ConfigurationData());
}
}
?>