common_model->checkpurview(82); } public function ar() { $data = $this->input->post(NULL,TRUE); if (count($data)>0) { $userName = str_enhtml($this->input->get('userName',TRUE)); $rightid = (array)json_decode($data['rightid'],true); $info['rightids'] = join(',',$rightid['rightids']); $sql = $this->mysql_model->update('admin',$info,'(username="'.$userName.'")'); if ($sql) { str_alert(200,'success'); } } str_alert(-1,'更新失败'); } public function dt() { $ids = str_enhtml($this->input->post('userName',TRUE)); die('{"status":200,"data":{"items":[ {"FNAME":"仓库","FRIGHT":"1","FRIGHTID":"1","FNUMBER":"location"}, {"FNAME":"客户","FRIGHT":"2","FRIGHTID":"2","FNUMBER":"customer"}, {"FNAME":"供应商","FRIGHT":"4","FRIGHTID":"4","FNUMBER":"supplier"}, {"FNAME":"制单人","FRIGHT":"8","FRIGHTID":"8","FNUMBER":"user"} ],"totalsize":4},"msg":"success"}'); } public function update() { $this->common_model->checkpurview(); $type = max(intval($this->input->get('type',TRUE)),1); $rights = $this->input->post('rights',TRUE); $userName = str_enhtml($this->input->get('userName',TRUE)); $data = $this->mysql_model->get_rows('admin',array('username'=>$userName)); if (count($data>0)) { $array = explode(',',$data['righttype'.$type]); foreach((array)json_decode($rights,true) as $arr=>$row){ if ($row['FRIGHT']==1) { $s1[] = $row['FITEMID']; //新增 } else { $s2[] = $row['FITEMID']; //除去 } } if (isset($s1)) { $info['righttype'.$type] = join(',',array_filter(array_merge($array,$s1))); $this->mysql_model->update('admin',$info,array('username'=>$userName)); } if (isset($s2)) { $info['righttype'.$type] = join(',',array_filter(array_diff($array,$s2))); $this->mysql_model->update('admin',$info,array('username'=>$userName)); } str_alert(200,'success'); } str_alert(-1,'更新失败'); } public function query() { $v = array(); $type = max(intval($this->input->get_post('type',TRUE)),0); $skey = str_enhtml($this->input->get_post('skey',TRUE)); $userName = str_enhtml($this->input->get_post('userName',TRUE)); $data = $this->mysql_model->get_rows('admin',array('username'=>$userName)); if (count($data)>0) { switch ($type) { case 1: $righttype = explode(',',$data['righttype'.$type]); $where = $skey ? ' and (locationNo like "%'.$skey.'%" or name like "%'.$skey.'%")' : ''; $list = $this->mysql_model->get_results('storage','(isDelete=0) '.$where,'id desc'); foreach ($list as $arr=>$row) { $v[$arr]['FITEMID'] = intval($row['id']); $v[$arr]['FNAME'] = $row['name']; $v[$arr]['FITEMNO'] = $row['locationNo']; $v[$arr]['FRIGHT'] = in_array($row['id'],$righttype)==1 ? 1 : 0; } break; case 2: $righttype = explode(',',$data['righttype'.$type]); $where = $skey ? ' and (number like "%'.$skey.'%" or name like "%'.$skey.'%")' : ''; $list = $this->mysql_model->get_results('contact','(isDelete=0) and type=-10 '.$where,'id desc'); foreach ($list as $arr=>$row) { $v[$arr]['FITEMID'] = intval($row['id']); $v[$arr]['FNAME'] = $row['name']; $v[$arr]['FITEMNO'] = $row['number']; $v[$arr]['FRIGHT'] = in_array($row['id'],$righttype)==1 ? 1 : 0; } break; case 4: $righttype = explode(',',$data['righttype'.$type]); $where = $skey ? ' and (number like "%'.$skey.'%" or name like "%'.$skey.'%")' : ''; $list = $this->mysql_model->get_results('contact','(isDelete=0) and type=10 '.$where,'id desc'); foreach ($list as $arr=>$row) { $v[$arr]['FITEMID'] = intval($row['id']); $v[$arr]['FNAME'] = $row['name']; $v[$arr]['FITEMNO'] = $row['number']; $v[$arr]['FRIGHT'] = in_array($row['id'],$righttype)==1 ? 1 : 0; } break; case 8: $righttype = explode(',',$data['righttype'.$type]); $where = $skey ? ' and (username like "%'.$skey.'%" or name like "%'.$skey.'%")' : ''; $list = $this->mysql_model->get_results('admin','(1=1) '.$where,'uid desc'); foreach ($list as $arr=>$row) { $v[$arr]['FITEMID'] = intval($row['uid']); $v[$arr]['FNAME'] = $row['username']; $v[$arr]['FITEMNO'] = intval($row['uid']); $v[$arr]['FRIGHT'] = in_array($row['uid'],$righttype)==1 ? 1 : 0; } break; default: } } $data['status'] = 200; $data['msg'] = 'success'; $data['data']['rows'] = $v; $data['data']['total'] = 1; $data['data']['records'] = count($v); $data['data']['page'] = 1; die(json_encode($data)); } } /* End of file welcome.php */ /* Location: ./application/controllers/welcome.php */