File manager - Edit - /home/wwwroot/camplus.hk/master.camplus.hk/public_html/application/modules/attendance/models/Card_reader_model.php
Back
<?php Class Card_reader_model extends CI_Model{ // function getCard_readers() // { // return $this->db->get('tb_example')->result_array(); // } // function getCard_reader($id = 0) // { // return $this->db->get_where('tb_example',array('id' => $id))->row_array(); // } // function addCard_reader($data) // { // return $this->db->insert('tb_example',$data); // } // function editCard_reader($data,$id) // { // return $this->db->update('tb_example',$data,array('id' => $id)); // } // function deleteCard_reader($id) // { // return $this->db->delete('tb_example',array('id' => $id)); // } function updateUser_card($data) { $exist = $this->db->get_where('at_user_card','uid='.$data['uid'])->row_array(); if(empty($exist)){ $this->db->insert('at_user_card',$data); } else { $this->db->where('uid',$data['uid']); $this->db->update('at_user_card',array('card'=>$data['card'])); } return $data['card']; } function getUser_cards() { $this->db->select('users.*,at_user_card.card'); $this->db->from('users'); $this->db->join('at_user_card','at_user_card.uid = users.id','left'); return $this->db->get()->result_array(); } function getUser_card($id) { $this->db->select('at_user_card.card'); $this->db->from('users'); $this->db->join('at_user_card','at_user_card.uid = users.id','left'); $this->db->where('users.id ='.$id); return $this->db->get()->row_array(); } function check_in($card,$reader=0) { $this->db->select('users.*,at_user_card.card'); $this->db->from('users'); $this->db->join('at_user_card','at_user_card.uid = users.id','left'); $this->db->where('at_user_card.card',$card); $this->db->or_where('at_user_card.card',ltrim($card, '0')); $card_user = $this->db->get()->row_array(); if(!empty($card_user)) { $this->db->insert('at_record',array('card'=>$card,'cr_id'=>$reader)); $user['need_password']=false; return $card_user; } else { $user = $this->db->get_where('users',array('username'=>$card))->row_array(); if(!empty($user)){ $user['need_password']=true; return $user; } } } //check unique card number_format function getCard_reader($card_number = 0) { return $this->db->get_where('at_user_card',array('card' => $card_number ))->row_array(); } function importCard_Reader($data) { foreach($data as $key => $value) { if($key!=0) { $user=$this->db->get_where('users',array('username' => $value[0] ))->row_array(); if(!empty($user['id'])) { $user_card=$this->db->get_where('at_user_card',array('uid' => $user['id'], 'card'=>$value[1] ))->row_array(); if(empty($user_card)) { $newdata=array("uid"=>$user['id'],"card"=>$value[1]); $this->db->insert('at_user_card',$newdata); unset($newdata); } } } } return true; } }
| ver. 1.4 |
Github
|
.
| PHP 7.2.34 | Generation time: 0.99 |
proxy
|
phpinfo
|
Settings