394 lines
17 KiB
PHP
Executable File
394 lines
17 KiB
PHP
Executable File
<?php
|
|
defined('BASEPATH') OR exit('No direct script access allowed');
|
|
|
|
class Contact extends CI_Controller {
|
|
|
|
public function __construct(){
|
|
parent::__construct();
|
|
$this->common_model->checkpurview();
|
|
}
|
|
|
|
//客户、供应商列表
|
|
public function index() {
|
|
$type = intval($this->input->get('type',TRUE))==10 ? 10 : -10;
|
|
$skey = str_enhtml($this->input->get_post('skey',TRUE));
|
|
$page = max(intval($this->input->get_post('page',TRUE)),1);
|
|
$categoryid = intval($this->input->get_post('categoryId',TRUE));
|
|
$rows = max(intval($this->input->get_post('rows',TRUE)),100);
|
|
$where = '(isDelete=0) and type='.$type;
|
|
$where .= $this->common_model->get_contact_purview();
|
|
$where .= $skey ? ' and (number like "%'.$skey.'%" or name like "%'.$skey.'%" or linkMans like "%'.$skey.'%")' : '';
|
|
$where .= $categoryid>0 ? ' and cCategory = '.$categoryid.'' : '';
|
|
$list = $this->mysql_model->get_results('contact',$where,'id desc',$rows*($page-1),$rows);
|
|
//if($type == 10){
|
|
foreach ($list as $arr=>$row) {
|
|
$v[$arr]['id'] = intval($row['id']);
|
|
$v[$arr]['number'] = $row['number'];
|
|
$v[$arr]['cCategory'] = intval($row['cCategory']);
|
|
$v[$arr]['customerType'] = $row['cCategoryName'];
|
|
$v[$arr]['pinYin'] = $row['pinYin'];
|
|
$v[$arr]['name'] = $row['name'];
|
|
$v[$arr]['type'] = $row['type'];
|
|
$v[$arr]['delete'] = intval($row['disable'])==1 ? true : false;
|
|
$v[$arr]['cLevel'] = intval($row['cLevel']);
|
|
$v[$arr]['amount'] = (float)$row['amount'];
|
|
$v[$arr]['periodMoney'] = (float)$row['periodMoney'];
|
|
$v[$arr]['difMoney'] = (float)$row['difMoney'];
|
|
$v[$arr]['remark'] = $row['remark'];
|
|
$v[$arr]['taxRate'] = (float)$row['taxRate'];
|
|
$v[$arr]['links'] = '';
|
|
$v[$arr]['linkMen'] = $row['linkMans'];//add by michen 20170724
|
|
if (strlen($row['linkMans'])>0) {
|
|
$list = (array)json_decode($row['linkMans'],true);
|
|
foreach ($list as $arr1=>$row1) {
|
|
if ($row1['linkFirst']==1) {
|
|
$v[$arr]['contacter'] = $row1['linkName'];
|
|
$v[$arr]['mobile'] = $row1['linkMobile'];
|
|
$v[$arr]['place'] = $row1['linkPlace'];
|
|
$v[$arr]['telephone'] = $row1['linkPhone'];
|
|
$v[$arr]['linkIm'] = $row1['linkIm'];
|
|
$v[$arr]['city'] = $row1['city'];
|
|
$v[$arr]['county'] = $row1['county'];
|
|
$v[$arr]['province'] = $row1['province'];
|
|
$v[$arr]['deliveryAddress'] = $row1['address'];
|
|
$v[$arr]['firstLink']['first'] = $row1['linkFirst'];
|
|
}
|
|
}
|
|
}
|
|
}
|
|
/*}else{
|
|
//add by michen 20170720 begin
|
|
$gid = 1;
|
|
foreach ($list as $arr=>$row) {
|
|
$v[$arr]['id'] = intval($row['id']);
|
|
$v[$arr]['number'] = $row['number'];
|
|
$v[$arr]['cCategory'] = intval($row['cCategory']);
|
|
$v[$arr]['customerType'] = $row['cCategoryName'];
|
|
$v[$arr]['pinYin'] = $row['pinYin'];
|
|
$v[$arr]['name'] = $row['name'];
|
|
$v[$arr]['type'] = $row['type'];
|
|
$v[$arr]['delete'] = intval($row['disable'])==1 ? true : false;
|
|
$v[$arr]['cLevel'] = intval($row['cLevel']);
|
|
$v[$arr]['amount'] = (float)$row['amount'];
|
|
$v[$arr]['periodMoney'] = (float)$row['periodMoney'];
|
|
$v[$arr]['difMoney'] = (float)$row['difMoney'];
|
|
$v[$arr]['remark'] = $row['remark'];
|
|
$v[$arr]['taxRate'] = (float)$row['taxRate'];
|
|
$v[$arr]['links'] = '';
|
|
$i = 1;
|
|
if (strlen($row['linkMans'])>0) {
|
|
$list = (array)json_decode($row['linkMans'],true);
|
|
foreach ($list as $arr1=>$row1) {
|
|
if ($i==1) {
|
|
$v[$arr]['contacter'] = $row1['linkName'];
|
|
$v[$arr]['mobile'] = $row1['linkMobile'];
|
|
$v[$arr]['place'] = $row1['linkPlace'];
|
|
$v[$arr]['telephone'] = $row1['linkPhone'];
|
|
$v[$arr]['linkIm'] = $row1['linkIm'];
|
|
$v[$arr]['city'] = $row1['city'];
|
|
$v[$arr]['county'] = $row1['county'];
|
|
$v[$arr]['province'] = $row1['province'];
|
|
$v[$arr]['deliveryAddress'] = $row1['address'];
|
|
$v[$arr]['firstLink']['first'] = $row1['linkFirst'];
|
|
$v[$arr]['isFirst'] = $row1['linkFirst']==1?1:2;
|
|
$v[$arr]['gid'] = $gid;
|
|
}else{
|
|
$v[$arr.$i]['id'] = intval($row['id']);
|
|
$v[$arr.$i]['number'] = $row['number'];
|
|
$v[$arr.$i]['cCategory'] = intval($row['cCategory']);
|
|
$v[$arr.$i]['customerType'] = $row['cCategoryName'];
|
|
$v[$arr.$i]['pinYin'] = $row['pinYin'];
|
|
$v[$arr.$i]['name'] = $row['name'];
|
|
$v[$arr.$i]['type'] = $row['type'];
|
|
$v[$arr.$i]['delete'] = intval($row['disable'])==1 ? true : false;
|
|
$v[$arr.$i]['cLevel'] = intval($row['cLevel']);
|
|
$v[$arr.$i]['amount'] = (float)$row['amount'];
|
|
$v[$arr.$i]['periodMoney'] = (float)$row['periodMoney'];
|
|
$v[$arr.$i]['difMoney'] = (float)$row['difMoney'];
|
|
$v[$arr.$i]['remark'] = $row['remark'];
|
|
$v[$arr.$i]['taxRate'] = (float)$row['taxRate'];
|
|
$v[$arr.$i]['links'] = '';
|
|
$v[$arr.$i]['contacter'] = $row1['linkName'];
|
|
$v[$arr.$i]['mobile'] = $row1['linkMobile'];
|
|
$v[$arr.$i]['place'] = $row1['linkPlace'];
|
|
$v[$arr.$i]['telephone'] = $row1['linkPhone'];
|
|
$v[$arr.$i]['linkIm'] = $row1['linkIm'];
|
|
$v[$arr.$i]['city'] = $row1['city'];
|
|
$v[$arr.$i]['county'] = $row1['county'];
|
|
$v[$arr.$i]['province'] = $row1['province'];
|
|
$v[$arr.$i]['deliveryAddress'] = $row1['address'];
|
|
$v[$arr.$i]['firstLink']['first'] = $row1['linkFirst'];
|
|
$v[$arr.$i]['isFirst'] = $row1['linkFirst']==1?1:2;
|
|
$v[$arr]['gid'] = $gid;
|
|
}
|
|
$i++;
|
|
$gid++;
|
|
}
|
|
}
|
|
}
|
|
//add by michen 20170720 end
|
|
}
|
|
//add by michen 20170720 begin
|
|
uasort($v,function ($x,$y){
|
|
return strcasecmp($x['id'].$x['isFirst'],$y['id'].$x['isFirst']);
|
|
}
|
|
);
|
|
$values = array_values($v);
|
|
//add by michen 20170720 end
|
|
*/
|
|
$json['status'] = 200;
|
|
$json['msg'] = 'success';
|
|
$json['data']['page'] = $page;
|
|
$json['data']['records'] = $this->mysql_model->get_count('contact',$where);
|
|
$json['data']['total'] = ceil($json['data']['records']/$rows);
|
|
$json['data']['rows'] = isset($v) ? array_values($v) : array();
|
|
die(json_encode($json));
|
|
}
|
|
|
|
//校验客户编号
|
|
public function getNextNo(){
|
|
$type = intval($this->input->get('type',TRUE));
|
|
$skey = intval($this->input->post('skey',TRUE));
|
|
str_alert(200,'success',array('number'=>$skey));
|
|
}
|
|
|
|
|
|
//检测客户名称
|
|
public function checkName(){
|
|
$id = intval($this->input->post('id',TRUE));
|
|
$name = str_enhtml($this->input->post('name',TRUE));
|
|
$where['name'] = $name;
|
|
$where['isDelete'] = 0;
|
|
$where['id !='] = $id>0 ? $id :'';
|
|
$data = $this->mysql_model->get_rows('contact',array_filter($where));
|
|
if (count($data)>0) {
|
|
str_alert(-1,'客户名称重复');
|
|
}
|
|
str_alert(200,'success');
|
|
}
|
|
|
|
function my_filter($item){
|
|
if($item['linkFirst'] === 1)
|
|
return true;
|
|
else
|
|
return false;
|
|
}
|
|
|
|
public function getRecentlyContact(){
|
|
$billType = str_enhtml($this->input->post('billType',TRUE));
|
|
$transType = intval($this->input->post('transType',TRUE));
|
|
$where = '(isDelete=0)';
|
|
$where .= ($transType==150501||$transType==150502) ? ' and type=10' :' and type=-10';//mody by michen 20170820 修正购货退货单默认供应商不正确
|
|
$where .= $this->common_model->get_contact_purview();
|
|
$data = $this->mysql_model->get_rows('contact',$where);
|
|
//die(var_export($data,true));
|
|
if (count($data)>0) {
|
|
//add by michen 20170724 begin
|
|
/*$linkMen = (array)json_decode($data['linkMans'],true);
|
|
$linkMan = "null";
|
|
if(count($linkMen)>0){
|
|
foreach ($linkMen as $key => $item){
|
|
if($item['linkFirst'] === 1){
|
|
$linkMan = $item;
|
|
break;
|
|
}
|
|
}
|
|
}*/
|
|
//add by michen 20170724 end
|
|
die('{"status":200,"msg":"success","data":{"linkMen":'.$data['linkMans'].',"contactName":"'.$data['name'].'","buId":'.$data['id'].',"cLevel":0}}');
|
|
} else {
|
|
str_alert(-1,'');
|
|
}
|
|
}
|
|
|
|
public function getLinkMen(){
|
|
$buId = intval($this->input->get('buId',TRUE));
|
|
$data = $this->mysql_model->get_rows('contact','(isDelete=0) and id='.$buId);
|
|
die($data['linkMans']);
|
|
}
|
|
|
|
|
|
//获取信息
|
|
public function query() {
|
|
$id = intval($this->input->get_post('id',TRUE));
|
|
$type = intval($this->input->get_post('type',TRUE));
|
|
$data = $this->mysql_model->get_rows('contact',array('isDelete'=>0,'id'=>$id));
|
|
if (count($data)>0) {
|
|
$info['id'] = $id;
|
|
$info['cCategory'] = intval($data['cCategory']);
|
|
$info['cLevel'] = intval($data['cLevel']);
|
|
$info['number'] = $data['number'];
|
|
$info['name'] = $data['name'];
|
|
$info['amount'] = (float)$data['amount'];
|
|
$info['remark'] = $data['remark'];
|
|
$info['beginDate'] = $data['beginDate'];
|
|
$info['periodMoney'] = (float)$data['periodMoney'];
|
|
$info['difMoney'] = (float)$data['difMoney'];
|
|
if ($type==10) {
|
|
$info['taxRate'] = (float)$data['taxRate'];
|
|
}
|
|
$info['pinYin'] = $data['pinYin'];
|
|
if (strlen($data['linkMans'])>0) {
|
|
$list = (array)json_decode($data['linkMans'],true);
|
|
foreach ($list as $arr=>$row) {
|
|
$v[$arr]['address'] = $row['address'];
|
|
$v[$arr]['city'] = $row['city'];
|
|
$v[$arr]['contactId'] = time();
|
|
$v[$arr]['county'] = $row['county'];
|
|
$v[$arr]['email'] = isset($row['email']) ? $row['email'] : '';
|
|
$v[$arr]['first'] = $row['linkFirst']==1 ? true : '';
|
|
$v[$arr]['id'] = $arr+1;
|
|
$v[$arr]['im'] = $row['linkIm'];
|
|
$v[$arr]['mobile'] = $row['linkMobile'];
|
|
$v[$arr]['place'] = $row['linkPlace'];
|
|
$v[$arr]['name'] = $row['linkName'];
|
|
$v[$arr]['phone'] = $row['linkPhone'];
|
|
$v[$arr]['province'] = $row['province'];
|
|
$v[$arr]['tempId'] = 0;
|
|
}
|
|
}
|
|
$info['links'] = isset($v) ? $v : array();
|
|
$json['status'] = 200;
|
|
$json['msg'] = 'success';
|
|
$json['data'] = $info;
|
|
die(json_encode($json));
|
|
}
|
|
str_alert(-1,'没有数据');
|
|
}
|
|
|
|
//新增
|
|
public function add(){
|
|
$data = $this->validform($this->input->post(NULL,TRUE));
|
|
switch ($data['type']) {
|
|
case 10:
|
|
$this->common_model->checkpurview(59);
|
|
$success = '新增客户:';
|
|
break;
|
|
case -10:
|
|
$this->common_model->checkpurview(64);
|
|
$success = '新增供应商:';
|
|
break;
|
|
default:
|
|
str_alert(-1,'参数错误');
|
|
}
|
|
$this->mysql_model->get_count('contact',array('isDelete'=>0,'type'=>$data['type'],'number'=>$data['number'])) > 0 && str_alert(-1,'编号重复');
|
|
$data = elements(array(
|
|
'name','number','amount','beginDate','cCategory',
|
|
'cCategoryName','cLevel','cLevelName','linkMans'
|
|
,'periodMoney','remark','type','difMoney'),$data,NULL);
|
|
$sql = $this->mysql_model->insert('contact',$data);
|
|
if ($sql) {
|
|
$data['id'] = $sql;
|
|
$data['cCategory'] = intval($data['cCategory']);
|
|
$data['linkMans'] = (array)json_decode($data['linkMans'],true);
|
|
$this->common_model->logs($success.$data['name']);
|
|
str_alert(200,'success',$data);
|
|
}
|
|
str_alert(-1,'添加失败');
|
|
}
|
|
|
|
|
|
//修改
|
|
public function update(){
|
|
$data = $this->validform($this->input->post(NULL,TRUE));
|
|
switch ($data['type']) {
|
|
case 10:
|
|
$this->common_model->checkpurview(60);
|
|
$success = '修改客户:';
|
|
break;
|
|
case -10:
|
|
$this->common_model->checkpurview(65);
|
|
$success = '修改供应商:';
|
|
break;
|
|
default:
|
|
str_alert(-1,'参数错误');
|
|
}
|
|
$this->mysql_model->get_count('contact',array('id !='=>$data['id'],'isDelete'=>0,'type'=>$data['type'],'number'=>$data['number'])) > 0 && str_alert(-1,'编号重复');
|
|
$info = elements(array(
|
|
'name','number','amount','beginDate','cCategory',
|
|
'cCategoryName','cLevel','cLevelName','linkMans'
|
|
,'periodMoney','remark','type','difMoney'),$data,NULL);
|
|
$sql = $this->mysql_model->update('contact',$info,array('id'=>$data['id']));
|
|
if ($sql) {
|
|
$data['cCategory'] = intval($data['cCategory']);
|
|
$data['customerType'] = $data['cCategoryName'];
|
|
$data['linkMans'] = (array)json_decode($data['linkMans'],true);
|
|
$this->common_model->logs($success.$data['name']);
|
|
str_alert(200,'success',$data);
|
|
}
|
|
str_alert(-1,'更新失败');
|
|
}
|
|
|
|
//删除
|
|
public function delete(){
|
|
$id = str_enhtml($this->input->post('id',TRUE));
|
|
$type = intval($this->input->get_post('type',TRUE))==10 ? 10 : -10;
|
|
switch ($type) {
|
|
case 10:
|
|
$this->common_model->checkpurview(61);
|
|
$success = '删除客户:';
|
|
break;
|
|
case -10:
|
|
$this->common_model->checkpurview(66);
|
|
$success = '删除供应商:';
|
|
break;
|
|
default:
|
|
str_alert(-1,'参数错误');
|
|
}
|
|
$data = $this->mysql_model->get_results('contact','(id in('.$id.'))');
|
|
if (count($data) > 0) {
|
|
$info['isDelete'] = 1;
|
|
$this->mysql_model->get_count('invoice','(isDelete=0) and (buId in('.$id.'))')>0 && str_alert(-1,'不能删除有业务往来的客户或供应商！');
|
|
$sql = $this->mysql_model->update('contact',$info,'(id in('.$id.'))');
|
|
if ($sql) {
|
|
$name = array_column($data,'name');
|
|
$this->common_model->logs($success.'ID='.$id.' 名称:'.join(',',$name));
|
|
die('{"status":200,"msg":"success","data":{"msg":"","id":['.$id.']}}');
|
|
}
|
|
}
|
|
str_alert(-1,'客户或供应商不存在');
|
|
}
|
|
|
|
|
|
//状态
|
|
public function disable(){
|
|
$this->common_model->checkpurview();
|
|
$disable = intval($this->input->post('disable',TRUE));
|
|
$id = str_enhtml($this->input->post('contactIds',TRUE));
|
|
if (strlen($id) > 0) {
|
|
$sql = $this->mysql_model->update('contact',array('disable'=>$disable),'(id in('.$id.'))');
|
|
if ($sql) {
|
|
$this->common_model->logs('客户'.$disable==1?'禁用':'启用'.':ID:'.$id.'');
|
|
str_alert(200,'success');
|
|
}
|
|
}
|
|
str_alert(-1,'操作失败');
|
|
}
|
|
|
|
//公共验证
|
|
private function validform($data) {
|
|
$this->load->library('lib_pinyin');
|
|
strlen($data['name']) < 1 && str_alert(-1,'名称不能为空');
|
|
strlen($data['number']) < 1 && str_alert(-1,'编号不能为空');
|
|
$data['cCategory'] = intval($data['cCategory']);
|
|
$data['cLevel'] = (float)$data['cLevel'];
|
|
$data['taxRate'] = isset($data['taxRate']) ? (float)$data['taxRate'] :0;
|
|
$data['periodMoney'] = (float)$data['periodMoney'];
|
|
$data['amount'] = (float)$data['amount'];
|
|
$data['linkMans'] = $data['linkMans'] ? $data['linkMans'] :"[]";
|
|
$data['beginDate'] = $data['beginDate'] ? $data['beginDate'] : date('Y-m-d');
|
|
$data['type'] = intval($this->input->get_post('type',TRUE))==10 ? 10 : -10;
|
|
$data['pinYin'] = $this->lib_pinyin->str2pinyin($data['name']);
|
|
$data['contact'] = $data['number'].' '.$data['name'];
|
|
$data['difMoney'] = $data['amount'] - $data['periodMoney'];
|
|
$data['cCategoryName'] = $this->mysql_model->get_row('category',array('id'=>$data['cCategory']),'name');
|
|
$data['cCategory'] < 1 && str_alert(-1,'类别名称不能为空');
|
|
return $data;
|
|
}
|
|
|
|
|
|
|
|
}
|
|
|
|
/* End of file welcome.php */
|
|
/* Location: ./application/controllers/welcome.php */ |