<?php
class expressAction extends baseAction
{
   /**
	* @method 快递库
	* @author xu
	* @copyright 2017/7/14
	* @return array(array('EXP_ID'=>1,'EXP_STATUS'=>1,'EXP_NAME'=>'圆通速递','EXP_URL'=>'http://www.baidu.com','EXP_INITIAL'=>,'EXP_TEL'=>'089-97218','EXP_SEQ'=>999),...)
	*/
	function exprelib()
	{
		$Params = mvc::$URL_PARAMS;
		//获取当前页码和设置每页条数
		$NowPage = isset($Params['page']) && $Params['page'] > 0 ? (int) $Params['page']:1;
		$PerPage = empty($_COOKIE['perPage'])? 20: (int) $_COOKIE['perPage'];
		//获取总条数
		$B2cBase = new B2cBase();
		$Res = $B2cBase->get('or_express', ['count(1) count'], $Where, true);
		$total = $Res['data']['count'];
		if($total > 0)
		{
			$table='or_express';
			$where = sprintf(" order by exp_seq asc limit %d,%d", ($NowPage-1)*$PerPage, $PerPage);
	   		$data = $B2cBase->get($table, ['*'], $where);
	   		//获取当前分页数据
			LibTpl::Set('expreLibArr',$data['data']);
		}
		//获取页码
		$Page = LibPage::Show($total, $PerPage);
		LibTpl::Set('Page', $Page);
		LibTpl::Put();
	}


   /**
	* @method 保存快递编辑结果
	* @author xu
	* @copyright 2017/7/14
	* @return 成功：{'status':true,'data':'success','code':0} 失败：{'status':false,'data':'error'/'参数错误！','code':0}
	*/
	function saveEditExpre()
	{
		$B2cBase = new B2cBase();
		//用于拼接sql的id进行过滤处理
		if(!LibFc::Int($_POST['id']))
		{	
			$msg = array('status'=>false,'data'=>'参数错误！','code'=>0);
			return LibFc::ajaxJsonEncode($msg);
		}
		$id = $_POST['id'];

		$table = "or_express";
		$where = sprintf(" and EXP_ID=%d",$id);
		//在b2cbase里面set对参数已经有过滤这里不再进行过滤处理
		$DataArr = array('exp_name'=>$_POST['name'],'exp_url'=>$_POST['url'],'exp_tel'=>$_POST['tel']);
		$res = $B2cBase->set($table,$DataArr,$where);
		if($res['data']>0)
		{	
			$array = array('status'=>true,'data'=>'success','code'=>0);
			LibFc::ajaxJsonEncode($array);
		}
		else
		{	
			$array = array('status'=>false,'data'=>'error','code'=>0);
			LibFc::ajaxJsonEncode($array);
		}
	}


   /**
	* @method 新增快递
	* @author xu
	* @copyright 2017/7/14
	* @return 成功：{'status':true,'data':'success','code':0} 失败：{'status':false,'data':'error','code':0}
	*/
	function saveAddExpre()
	{
		$B2cBase = new B2cBase();
		$table = "or_express";
		////在b2cbase里面set对参数已经有过滤这里不再进行过滤处理
		$DataArr = array('exp_status'=>$_POST['status'],'exp_id'=>$EXP_ID,'exp_name'=>$_POST['name'],'exp_url'=>$_POST['url'],'exp_tel'=>$_POST['tel'],'exp_seq'=>$_POST['exp_seq']);
		$res = $B2cBase->add($table,$DataArr);
		$EXP_ID =$res['data'];
		$array = array('status'=>true,'data'=>'success','code'=>$EXP_ID);
		LibFc::ajaxJsonEncode($array);
	}


   /**
	* @method 删除快递
	* @author xu
	* @copyright 2017/7/14
	* @return 成功：{'status':true,'data':'success','code':0} 失败：{'status':false,'data':'error'/'参数错误！','code':0}
	*/
	function delExpre()
	{
		$B2cBase = new B2cBase();
		//对拼接sql的参数进行过滤处理
		if(!LibFc::Int($_POST['EXP_ID']))
		{	
			$msg = array('status'=>false,'data'=>'参数错误！','code'=>0);
			return LibFc::ajaxJsonEncode($msg);
		}
		$table = "or_express";
		$where = sprintf(" and exp_id=%d",$_POST['EXP_ID']);
		$res = $B2cBase->del($table,$where);
		if($res['data']>0)
		{	
			$array = array('status'=>true,'data'=>'success','code'=>0);
			LibFc::ajaxJsonEncode($array);
		}
		else
		{	
			$array = array('status'=>false,'data'=>'error','code'=>0);
			LibFc::ajaxJsonEncode($array);
		}
	}


   /**
	* @method 快递ajax更改状态
	* @author xu
	* @copyright 2017/7/14
	* @return 成功：{'status':true,'data':'success','code':0} 失败：{'status':false,'data':'error'/'参数错误！','code':0}
	*/
	function togStatus()
	{
		$B2cBase = new B2cBase();
		//类型判定
		if(!LibFc::Int($_POST['EXP_ID']))
		{	
			$msg = array('status'=>false,'data'=>'参数错误！','code'=>0);
			return LibFc::ajaxJsonEncode($msg);
		}
		$id = $_POST['EXP_ID'];
		$table = "or_express";
		$where = sprintf(" and exp_id=%d",$id);
		//对传过来的status做状态判定
		if($_POST['STATUS'] == 'on')
		{
			$DataArr = array('exp_status'=>1);
		}
		elseif($_POST['STATUS'] == 'off')
		{
			$DataArr = array('exp_status'=>0);
		}
		else
		{
			$msg = array('status'=>false,'data'=>'参数错误！','code'=>0);
			return LibFc::ajaxJsonEncode($msg);
		}
		$res = $B2cBase->set($table,$DataArr,$where);
		if($res['data']>0)
		{	
			$array = array('status'=>true,'data'=>'success','code'=>0);
			LibFc::ajaxJsonEncode($array);
		}
		else
		{	
			$array = array('status'=>false,'data'=>'error','code'=>0);
			LibFc::ajaxJsonEncode($array);
		}
	}

   /**
	* @method 快递ajax排序
	* @author xu
	* @copyright 2017/7/14
	* @return 成功：{'status':true,'data':'success','code':0} 失败：{'status':false,'data':'error'/'参数错误！','code':0}
	*/
	function reSort()
	{
		$B2cBase = new B2cBase();
		if(!LibFc::Int($_POST['EXP_ID'])||!LibFc::Int($_POST['EXP_SEQ']))
		{	
			$msg = array('status'=>false,'data'=>'参数错误！','code'=>0);
			return LibFc::ajaxJsonEncode($msg);
		}
		$id = $_POST['EXP_ID'];
		$EXP_SEQ = $_POST['EXP_SEQ'];
		$table = "or_express";
		$where = sprintf(" and exp_id=%d",$id);
		$DataArr = array('exp_seq'=>$EXP_SEQ);
		$res = $B2cBase->set($table,$DataArr,$where);
		if($res['data']>0)
		{	
			$array = array('status'=>true,'data'=>'success','code'=>0);
			LibFc::ajaxJsonEncode($array);
		}
		else
		{	
			$array = array('status'=>false,'data'=>'error','code'=>0);
			LibFc::ajaxJsonEncode($array);
		}
	}
}