$value
$value :
+------------------------------------------------------------------------------ Framk PHP框架 +------------------------------------------------------------------------------
<?php
/*
*
* crm.Contract 客户销售合同管理
*
* =========================================================
* 零起飞网络 - 专注于网站建设服务和行业系统开发
* 以质量求生存，以服务谋发展，以信誉创品牌 !
* ----------------------------------------------
* @copyright Copyright (C) 2017-2018 07FLY Network Technology Co,LTD (www.07FLY.com) All rights reserved.
* @license For licensing, see LICENSE.html or http://www.07fly.xyz/crm/license
* @author ：kfrs <goodkfrs@QQ.com> 574249366
* @version ：1.0
* @link ：http://www.07fly.xyz
*/
class SalContract extends Action{
private $cacheDir='';//缓存目录
public function __construct() {
//_instance('Action/wap/Auth');
$this->sys_user=_instance('Action/sysmanage/User');
$this->dict=_instance('Action/crm/CstDict');
$this->customer=_instance('Action/crm/CstCustomer');
$this->linkman=_instance('Action/crm/CstLinkman');
//$this->SalContractDetail = _instance('Action/SalContractDetail');
}
public function sal_contract(){
//**获得传送来的数据作分页处理
$pageNum = $this->_REQUEST("pageNum");//第几页
$pageSize= $this->_REQUEST("pageSize");//每页多少条
$pageNum = empty($pageNum)?1:$pageNum;
$pageSize= empty($pageSize)?$GLOBALS["pageSize"]:$pageSize;
//**************************************************************************
//**获得传送来的数据做条件来查询
$title = $this->_REQUEST("title");
$customer_id =$this->_REQUEST("customer_id");
$customer_name = $this->_REQUEST("customer_name");
$salestage = $this->_REQUEST("salestage");
$start_date = $this->_REQUEST("start_date");
$end_date = $this->_REQUEST("end_date");
$where_str = "s.customer_id=c.customer_id and c.owner_user_id in (".SYS_USER_VIEW.")";
if( !empty($title) ){
$where_str .=" and s.title like '%$title%'";
}
if(!empty($customer_id) ){
$where_str .=" and s.customer_id='$customer_id'";
}
if(!empty($address) ){
$where_str .=" and s.address like '%$address%'";
}
if(!empty($customer_name) ){
$where_str .=" and c.name like '%$customer_name%'";
}
//到期时间
if( !empty($start_date) ){
switch($start_date){
case '3d' :
$date_range=date('Y-m-d',strtotime("-3 day",time()));
break;
case '7d' :
$date_range=date('Y-m-d',strtotime("-7 day",time()));
break;
case '15d' :
$date_range=date('Y-m-d',strtotime("-15 day",time()));
break;
case '1m' :
$date_range=date('Y-m-d',strtotime("-1 month",time()));
break;
case '3m' :
$date_range=date('Y-m-d',strtotime("-3 month",time()));
break;
case '6m' :
$date_range=date('Y-m-d',strtotime("-6 month",time()));
break;
case '12m' :
$date_range=date('Y-m-d',strtotime("-12 month",time()));
break;
}
$where_str .=" and s.start_date>'$date_range'";
}
//到期时间
if( !empty($end_date) ){
switch($end_date){
case '3d' :
$date_range=date('Y-m-d',strtotime("+3 day",time()));
break;
case '7d' :
$date_range=date('Y-m-d',strtotime("+7 day",time()));
break;
case '15d' :
$date_range=date('Y-m-d',strtotime("+15 day",time()));
break;
case '1m' :
$date_range=date('Y-m-d',strtotime("+1 month",time()));
break;
case '3m' :
$date_range=date('Y-m-d',strtotime("+3 month",time()));
break;
case '6m' :
$date_range=date('Y-m-d',strtotime("+6 month",time()));
break;
case '12m' :
$date_range=date('Y-m-d',strtotime("+12 month",time()));
break;
}
$where_str .=" and s.end_date<'$date_range'";
}
//排序操作
$orderField = $this->_REQUEST("orderField");
$orderDirection = $this->_REQUEST("orderDirection");
$order_by="order by";
if( $orderField=='by_customer' ){
$order_by .=" s.customer_id $orderDirection";
}else if($orderField=='by_startdate'){
$order_by .=" s.start_date $orderDirection";
}else if($orderField=='by_enddate'){
$order_by .=" s.end_date $orderDirection";
}else if($orderField=='by_money'){
$order_by .=" s.money $orderDirection";
}else if($orderField=='by_backmoney'){
$order_by .=" s.back_money $orderDirection";
}else if($orderField=='by_owemoney'){
$order_by .=" s.owe_money $orderDirection";
}else{
$order_by .=" s.contract_id desc";
}
//**************************************************************************
$countSql = "select s.* from sal_contract as s,cst_customer as c where $where_str";
$totalCount = $this->C($this->cacheDir)->countRecords($countSql);
$beginRecord= ($pageNum-1)*$pageSize;//计算开始行数
$sql = "select s.*,c.name as customer_name from sal_contract as s,cst_customer as c
where $where_str $order_by limit $beginRecord,$pageSize";
$list = $this->C($this->cacheDir)->findAll($sql);
$operate = array();
foreach($list as $key=>$row){
$list[$key]['linkman'] =$this->linkman->cst_linkman_get_one($row['linkman_id']);
$list[$key]['status_arr'] =$this->sal_contract_status($row['status']);
$list[$key]['deliver_status_arr'] =$this->sal_contract_deliver_status($row['deliver_status']);
$list[$key]['invoice_status_arr'] =$this->sal_contract_invoice_status($row['invoice_status']);
$list[$key]['back_status_arr'] =$this->sal_contract_back_status($row['back_status']);
$list[$key]['our_user_arr'] =$this->sys_user->user_get_one($row['our_user_id']);
}
$assignArray = array('list'=>$list,"pageSize"=>$pageSize,"totalCount"=>$totalCount,"pageNum"=>$pageNum,"statusCode"=>200);
return $assignArray;
}
public function sal_contract_json(){
$assArr = $this->sal_contract();
echo json_encode($assArr);
}
//合同显示
public function sal_contract_show(){
$smarty = $this->setSmarty();
//$smarty->assign($assArr);
$smarty->display('crm/sal_contract_show.html');
}
//查看一条合同详细
public function sal_contract_detail(){
$contract_id= $this->_REQUEST("contract_id");
$one = $this->sal_contract_get_one($contract_id);
$one['customer'] =$this->customer->cst_customer_get_one($one['customer_id']);
$one['linkman'] =$this->linkman->cst_linkman_get_one($one['linkman_id']);
$one['status_arr'] =$this->sal_contract_status($one['status']);
$one['invoice_status_arr'] =$this->sal_contract_invoice_status($one['invoice_status']);
$one['back_status_arr'] =$this->sal_contract_back_status($one['back_status']);
$one['our_user_arr'] =$this->sys_user->user_get_one($one['our_user_id']);
$smarty = $this->setSmarty();
$smarty->assign(array("one"=>$one));
$smarty->display('crm/sal_contract_detail.html');
}
public function sal_contract_add(){
$customer_id= $this->_REQUEST("customer_id");
if(empty($_POST)){
$customer=$this->customer->cst_customer_list();
$sys_user=$this->sys_user->user_list();
$number = date("ymdH").rand(10,99);
$smarty = $this->setSmarty();
$smarty->assign(array("number"=>$number,"customer_id"=>$customer_id,"customer"=>$customer,"sys_user"=>$sys_user));
$smarty->display('crm/sal_contract_add.html');
}else{
$into_data=array(
'contract_no'=>$this->_REQUEST("contract_no"),
'customer_id'=>$this->_REQUEST("customer_id"),
'linkman_id'=>$this->_REQUEST("linkman_id"),
'chance_id'=>$this->_REQUEST("chance_id"),
'start_date'=>$this->_REQUEST("start_date"),
'end_date'=>$this->_REQUEST("end_date"),
'title'=>$this->_REQUEST("title"),
'money'=>$this->_REQUEST("money"),
'owe_money'=>$this->_REQUEST("money"),
'our_user_id'=>$this->_REQUEST("our_user_id"),
'intro'=>$this->_REQUEST("intro"),
'create_time'=>NOWTIME,
'create_user_id'=>SYS_USER_ID,
);
if($this->C($this->cacheDir)->insert('sal_contract',$into_data)){
$this->L("Common")->ajax_json_success("操作成功");
}
}
}
public function sal_contract_add_save($data){
if($this->C($this->cacheDir)->insert('sal_contract',$data)){
return ture;
}else{
return flase;
}
}
//查询一条记录
public function sal_contract_get_one($contract_id=""){
$sql = "select * from sal_contract where contract_id='$contract_id'";
$one = $this->C($this->cacheDir)->findOne($sql);
return $one;
}
//查询一条记录
public function sal_contract_get_one_json($contract_id=""){
$contract_id= $this->_REQUEST("contract_id");
$one = $this->sal_contract_get_one($contract_id);
echo json_encode($one);
}
//修改
public function sal_contract_modify(){
$contract_id= $this->_REQUEST("contract_id");
if(empty($_POST)){
$sql = "select * from sal_contract where contract_id='$contract_id'";
$one = $this->C($this->cacheDir)->findOne($sql);
$customer=$this->customer->cst_customer_list();
$sys_user=$this->sys_user->user_list();
$smarty = $this->setSmarty();
$smarty->assign(array("one"=>$one,"customer"=>$customer,"sys_user"=>$sys_user));
$smarty->display('crm/sal_contract_modify.html');
}else{//更新保存数据
$into_data=array(
'contract_no'=>$this->_REQUEST("contract_no"),
'customer_id'=>$this->_REQUEST("customer_id"),
'linkman_id'=>$this->_REQUEST("linkman_id"),
'chance_id'=>$this->_REQUEST("chance_id"),
'start_date'=>$this->_REQUEST("start_date"),
'end_date'=>$this->_REQUEST("end_date"),
'title'=>$this->_REQUEST("title"),
'money'=>$this->_REQUEST("money"),
'owe_money'=>$this->_REQUEST("money"),
'our_user_id'=>$this->_REQUEST("our_user_id"),
'intro'=>$this->_REQUEST("intro"),
'create_time'=>NOWTIME,
'create_user_id'=>SYS_USER_ID,
);
if($this->C($this->cacheDir)->modify('sal_contract',$into_data,"contract_id='$contract_id'")){
$this->L("Common")->ajax_json_success("操作成功");
}
}
}
//订单删除
public function sal_contract_del(){
$contract_id = $this->_REQUEST("contract_id");
if(!empty($contract_id)){
$contract_arr=explode(",",$contract_id);
foreach($contract_arr as $con_id){
$this->C($this->cacheDir)->delete('sal_contract',"contract_id in ($con_id)");
$this->C($this->cacheDir)->delete('sal_contract_list',"contract_id in ($con_id)");
}
$this->L("Common")->ajax_json_success("操作成功");
}else{
$this->L("Common")->ajax_json_error("操作失败,只能批量删除状态为临时单");
}
}
//下拉选择回放数据,显示未付款，及部分的合同
public function sal_contract_select_back(){
$customer_id =$this->_REQUEST("customer_id");
$where_str ="and back_status in(1,2)";
$sql ="select contract_id,title from sal_contract where customer_id='$customer_id' $where_str order by contract_id asc;";
$list =$this->C($this->cacheDir)->findAll($sql);
echo json_encode($list);
}
//拉选择回放数据,显示未付款，及部分的合同
public function sal_contract_select_invoice(){
$customer_id =$this->_REQUEST("customer_id");
$where_str ="and invoice_status in(1,2)";
$sql ="select contract_id,title from sal_contract where customer_id='$customer_id' $where_str order by contract_id asc;";
$list =$this->C($this->cacheDir)->findAll($sql);
echo json_encode($list);
}
//审核
public function sal_contract_audit(){
$id = $this->_REQUEST("id");
$status = $this->_REQUEST("status");
$sql= "update sal_contract set status='$status' where id='$id'";
$this->C($this->cacheDir)->update($sql);
$this->L("Common")->ajax_json_success("操作成功");
}
//合同状态
public function sal_contract_status($key=null){
$data=array(
"1"=>array(
'status_name'=>'临时单',
'status_name_html'=>'<span class="label label-warning">临时单<span>',
'status_operation' => array(
'0' => array(
'act' => 'detail',
'color' => '#7266BA',
'name' => '详细'
),
'1' => array(
'act' => 'list_add',
'color' => '#23B7E5',
'name' => '编辑清单'
),
'2' => array(
'act' => 'modify',
'color' => '#23B7E5',
'name' => '修改合同'
),
'3' => array(
'act' => 'delete',
'color' => '#F05050',
'name' => '删除'
),
),
),
"2"=>array(
'status_name'=>'执行中',
'status_name_html'=>'<span class="label label-info">执行中<span>',
'status_operation' => array(
'0' => array(
'act' => 'detail',
'color' => '#7266BA',
'name' => '详细'
),
'1' => array(
'act' => 'list_detail',
'color' => '#23B7E5',
'name' => '查看清单'
)
),
),
"3"=>array(
'status_name'=>'完成',
'status_name_html'=>'<span class="label label-success">完成<span>',
'status_operation' => array(
'0' => array(
'act' => 'detail',
'color' => '#7266BA',
'name' => '详细'
),
'1' => array(
'act' => 'list_detail',
'color' => '#23B7E5',
'name' => '查看清单'
)
),
),
"4"=>array(
'status_name'=>'撤销',
'status_name_html'=>'<span class="label label-danger">撤销<span>',
'status_operation' => array(
'0' => array(
'act' => 'detail',
'color' => '#7266BA',
'name' => '详细'
),
'1' => array(
'act' => 'list_add',
'color' => '#23B7E5',
'name' => '编辑清单'
),
'2' => array(
'act' => 'modify',
'color' => '#23B7E5',
'name' => '修改合同'
),
'3' => array(
'act' => 'delete',
'color' => '#F05050',
'name' => '删除'
),
),
)
);
return ($key)?$data[$key]:$data;
}
//回款状态
public function sal_contract_back_status($key=null){
$data=array(
"1"=>array(
'status_name'=>'未付',
'color'=>'#FAD733',
'status_name_html'=>'<span class="label label-warning">未付<span>',
),
"2"=>array(
'status_name'=>'部分',
'color'=>'#23B7E5',
'status_name_html'=>'<span class="label label-info">部分<span>',
),
"3"=>array(
'status_name'=>'已付',
'color'=>'#27C24C',
'status_name_html'=>'<span class="label label-sucess">已付<span>',
)
);
return ($key)?$data[$key]:$data;
}
//交货状态
public function sal_contract_deliver_status($key=null){
$data=array(
"1"=>array(
'status_name'=>'需要',
'status_name_html'=>'<span class="label label-warning">需要<span>',
'status_operation' => array(
'0' => array(
'act' => 'list_add',
'color' => '#23B7E5',
'name' => '录入明细'
)
),
),
"2"=>array(
'status_name'=>'已录明细',
'status_name_html'=>'<span class="label label-primary">已录明细<span>',
'status_operation' => array(
'0' => array(
'act' => 'stock_out',
'color' => '#7266BA',
'name' => '生成入库单'
),
'1' => array(
'act' => 'list_del',
'color' => '#F05050',
'name' => '删除明细'
)
),
),
"3"=>array(
'status_name'=>'待入库',
'status_name_html'=>'<span class="label label-danger">待入库<span>',
'status_operation' => array( ),
),
"4"=>array(
'status_name'=>'部分',
'status_name_html'=>'<span class="label label-info">部分<span>',
'status_operation' => array(
'0' => array(
'act' => 'stock_out',
'color' => '#23B7E5',
'name' => '生成入库单'
),
),
),
"5"=>array(
'status_name'=>'全部',
'status_name_html'=>'<span class="sucess">全部<span>',
'status_operation' => array(),
)
);
return ($key)?$data[$key]:$data;
}
//发票状态
public function sal_contract_invoice_status($key=null){
$data=array(
"0"=>array(
'status_name'=>'不需要',
'color'=>'#7266BA',
'status_name_html'=>'<span class="label label-info">需要<span>',
),
"1"=>array(
'status_name'=>'需要',
'color'=>'#FAD733',
'status_name_html'=>'<span class="label label-info">需要<span>',
),
"2"=>array(
'status_name'=>'部分',
'color'=>'#23B7E5',
'status_name_html'=>'<span class="label label-info">部分<span>',
),
"3"=>array(
'status_name'=>'全部',
'color'=>'#27C24C',
'status_name_html'=>'<span class="label label-info">全部<span>',
)
);
return ($key)?$data[$key]:$data;
}
//付款修改合同付付款状态功能
public function sal_contract_modify_status($contract_id){
$one =$this->sal_contract_get_one($contract_id);
$back_status=$one['back_status'];
$invoice_status=$one['invoice_status'];
$deliver_status=$one['deliver_status'];//0表示不需要交付
//回款，发票，都开完了
if($back_status=='3' && $invoice_status=='3' && $deliver_status=='5'){
$status='3';//完成状态
}else if($back_status=='3' && $invoice_status=='3' && $deliver_status=='0'){
$status='3';//完成状态
}else if($back_status=='1' && $invoice_status=='1' && $deliver_status=='1'){
$status='1';//临时状态
}else if($back_status=='1' && $invoice_status=='1' && $deliver_status=='0'){
$status='1';//临时状态
}else{
$status='2';
}
$upd_date=array('status'=>$status);
$this->C($this->cacheDir)->modify('sal_contract',$upd_date,"contract_id='$contract_id'");
return true;
}
//出库库之后改合同付收货状态功能
public function sal_contract_modify_deliver_status($contract_id){
$totalSql= "select sum(owe_num) as total_owe_num,sum(out_num) as total_out_num,sum(num) as total_num
from sal_contract_list where contract_id='$contract_id'";
$totalRs = $this->C($this->cacheDir)->findOne($totalSql);
if($totalRs['total_owe_num']>0){
$deliver_status='4';
}else if($totalRs['total_owe_num']==0){
$deliver_status='5';
}
if($totalRs['total_out_num']==0){
$deliver_status='2';
}
if($totalRs['total_num']==0){
$deliver_status='1';
}
$this->C($this->cacheDir)->modify('sal_contract',array('deliver_status'=>$deliver_status),"contract_id='$contract_id'");
return true;
}
}
?>