"typezf","name"=>'支付类型',"value"=>$arr_data['pay']); $search_list[] = array("param"=>"typedd","name"=>'订单类型',"value"=>$arr_data['ordertype']); $search_list[] = array("param"=>"order_state","name"=>'订单状态',"value"=>array("0"=>"支付失败","1"=>"等待付款","2"=>"支付成功","3"=>"等待确认")); $lo_time = array('1'=>'今天','3'=>'最近三天','7'=>'最近七天','15'=>'最近半月','30'=>'最近一个月'); $search_list[] = array("param"=>"time","name"=>'充值时间',"value"=>$lo_time); $this -> yunset("search_list",$search_list); } function index_action() { $this -> set_search(); $OrderM = $this -> MODEL('companyorder'); $where = array(); $urlarr = $_GET; $keywordStr = trim($_GET['keyword']); if($_GET['comid']){ $where['uid'] = $_GET['comid']; $where['usertype'] = '2'; $urlarr['comid'] = $_GET['comid']; } if($_GET['typezf']!=""){ $where['order_type'] = $_GET['typezf']; $urlarr['typezf'] = $_GET['typezf']; } if($_GET['typedd']!=""){ $where['type'] = $_GET['typedd']; $urlarr['typedd'] = $_GET['typedd']; } if($_GET['news_search']){ if (!empty($keywordStr) && $_GET['typeca']=='1') { $where['order_id'] = array('like', $keywordStr); }elseif(!empty($keywordStr) && $_GET['typeca']=='2'){ $UserinfoM = $this -> MODEL('userinfo'); $orderinfo = $UserinfoM -> getList(array('username'=>array('like',$keywordStr)),array('field'=>'uid')); if (is_array($orderinfo)){ foreach ($orderinfo as $val){ $orderuids[] = $val['uid']; } $where['uid'] = array('in', pylode(",",$orderuids)); } }elseif(!empty($keywordStr) && $_GET['typeca']=='3'){ $UserinfoM = $this -> MODEL('userinfo'); $mWhere = array( '1' => array('name' => array('like', $_GET['keyword'])), '2' => array('name' => array('like', $_GET['keyword'])), '3' => array('realname' => array('like', $_GET['keyword'])), '4' => array('name' => array('like', $_GET['keyword'])) ); $m_uids = $UserinfoM -> getUidsByWhere($mWhere); $where['uid'] = array('in', pylode(",",$m_uids)); } $urlarr['keyword'] = $keywordStr; $urlarr['typeca'] = $_GET['typeca']; $urlarr['news_search'] = $_GET['news_search']; } if(isset($_GET['time']) || $_GET['time_start1'] != "" || $_GET['time_end1'] != ""){ $where['PHPYUNBTWSTART_B'] = 'AND'; if($_GET['time']){ if($_GET['time'] == 1){ $where['order_time'][] = array('>=',strtotime(date("Y-m-d 00:00:00"))); }else{ $where['order_time'][] = array('>=',strtotime('-'.intval($_GET['time']).' day')); } $urlarr['time'] = $_GET['time']; } if($_GET['time_start1']!=""){ $where['order_time'][] = array('>=',strtotime($_GET['time_start1']." 00:00:00")); $urlarr['time_start1'] = $_GET['time_start1']; } if($_GET['time_end1']!=""){ $where['order_time'][] = array('<',strtotime($_GET['time_end1']." 23:59:59")); $urlarr['time_end1'] = $_GET['time_end1']; } $where['PHPYUNBTWEND_B'] = ''; } if(isset($_GET['order_state']) && $_GET['order_state']!=""){ $where['order_state'] = $_GET['order_state']; $urlarr['order_state'] = $_GET['order_state']; } if(isset($_GET['fb']) && $_GET['fb']!=""){ $where['is_invoice'] = $_GET['fb']; $urlarr['fb'] = $_GET['fb']; } $urlarr['page'] = "{{page}}"; $pageurl = Url($_GET['m'],$urlarr,'admin'); $pageM = $this->MODEL('page'); $pages = $pageM->pageList('company_order',$where,$pageurl,$_GET['page']); if($pages['total'] > 0){ if($_GET['order']){ $where['orderby'] = $_GET['t'].','.$_GET['order']; $urlarr['order'] = $_GET['order']; $urlarr['t'] = $_GET['t']; }else{ $where['orderby'] = array('id,desc'); } $where['limit'] = $pages['limit']; $rows = $OrderM -> getList($where,array('utype'=>'admin','field'=>'id,uid,order_id,order_price,type,order_state,order_type,order_time,once_id,crm_uid')); unset($where['limit']); session_start(); $_SESSION['orderXls'] = $where; } $this->yunset("rows",$rows); $this->yuntpl(array('admin/admin_company_order')); } function edit_action() { $OrderM = $this->MODEL('companyorder'); $row = $OrderM->getInfo(array('id' => $_GET['id'])); if (isset($row) && $row['coupon']) { $couponM = $this->MODEL('coupon'); $coupon = $couponM->getCouponListOne(array('id' => $row['coupon']), array('field' => 'id,coupon_amount')); if ($coupon) { $row['price'] = number_format(($row['order_price'] + $coupon['coupon_amount']), 2); $row['order_price'] = number_format($row['order_price'], 2); $coupon['coupon_amount'] = number_format($coupon['coupon_amount'], 2); } $this->yunset('coupon', $coupon); } $this->yunset('row', $row); $this->yuntpl(array('admin/admin_company_order_edit')); } function save_action() { $id = intval($_POST['id']); $OrderM = $this->MODEL('companyorder'); $mData = array( 'order_price' => $_POST['order_price'], 'order_remark' => $_POST['order_remark'], 'is_invoice' => $_POST['is_invoice'] ); $return = $OrderM->upInfo($id, $mData); $this->ACT_layer_msg($return['msg'], $return['errcode'], "index.php?m=company_order"); } function setpay_action() { $this->check_token(); $id = intval($_GET['id']); $OrderM = $this->MODEL('companyorder'); $return = $OrderM->setPay($id); $this->layer_msg($return['msg'], $return['errcode'], 0, $_SERVER['HTTP_REFERER']); } function xls_action() { $where = $_SESSION['orderXls'] ? $_SESSION['orderXls'] : array('orderby' => 'id'); $OrderM = $this->MODEL('companyorder'); if ($_POST['uid']) { $where['id'] = array('in', pylode(',', $_POST['uid'])); } if ($_GET['time_start'] != "" || $_GET['time_end'] != "") { $where['PHPYUNBTWSTART_B'] = 'AND'; if ($_GET['time_start'] != "") { $where['order_time'] = array('>=', substr($_POST['time_start'], 0, strlen($_POST['time_start']) - 3)); } if ($_GET['time_end'] != "") { $where['order_time'] = array('<', substr($_POST['time_end'], 0, strlen($_POST['time_end']) - 3)); } $where['PHPYUNBTWEND_B'] = ''; } $rows = $OrderM->getList($where, array('utype' => 'admin', 'field' => 'id,uid,order_id,order_price,type,order_state,order_type,order_time,once_id')); if (!empty($rows)) { $this->yunset("list", $rows); $this->MODEL('log')->addAdminLog("导出支付订单信息"); header("Content-Type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename=order.xls"); $this->yuntpl(array('admin/admin_order_xls')); } else { $this->ACT_layer_msg("没有可以导出的订单信息!", 8, $_SERVER['HTTP_REFERER']); } } function del_action() { $this->check_token(); $OrderM = $this->MODEL('companyorder'); $delID = is_array($_GET['del']) ? $_GET['del'] : $_GET['id']; $return = $OrderM->del($delID, array('utype' => 'admin')); $this->layer_msg($return['msg'], $return['errcode'], $return['layertype'], $_SERVER['HTTP_REFERER']); } function orderSum_action() { $where = $_SESSION['orderXls'] ? $_SESSION['orderXls']:array(); $MsgNum = $this->MODEL('msgNum'); echo $MsgNum->orderSum($where); } } ?>