= "2016-09-01" ) { header("Location:http://sfx.zhizhuchuxing.com/"); exit(); } //DB $objDbh = new Db; $objDbh->setAccount(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DB); $objDisney = new DbDisney($objDbh); $disp_per_page = 10; if( !isset($_GET["curpage"]) || $_GET["curpage"] < 1 ) { $_GET["curpage"] = 1; } $url_param_array = array(); $extra_sql_array = array(); if( !isset($_GET["search_order_no"]) || mb_strlen($_GET["search_order_no"]) <= 0 ) { $_GET["search_order_no"] = ""; } else { $extra_sql_array[] = ' order_serial_no like "%%'.$_GET["search_order_no"].'%%" '; $url_param_array[] = 'search_order_no='.$_GET["search_order_no"]; } if( !isset($_GET["search_pay_no"]) || mb_strlen($_GET["search_pay_no"]) <= 0 ) { $_GET["search_pay_no"] = ""; } else { $extra_sql_array[] = ' pay_no like "%%'.$_GET["search_pay_no"].'%%" '; $url_param_array[] = 'search_pay_no='.$_GET["search_pay_no"]; } $base_org_info = $objDisney->getBaseOrgInfoFromCode( $_COOKIE["companycode"] ); $_GET["search_org_id"] = $base_org_info["org_id"]; $extra_sql_array[] = ' org_id='.$base_org_info["org_id"].' '; if( !isset($_GET["search_create_date"]) || mb_strlen($_GET["search_create_date"]) <= 0 ) { $_GET["search_create_date"] = ""; } else { $extra_sql_array[] = ' create_time like "%%'.$_GET["search_create_date"].'%%" '; $url_param_array[] = 'search_create_date='.$_GET["search_create_date"]; } if( !isset($_GET["search_cus_name"]) || mb_strlen($_GET["search_cus_name"]) <= 0 ) { $_GET["search_cus_name"] = ""; } else { $extra_sql_array[] = ' cus_name like "%%'.$_GET["search_cus_name"].'%%" '; $url_param_array[] = 'cus_name='.$_GET["cus_name"]; } if( !isset($_GET["search_cus_mobile"]) || mb_strlen($_GET["search_cus_mobile"]) <= 0 ) { $_GET["search_cus_mobile"] = ""; } else { $extra_sql_array[] = ' cus_mobile like "%%'.$_GET["search_cus_mobile"].'%%" '; $url_param_array[] = 'cus_mobile='.$_GET["cus_mobile"]; } $url_param = count($url_param_array) > 0 ? implode("&",$url_param_array) : 'guid=ON'; $limit = " ORDER BY create_time DESC LIMIT ".(($_GET["curpage"]-1)*$disp_per_page).",".$disp_per_page; //DB $objDbh = new Db; $objDbh->setAccount(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DB); $objDisney = new DbDisney($objDbh); $extra_sql = count($extra_sql_array) > 0 ? implode( " AND ", $extra_sql_array ): false; $order_array = $objDisney->getActiceOrderCommonArray( $extra_sql, $limit ); $all_count = $objDisney->getActiveOrderCommonCount( $extra_sql ); $org_array = $objDisney->getBaseOrgArray(); $org_temp_array = array(); foreach( $org_array as $org_info ) { $org_temp_array[$org_info["org_id"]] = $org_info; } $org_array = $org_temp_array; $max_page = ceil($all_count/$disp_per_page); $url_base = $page_name."?".$url_param; ?>
订单编号 | 订单内容 | 订单金额 | 订单源 | 下单时间 | 支付信息 | 用户信息 | '.$order_info["order_serial_no"].' | '; echo ''.$order_info["prod_name"]." "; echo $order_info["start_day"]; if( mb_strlen($order_info["start_time"]) > 0 ) { echo " ".$order_info["start_time"]; } if( $order_info["prod_id"] == 1 || $order_info["prod_id"] == 2) { echo "-".$order_info["end_day"]." ".$order_info["end_time"]; if( mb_strlen($order_info["start_time2"]) > 0 ) { echo " ".$order_info["start_day2"]." ".$order_info["start_time2"]."-".$order_info["end_day2"]." ".$order_info["end_time2"]; } } echo ' | ';
echo ''.$order_info["order_price"].' | '; if( isset($org_array[$order_info["org_id"]]) ) { echo ''.$org_array[$order_info["org_id"]]["org_name"].' | '; } else { echo '- | '; } echo ''.$order_info["create_time"].' | '; if( $order_info['is_payed'] == 1 ) { echo ''.$_ary_pay_type[$order_info['pay_type']].' 支付号:'.$order_info["pay_no"] . ' | ';
} else if( $order_info['order_user_id'] > 0 ){
echo '酒店代收现金 | '; } else { echo '未支付 | '; } echo ''.$order_info["cus_name"].' '.$order_info["cus_mobile"].' '.$order_info["cus_iden"].' | ';
//echo ''; echo ''; } ?> |