File manager - Edit - /home/autoph/public_html/connectv1/lms/app/controllers/company.php
Back
<?php class Company{ function read_code_count($code,$utility_class,$db){ return $db->sql_query_num_rows("SELECT id FROM `lms2_companies` WHERE `code` = '$code' AND status = 1"); } function read_name_count($name,$utility_class,$db){ return $db->sql_query_num_rows("SELECT id FROM `lms2_companies` WHERE `name` = '$name' AND status = 1"); } function insert_company($array_data,$utility_class,$db){ $added_by = NULL; $login_info = $db->get_user_session(); if($login_info){ $added_by = $login_info['id']; } $query = "INSERT INTO `lms2_companies`(`name`, `code`, `added_by`, `date_added`, `status`) VALUES ('".$array_data['txt_company_name']."','".$array_data['txt_company_code']."',$added_by,NOW(),'1')"; $inserted_count = $db->sql_query_affected_rows($query); return intval($inserted_count); } function company_table($utility_class,$db){ $query = "SELECT c.id,c.name,c.code,c.date_added,CONCAT(u.firstname,' ',u.lastname) as added_by FROM `lms2_companies` c LEFT OUTER JOIN lms2_users u ON c.added_by = u.id WHERE c.`status` = 1 ORDER BY c.name ASC"; return $db->sql_query($query); } function remove_company($id,$utility_class,$db){ $query = "UPDATE `lms2_companies` SET `status`=0 WHERE id = $id"; $affected_rows = $db->sql_query_affected_rows($query); return intval($affected_rows); } function company_list($search,$utility_class,$db){ $query = "SELECT c.id,c.name,c.code FROM `lms2_companies` c WHERE 1 AND CONCAT (c.code,' ',c.name) LIKE '%%%s%%' AND c.status = 1 ORDER BY c.name ASC"; $query_final = sprintf($query,$search); return $db->sql_query($query_final); } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings