File manager - Edit - /home/wwwroot/camplus.hk/master.camplus.hk/public_html/application/modules/supplier/models/Supplier_model.php
Back
<?php Class Supplier_Model extends CI_Model{ function getSuppliers(){ $data = $this->db->get_where('suppliers')->result_array(); foreach ($data as $key => $value) { $is_delete = $this->db->get_where('pr_has_reference_supplier',array('supplier_id' => $value['id']))->row_array(); $query = $this->db->get_where('supplier_alias',array('host_id' => $value['id'])); if ($query->num_rows() > 0) $data[$key]['isHost'] = 1; else $data[$key]['isHost'] = 0; if(empty($is_delete)){ $is_pr_delete = $this->db->get_where('purchase_request',array('chosen_supplier_id' => $value['id']))->row_array(); if(empty($is_pr_delete)) $data[$key]['is_delete'] = 1; else $data[$key]['is_delete'] = 0; } else{ $data[$key]['is_delete'] = 0; } } return $data; } function addSupplierPIC($data){ return $this->db->insert_batch('supplier_pic',$data); } // function addSupplier($data) // { // $this->db->insert('suppliers', array('supplier' => $data['supplier'])); // if($data['name'] || $data['tel'] || $data['email'] || $data['address'] ){ // $insert_id = $this->db->insert_id(); // $this->addSupplierPIC( array('supplier_id'=>$insert_id, 'name' => $data['name'],'tel'=>$data['tel'],'address'=>$data['address'],'email'=>$data['email'] )); // } // } function addSupplier($data) { $this->db->insert('suppliers', array('supplier' => $data['supplier'])); if($data['pic'][0]['name'] || $data['pic'][0]['tel'] || $data['pic'][0]['email'] || $data['pic'][0]['address'] ){ $insert_id = $this->db->insert_id(); foreach ($data['pic'] as $key => $value) { if($value['name'] || $value['tel'] || $value['email'] || $value['address'] ) $data['pic'][$key]['supplier_id'] = $insert_id; else unset($data['pic'][$key]); } $this->addSupplierPIC($data['pic']); } return TRUE; } function getSupplierPIC($id){ $retArray = $this->db->get_where('supplier_pic',array('supplier_id' => $id))->result_array(); $alias = $this->db->get_where('supplier_alias',array('host_id' => $id))->result_array(); foreach ($alias as $value) { $aliasPIC = $this->db->get_where('supplier_pic',array('supplier_id' => $value['alias_id']))->result_array(); foreach ($aliasPIC as $PIC) { array_push($retArray, $PIC); } } return $retArray; } function getConcatPersonInfo($id) { return $this->db->get_where('supplier_pic',array('id' => $id))->row_array(); } function getSuppliersAlias(){ $this->db->select('alias_id'); $result = $this->db->get('supplier_alias')->result_array(); $retArray = array(); foreach ($result as $value) { array_push($retArray, $value['alias_id']); } return $retArray; } function getAliasById($id){ $this->db->select('alias_id'); $alias = $this->db->get_where('supplier_alias', array('host_id' => $id))->result_array(); $retArray =array(); foreach ($alias as $value) { $row = $this->db->get_where('suppliers',array('id' => $value['alias_id']))->row_array(); array_push($retArray, $row); } return $retArray; } function editSupplier($data) { $id = $data['id']; unset($data['id']); return $this->db->update('suppliers',$data,array('id' => $id)); } function deleteSupplier($id) { $is_delete = $this->db->get_where('pr_has_reference_supplier',array('supplier_id' => $id))->row_array(); if(empty($is_delete)){ $this->db->delete('supplier_pic',array('supplier_id' => $id)); $this->db->delete('supplier_alias',array('host_id' => $id)); $this->db->delete('supplier_alias',array('alias_id' => $id)); return $this->db->delete('suppliers',array('id' => $id)); } else return FALSE; } function bulkAction($array) { $idArray = explode(':', $array['ids']); switch($array['action']){ case 'Delete': if(!$this->acl->hasPermission('MANAGE_SUPPLIER')) show_error($this->lang->line('no_permission_error')); foreach($idArray as $id){ $is_delete = $this->db->get_where('pr_has_reference_supplier',array('supplier_id' => $id))->row_array(); if(empty($is_delete)){ $this->db->delete('suppliers',array('id' => $id)); $this->db->delete('supplier_pic',array('supplier_id' => $id)); $this->db->delete('supplier_alias',array('host_id' => $id)); $this->db->delete('supplier_alias',array('alias_id' => $id)); } } break; } } function merge_suppliers($idArray) { $host_id = 0; foreach($idArray as $id){ $query = $this->db->get_where('supplier_alias',array('host_id' => $id)); if ($query->num_rows() > 0){ $host_id = $id; } } if($host_id==0){ foreach($idArray as $id){ $query = $this->db->get_where('supplier_alias',array('alias_id' => $id)); if ($query->num_rows() > 0){ $result = $query->result_array(); $host_id = $result[0]['host_id']; } } } if($host_id == 0 ) $host_id = $idArray[0]; foreach($idArray as $id){ if($host_id!=$id) $this->db->insert('supplier_alias',array('host_id' => $host_id,'alias_id' => $id )); } return "done"; } function unmerge_suppliers($id){ return $this->db->delete('supplier_alias',array('alias_id' => $id)); } function addOneSupplierPIC($data){ $this->db->insert('supplier_pic',$data); return $this->db->insert_id(); } function getSupplierDT() { // school name: SELECT value FROM `site_settings` WHERE `setting`='school_name' $this->db ->select('suppliers.supplier, IFNULL(supplier_pic.name,"") as name, IFNULL(supplier_pic.tel,"") as tel, IFNULL(supplier_pic.email,"") as email, IFNULL(supplier_pic.address,"") as address, IFNULL(site_settings.value, "") as school_name') ->from('`suppliers`, `site_settings`') ->join('supplier_pic','suppliers.id = supplier_pic.supplier_id','left') ->where('suppliers.supplier!="" AND site_settings.setting` = "school_name"'); $this->datatable->get($this->db,$_POST); } function add($supplier) { return $this->db->insert('suppliers', array('supplier' => $supplier)); } } ?>
| ver. 1.4 |
Github
|
.
| PHP 7.2.34 | Generation time: 0.53 |
proxy
|
phpinfo
|
Settings