File manager - Edit - /home/autoph/public_html/tasks/company_class.php.tar
Back
home/autoph/public_html/tasks/app/classes/company_class.php 0000644 00000003753 15025024701 0020210 0 ustar 00 <?php /** * use CRUD for class naming * example: create_ and read_and update_ and delete_ */ class Company{ function read_company_by_source_id($source_id,$utility_class,$db){ $query = "SELECT * FROM `companies` WHERE 1 AND source_id = $source_id LIMIT 1"; return $db->sql_query($query); } function create_company($user_id,$company_source_id,$company_name,$company_code,$utility_class,$db){ $query = "INSERT INTO `companies`( `name`, `code`, `user_id`, `date_added`, `status`, `source_id`) VALUES (NULLIF('$company_name',''),NULLIF('$company_code',''),NULLIF('$user_id',''),NOW(),1,NULLIF('$company_source_id',''))"; return $db->sql_query_id($query); } function update_company($company_id,$user_id,$company_source_id,$company_name,$company_code,$utility_class,$db){ $query = "UPDATE `companies` SET `name`=NULLIF('$company_name',''),`code`=NULLIF('$company_code',''),`user_id`=NULLIF('$user_id','') WHERE 1 AND id= $company_id"; $db->sql_query($query); } function read_dealer_by_source_id($source_id,$utility_class,$db){ $query = "SELECT * FROM `dealers` WHERE 1 AND source_id = $source_id LIMIT 1"; return $db->sql_query($query); } function create_dealer($user_id,$company_id,$dealer_source_id,$dealer_name,$dealer_code,$utility_class,$db){ $query = "INSERT INTO `dealers`( `name`, `company_id`,`code`, `user_id`, `date_added`, `status`, `source_id`) VALUES (NULLIF('$dealer_name',''),NULLIF('$company_id',''),NULLIF('$dealer_code',''),NULLIF('$user_id',''),NOW(),1,NULLIF('$dealer_source_id',''))"; return $db->sql_query_id($query); } function update_dealer($company_id,$dealer_id,$user_id,$dealer_source_id,$dealer_name,$dealer_code,$utility_class,$db){ $query = "UPDATE `dealers` SET `company_id`=NULLIF('$company_id',''),`name`=NULLIF('$dealer_name',''),`code`=NULLIF('$dealer_code',''),`user_id`=NULLIF('$user_id','') WHERE 1 AND id= $dealer_id"; $db->sql_query($query); } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings