function initPcGoodsCombine()
{
$omAvailableAct = new OmAvailableAct();
$where = 'WHERE is_delete=0 ';
$pcGoodsCombineList = $omAvailableAct->act_getTNameList('pc_goods_combine', '*', $where);
if (count($pcGoodsCombineList) == 0) {
return false;
}
$expire = 0;
global $memc_obj;
foreach ($pcGoodsCombineList as $value) {
$combineSku = $value['combineSku'];
$relationArr = array();
$relationList = $omAvailableAct->act_getTNameList('pc_sku_combine_relation', 'sku,count', "WHERE combineSku='{$combineSku}'");
if (!empty($relationList)) {
foreach ($relationList as $tmp) {
$relationArr[] = $tmp;
}
}
$value['detail'] = $relationArr;
$key = 'pc_goods_combine_' . $combineSku;
$ret = $memc_obj->set_extral($key, $value, $expire);
echo 'key=' . $key . "\n";
if (!$ret) {
echo $key;
echo '写入缓存出错,请查看mencache相关信息';
return false;
}
}
return true;
}
function initPcGoodsCategorys()
{
$omAvailableAct = new OmAvailableAct();
$where = 'WHERE is_delete=0 ';
$pcGoodsCategoryList = $omAvailableAct->act_getTNameList('pc_goods_category', '*', $where);
if (count($pcGoodsCategoryList) == 0) {
return false;
}
$expire = 0;
global $memc_obj;
$key = 'pc_goods_category_all';
$ret = $memc_obj->set_extral($key, $pcGoodsCategoryList, $expire);
echo 'key=' . $key . "\n";
if (!$ret) {
echo $key;
echo '写入缓存出错,请查看mencache相关信息';
return false;
}
return true;
}
public function view_getSpuPrefixList()
{
//调用action层， 获取列表数据
$omAvailableAct = new OmAvailableAct();
$status = $_GET['status'] ? $_GET['status'] : '';
$tName = 'pc_auto_create_spu_prefix';
$select = '*';
$where = 'WHERE 1=1 ';
$total = $omAvailableAct->act_getTNameCount($tName, $where);
$num = 100;
//每页显示的个数
$page = new Page($total, $num, '', 'CN');
$where .= "order by id " . $page->limit;
$spuPrefixList = $omAvailableAct->act_getTNameList($tName, $select, $where);
if (!empty($_GET['page'])) {
if (intval($_GET['page']) <= 1 || intval($_GET['page']) > ceil($total / $num)) {
$n = 1;
} else {
$n = (intval($_GET['page']) - 1) * $num + 1;
}
} else {
$n = 1;
}
if ($total > $num) {
$show_page = $page->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9));
} else {
$show_page = $page->fpage(array(0, 2, 3));
}
$navlist = array(array('url' => 'index.php?mod=autoCreateSpu&act=getAutoCreatePrefixList', 'title' => 'SPU管理'), array('url' => 'index.php?mod=spu&act=getSpuPrefixList', 'title' => 'SPU自动生成前缀管理'));
$this->smarty->assign('navlist', $navlist);
$this->smarty->assign('onevar', 2);
$this->smarty->assign('twovar', 24);
$this->smarty->assign('show_page', $show_page);
$this->smarty->assign('title', 'SPU自动生成前缀管理');
$this->smarty->assign('status', $status);
$this->smarty->assign('spuPrefixList', empty($spuPrefixList) ? null : $spuPrefixList);
$this->smarty->display("spuPrefixList.htm");
}
function initPcPm()
{
$omAvailableAct = new OmAvailableAct();
$where = 'WHERE is_delete=0 ';
$pcPmList = $omAvailableAct->act_getTNameList('pc_packing_material', '*', $where);
if (count($pcPmList) == 0) {
return false;
}
$expire = 0;
global $memc_obj;
foreach ($pcPmList as $value) {
$pmId = $value['id'];
$key = 'pc_pm_' . $pmId;
$ret = $memc_obj->set_extral($key, $value, $expire);
echo 'key=' . $key . "\n";
if (!$ret) {
echo $key;
echo '写入缓存出错,请查看mencache相关信息';
return false;
}
}
return true;
}
function initPcGoods()
{
$omAvailableAct = new OmAvailableAct();
$where = 'WHERE is_delete=0 ';
$pcGoodsList = $omAvailableAct->act_getTNameList('pc_goods', '*', $where);
if (count($pcGoodsList) == 0) {
return false;
}
$expire = 0;
global $memc_obj;
foreach ($pcGoodsList as $value) {
$sku = $value['sku'];
$key = 'pc_goods_' . $sku;
$ret = $memc_obj->set_extral($key, $value, $expire);
echo 'key=' . $key . "\n";
if (!$ret) {
echo $key;
echo '写入缓存出错,请查看mencache相关信息';
return false;
}
}
return true;
}
<?php
define('SCRIPTS_PATH_CRONTAB', '/data/web/purchase.valsun.cn/crontab/');
require_once SCRIPTS_PATH_CRONTAB . "scripts.comm.php";
$omAvailableAct = new OmAvailableAct();
$where = '';
$resultList = $omAvailableAct->act_getTNameList('ebay_partner', '*', $where);
if (count($resultList) == 0) {
return false;
}
$partner = array();
foreach ($resultList as $key => $result) {
$partner['id'] = $result['id'];
$partner['company_name'] = $result['company_name'];
$partner['username'] = $result['username'];
$partner['tel'] = $result['tel'];
$partner['phone'] = $result['mobile'];
$partner['fax'] = $result['fax'];
$partner['QQ'] = $result['QQ'];
$partner['AliIM'] = $result['AliIM'];
$partner['shoplink'] = $result['shop_link'];
$partner['e_mail'] = $result['mail'];
$partner['address'] = $result['address'];
$partner['note'] = $result['note'];
$partner['city'] = $result['city'];
$partner['sms_status'] = $result['is_sms'];
$partner['email_status'] = $result['is_email'];
$purchaser = isset($result['purchaseuser']) ? trim($result['purchaseuser']) : '';
$purchaserId = getPurchaserId($purchaser);
$partner['purchaseuser_id'] = $purchaserId;
$partner['company_id'] = 1;
function get_account_id($accountName)
{
$info = array();
$omAvailableAct = new OmAvailableAct();
$where = " WHERE account = '{$accountName}' AND is_delete = 0 ";
$res = $omAvailableAct->act_getTNameList('om_account', 'id,platformId', $where);
$info = array('accountid' => $res[0]['id'], 'platformid' => $res[0]['platformId']);
return $info;
}
public function act_eubTrucknumber()
{
date_default_timezone_set("Asia/Chongqing");
error_reporting(0);
$transportationlist = CommonModel::getCarrierList();
$transportation = array();
foreach ($transportationlist as $k1 => $v1) {
$transportation[$v1['id']] = $v1['carrierNameCn'];
}
/*
$strOrder = '';
$arr_orders = array();
$arr_accounts = array();
$arr_records = explode(',', $strTxet);
foreach ($arr_records as $k => $v) {
list($order,$account) = explode('--', $v);
$arr_orders[] = $order;
$arr_accounts[] = $account;
$strOrder .= "','".$order;
}
echo "<pre>";
echo $strOrder;
//print_r($arr_orders);
//print_r($arr_accounts);
exit;*/
/*$table = " `om_unshipped_order_detail` AS b
LEFT JOIN `om_unshipped_order` AS a ON a.id = b.omOrderId
LEFT JOIN `om_unshipped_order_userInfo` AS c ON a.id = c.omOrderId
LEFT JOIN `om_unshipped_order_extension_aliexpress` AS d ON a.id = d.omOrderId
LEFT JOIN `om_unshipped_order_detail_extension_aliexpress` AS e ON b.id = e.omOrderdetailId
LEFT JOIN `om_order_tracknumber` as f ON a.id = f.omOrderId
LEFT JOIN `om_account` AS g ON a.accountId = g.id ";
$field = " a.recordNumber,g.account,c.platformUsername,a.ordersTime,a.paymentTime,a.onlineTotal,a.actualShipping,a.actualTotal,d.currency,a.calcWeight,d.declaredPrice,d.PayPalPaymentId,b.sku,b.amount,e.itemTitle,d.feedback,c.username,c.countryName,c.state,c.city,c.street,c.zipCode,c.landline,c.phone,a.transportId ";
$where = " WHERE a.platformId = '16' AND a.orderAddTime > '1394035200' AND a.orderAddTime < '1394467200' ";
$omAvailableAct = new OmAvailableAct();
$unShipOrderList = $omAvailableAct->act_getTNameList($table, $field, $where);
foreach ($unShipOrderList as $k2 => $v2) { //key代表最外层的维数
$detail = $v;
$detail['transportName'] = $transportation[$v2['transportId']];
unset($detail['transportId']);
$excel->addRow($detail);
}
echo "<pre>";
print_r($unShipOrderList);
exit;*/
$fileName = "UnShipments" . date('Y-m-d') . ".xls";
$excel = new ExportDataExcel('browser', $fileName);
$excel->initialize();
$row = array('订单编号', '买家名称', '买家邮箱1', '买家邮箱2', '买家邮箱3', '下单时间', '付款时间', '产品总金额', '物流费用', '订单金额', '币种', 'Transaction ID', '申报价值', '估算重量', 'SKU', '数量', '产品名称', '订单备注', '收货人名称', '收货国家', '州/省', '城市', '地址', '邮编', '联系电话1', '联系电话2', '联系电话3', '手机', '买家选择物流', '平台账号', '跟踪号');
$excel->addRow($row);
$table = " `om_shipped_order_detail` AS b \n LEFT JOIN `om_shipped_order` AS a ON a.id = b.omOrderId\n LEFT JOIN `om_shipped_order_userInfo` AS c ON a.id = c.omOrderId\n LEFT JOIN `om_shipped_order_extension_aliexpress` AS d ON a.id = d.omOrderId\n LEFT JOIN `om_shipped_order_detail_extension_aliexpress` AS e ON b.id = e.omOrderdetailId LEFT JOIN `om_order_tracknumber` as f ON a.id = f.omOrderId \n LEFT JOIN `om_account` AS g ON a.accountId = g.id \n LEFT JOIN `om_order_notes` AS h ON a.id = h.omOrderId ";
$field = " a.recordNumber,a.ordersTime,a.paymentTime,a.onlineTotal,a.actualShipping,a.actualTotal,a.calcWeight,a.transportId,d.declaredPrice,d.PayPalPaymentId,b.sku,b.amount,e.itemTitle,d.feedback,c.platformUsername,c.email,c.username,c.countryName,c.currency,c.state,c.city,c.street,c.zipCode,c.landline,c.phone,f.tracknumber,g.account,h.content ";
$where = " WHERE a.recordNumber in ('559220080488213','61291048149790','61291014326917','61285636311954','61299676786510','61257847770012','1171653376007','1342566038012','1342550690012','1342524909012','1342515426012','1342413527012','1342399574012','1342390599012','1342367093012','1342314002012','1342310983012','1342290240012','1342133149012','1342120869012','1342118622012','1342081543012','1172474925007','1172315504007','1172299770007','1172296184007','1172272680007','1172232882007','1172223365007','1172182526007','1172126469007','558981387361611','558487478479670','558460023922925','557494022572438','DD14030800858','DD14030800269','DD14030800028','DD14030800525','DD14030800473','DD14030800333','DD14030800327','DD14030800255','DD14030800252','DD14030800222','DD14030800123','DD14030800120','DD14030800114','DD14030800111','DD14030701909','DD14030701900','DD14030701897','DD14030701870','DD14030701862','DD14030701825','DD14030701804','DD14030701724','DD14030701628','DD14030701582','DD14030701521','DD14030701456','DD14030701453','DD14030800027','DD14030701839','DD14030701759','171854-1','171795-1','21230-1','21221-1','61300512856554','DD14030600356','560386182450074','560445368025526','560735706789508','tt26353 clock-maker-2003','557295691973440','560574194439744','560875202763990','560762748300826','559871057882405','1171983566007','559987766894519','558843852813198','026-2038948-1825953','560195307202708','560118439761577','560614570129474','560604162366800','61233033960335','61225401138144','61275776866334','61283751550514','61284381471047','61271644078579','61285971256188','61286694581510','61286457896555','61273360806194','61287102116285','61288784939131','61289515402687','61290457641996','61291268481630','61292236773732','61278564524075','61298273217872','61284209829125','61300945144583','61271728212854','61303225891249','61266347810315','61282400441698','61257905772517','61283695281297','61273648438832','61279523250615','61297173545612','61300390671128','61301813182124','61283752032239','61284146363591','61287931644618','61293690836849','61299950555255','61300354697689','61288949877623','61286041305506','61301553743972','61277379550615','61294274238692','61281604636692','61261903830103','61257008371173','61275686039202','61291354923312','61291893569713','61278566094239','61278769877617','61293864388329','61282765315776','61298697699029','61284928938443','61299558787159','61302422095276','61272643402639','202-8393434-1143552','224697','188403','026-9661670-0337959','58452','223786','223741','220371','188117','186781','188235','223689','218802','197544','188074','60262','558246027770826','528226','223407','218656','101770','1341546884012','1760855','176832','526693','219168','CN100013211','222168','61270307460048','105-8385470-2341026','106-8240274-1106603','523208','218133','61274545010953','61280384012104','61281919468547','61285998314076','61278855631594','61280505522639','61268603902803','61219012417370','61279110037621','61274064981817','61264566746663','61279266542058','61282198497751','61283350036547','61275139782894','61276103852273','61280872818965','61280057928870','61278504882195','61281135133896','61281392411898','61281294973925','61268565467244','61282631771728','61269563947797','61279838412445','61274342499990','61263606811067','61274785500124','61222565934461','26354','26356','26349','26345 jerikavazquezbermudez','61275958205863','61269285568291','61270402108315','61274339549496','61274546569687','61274802947529','61275751827350','61262847093901','61276629817558','61278175910616','61266721802310','61279901031227','61280690942912','61286380743625','61297839638906','61307624738338','61277028514524','61261240188489','61299055455120','26335','DD14030700132','DD14030601731','DD14030601397','DD14030601302','DD14030601298','DD14030700978','DD14030700788','DD14030700499','DD14030700332','DD14030700214','DD14030700204','DD14030601996','DD14030601838','DD14030601748','DD14030601585','DD14030601395','DD14030601384','DD14030601297','DD14030601284','DD14030700241','DD14030700069','DD14030601842','DD14030601707','171767','171755','171731','171724','171716','171676','21193','171659','171636','23640','10060#EF14030600078#00001','10058#EF14030600033#00001','10053#ED14030500099#00003','10052#ED14030500099#00002','10052#CIC14030600011#00001','10051#EF14030600007#00002','10050#EF14030600001#00004','10039#ED14022800279#00001','61288625724862','61301695017139','61262016159344','61268148743481','61302659500997','61281583119393','61286067476828','61273077999487','61288025605103','1325','1324','1323','1319','1318','1317','1341033505012','1341009132012','1341824240012','1341696946012','1341694163012','1341575187012','1341552132012','1171516107007','1171507984007','1171492136007','1171575046007','1172017468007','1172004350007','1171994219007','1171984578007','1171926583007','1171924919007','1171904569007','1171903716007','1171840428007','1171820921007','1171933127007','1341496314012','1341452776012','1341430719012','1341387307012','1341344799012','1341318614012','1341248976012','1341228817012','1341187566012','1341113133012','1171038439007','1171033243007','1170993495007','1171481958007','1171474896007','1171472379007','1171457400007','1171449215007','1171447905007','1171416970007','1171251355007','1171196353007','1171165850007','1171147108007','1171039940007','26337','DL00063245','61281572272997','61280185621112','558897626662002','559457550085319','559964179142377','559936580977023','559364883586789','558042806763467','557981705438975','558266733802235','558198507852622','557953639231007','557957714549391','557958516721499','557183300613704','557882892610971','557616359665851','1171017114007','1171004617007','1170988981007','1170976546007','1170433249007','558951559459508','559400560676789','559630880572235','559540508725117','559070020338919','558834837695702','1169337760','5581989066539311','558007554317350','559143459057814','1456015806','1456031064','558064192600975','1168657452','CYBS06140309','559167238163972','557996971531592','557659877402622','558001924546789','557729957608803','558094428083493','558167306158085','558274562942401','558386251311684','558527284183280','880823','558088270434082','558796179128106','558923216912503','558797711647636','558884118112405','219398','112-8281922-9312205','558575557867256','1455857822','1455944107','1455944508','1455957240','1455959108','1455959695','1455964405','1455964817','1455974683','1455975207','1455991212','1456014821','1456020637','1456021409','1456043496','1456045982','1455952462','1455953028','1455956237','1455962265','1455962496','1455971675','1455971936','1455973327','1455976832','1455985967','1455987643','1455996313','526380','157972','187584','223184','223181','CYBS13140316','525712','223049','89562','CN100012942','DL00079730','DL00079644','DD14030502002','DD14030501926','DD14030501877','DD14030501771','DD14030501558','DD14030501507','DD14030501495','DD14030501444','DD14030501147','DD14030601105','DD14030601102','DD14030600470','DD14030600252','DD14030501930','DD14030501886','DD14030501804','DD14030501297','DD14030501232','BD14030601169','187186','DL00080075','DL00077878','218374','187024','523612','33598','558057068255073','557772672117459','1455848911','1455941088','1455954864','1455957247','1455959313','1455967410','196296','186350') ";
$omAvailableAct = new OmAvailableAct();
$unShipOrderList = $omAvailableAct->act_getTNameList($table, $field, $where);
foreach ($unShipOrderList as $k2 => $v2) {
//key代表最外层的维数
$detail = $v2;
$ordersTime = date('Y-m-d', $detail['ordersTime']);
$paymentTime = date('Y-m-d', $detail['paymentTime']);
$transport = $transportation[$v2['transportId']];
$note = $detail['content'] . ' ' . $detail['feedback'];
$detailRow = array($detail['recordNumber'], $detail['platformUsername'], $detail['email'], '', '', $ordersTime, $paymentTime, $detail['onlineTotal'], $detail['actualShipping'], $detail['actualTotal'], $detail['currency'], $detail['PayPalPaymentId'], $detail['declaredPrice'], $detail['calcWeight'], $detail['sku'], $detail['amount'], $detail['itemTitle'], $note, $detail['username'], $detail['countryName'], $detail['state'], $detail['city'], $detail['street'], $detail['zipCode'], $detail['landline'], '', '', $detail['phone'], $transport, $detail['account'], $detail['tracknumber']);
$excel->addRow($detailRow);
}
$excel->finalize();
exit;
}
public function view_modifyOrderList()
{
global $memc_obj;
$sysUserId = $_SESSION['sysUserId'];
$modify_showerrorinfo = '';
$OrderModifyAct = new OrderModifyAct();
$OrderindexAct = new OrderindexAct();
$UserCompetenceAct = new UserCompetenceAct();
//var_dump($_GET); exit;
if (isset($_GET) && !empty($_GET)) {
$orderid = isset($_GET['orderid']) ? $_GET['orderid'] : '';
$ostatus = isset($_GET['edit_ostatus']) ? $_GET['edit_ostatus'] : $_GET['ostatus'];
$otype = isset($_GET['edit_otype']) ? $_GET['edit_otype'] : $_GET['otype'];
}
if (isset($_POST) && !empty($_POST)) {
//var_dump($_POST); echo "<br>"; exit;
$orderid = isset($_POST['orderid']) ? $_POST['orderid'] : '';
$ostatus = isset($_POST['edit_ostatus']) ? $_POST['edit_ostatus'] : $_POST['ostatus'];
$otype = isset($_POST['edit_otype']) ? $_POST['edit_otype'] : $_POST['otype'];
$update_order = array();
$update_userinfo = array();
$update_tracknumber = array();
//$orderid = $_POST['orderid'];
//var_dump($_POST); exit;
$updatestatus = false;
if ($_POST['action'] == 'addDetail') {
//var_dump($_GET); echo "<br>"; exit;
$orderid = isset($_GET['orderid']) ? $_GET['orderid'] : '';
$ostatus = isset($_GET['edit_ostatus']) ? $_GET['edit_ostatus'] : $_GET['ostatus'];
$otype = isset($_GET['edit_otype']) ? $_GET['edit_otype'] : $_GET['otype'];
if ($OrderModifyAct->act_batchAdd($orderid, $_POST)) {
$modify_showerrorinfo = "<font color='green'>添加成功</font>";
} else {
$modify_showerrorinfo = "<font color='red'>添加失败</font>";
}
} else {
if ($_POST['action'] == 'addNote') {
//var_dump($_GET); echo "<br>"; exit;
$orderid = isset($_GET['orderid']) ? $_GET['orderid'] : '';
$ostatus = isset($_GET['edit_ostatus']) ? $_GET['edit_ostatus'] : $_GET['ostatus'];
$otype = isset($_GET['edit_otype']) ? $_GET['edit_otype'] : $_GET['otype'];
if ($OrderModifyAct->act_addNote($orderid, $_POST)) {
$modify_showerrorinfo = "<font color='green'>添加成功</font>";
} else {
$modify_showerrorinfo = "<font color='red'>添加失败</font>";
}
} else {
$visible_movefolder = $UserCompetenceAct->act_getInStatusIds($_POST['otype'], $sysUserId);
if (!in_array($_POST['edit_otype'], $visible_movefolder)) {
$modify_showerrorinfo = "<font color='red'>您没有改变订单状态的权限</font>";
} else {
if ($_POST['username'] != $_POST['edit_username']) {
$update_userinfo['username'] = $_POST['edit_username'];
}
if ($_POST['ostatus'] != $_POST['edit_ostatus']) {
$update_order['orderStatus'] = $_POST['edit_ostatus'];
}
if ($_POST['otype'] != $_POST['edit_otype']) {
$update_order['orderType'] = $_POST['edit_otype'];
$updatestatus = true;
}
if ($_POST['street'] != $_POST['edit_street']) {
$update_userinfo['street'] = $_POST['edit_street'];
}
if ($_POST['platformUsername'] != $_POST['edit_platformUsername']) {
$update_userinfo['platformUsername'] = $_POST['edit_platformUsername'];
}
if ($_POST['address2'] != $_POST['edit_address2']) {
$update_userinfo['address2'] = $_POST['edit_address2'];
}
if ($_POST['actualShipping'] != $_POST['edit_actualShipping']) {
$update_order['actualShipping'] = $_POST['edit_actualShipping'];
}
if ($_POST['city'] != $_POST['edit_city']) {
$update_userinfo['city'] = $_POST['edit_city'];
}
if ($_POST['state'] != $_POST['edit_state']) {
$update_userinfo['state'] = $_POST['edit_state'];
}
if ($_POST['countryName'] != $_POST['edit_countryName']) {
$update_userinfo['countryName'] = $_POST['edit_countryName'];
}
if ($_POST['zipCode'] != $_POST['edit_zipCode']) {
$update_userinfo['zipCode'] = $_POST['edit_zipCode'];
}
if ($_POST['landline'] != $_POST['edit_landline']) {
$update_userinfo['landline'] = $_POST['edit_landline'];
}
if ($_POST['phone'] != $_POST['edit_phone']) {
$update_userinfo['phone'] = $_POST['edit_phone'];
}
if ($_POST['transportId'] != $_POST['edit_transportId']) {
$update_order['transportId'] = $_POST['edit_transportId'];
}
if ($_POST['edit_tracknumber']) {
$update_tracknumber['omOrderId'] = $orderid;
$update_tracknumber['tracknumber'] = $_POST['edit_tracknumber'];
$update_tracknumber['addUser'] = $sysUserId;
$update_tracknumber['createdTime'] = time();
//var_dump($update_tracknumber); exit;
}
BaseModel::begin();
//开始事务
if ($update_order) {
//$sql = "UPDATE om_unshipped_order set ".array2sql($update_order)." WHERE id = ".$orderid;
//$msg = OrderLogModel::orderLog($orderid,$update_order['orderStatus'],$update_order['orderType'],$sql);
if (OrderindexModel::updateOrder('om_unshipped_order', $update_order, ' WHERE id = ' . $orderid)) {
if ($updatestatus) {
$ProductStatus = new ProductStatus();
if (!$ProductStatus->updateSkuStatusByOrderStatus(array($orderid), $batch_ostatus_val, $batch_otype_val)) {
BaseModel::rollback();
}
}
$modify_showerrorinfo = "<font color='green'>更新成功</font>";
} else {
$modify_showerrorinfo = "<font color='red'>更新失败</font>";
BaseModel::rollback();
}
}
if ($update_userinfo) {
//var_dump($update_userinfo);
if (OrderindexModel::updateOrder('om_unshipped_order_userInfo', $update_userinfo, ' WHERE omOrderId = ' . $orderid)) {
$modify_showerrorinfo = "<font color='green'>更新成功</font>";
} else {
$modify_showerrorinfo = "<font color='red'>更新失败</font>";
BaseModel::rollback();
}
}
if ($update_tracknumber) {
//echo $msg;
if (!OrderAddModel::insertOrderTrackRow($update_tracknumber)) {
/*self :: $errCode = "001";
self :: $errMsg = "跟踪号插入失败";
return false;*/
$modify_showerrorinfo = "<font color='red'>跟踪号插入失败</font>";
BaseModel::rollback();
}
}
BaseModel::commit();
BaseModel::autoCommit();
}
}
}
}
$this->smarty->assign('modify_showerrorinfo', $modify_showerrorinfo);
$omAvailableAct = new OmAvailableAct();
//平台信息
$platform = $omAvailableAct->act_getTNameList('om_platform', 'id,platform', 'WHERE is_delete=0');
//var_dump($platform);
$platformList = array();
foreach ($platform as $v) {
$platformList[$v['id']] = $v['platform'];
}
$this->smarty->assign('platformList', $platformList);
/**导航 start**/
$this->smarty->assign('ostatus', $ostatus);
$this->smarty->assign('otype', $otype);
//二级目录
$StatusMenuAct = new StatusMenuAct();
$ostatusList = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = 0 AND is_delete=0');
//var_dump($ostatusList);
$this->smarty->assign('ostatusList', $ostatusList);
$otypeList = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = "' . $ostatus . '" AND is_delete=0');
//var_dump($otypeList);
$this->smarty->assign('otypeList', $otypeList);
/*$o_secondlevel = $omAvailableAct->act_getTNameList('om_status_menu','*','WHERE is_delete=0 and groupId=0 order by sort asc');
$this->smarty->assign('o_secondlevel', $o_secondlevel);*/
$second_count = array();
$second_type = array();
foreach ($ostatusList as $o_secondinfo) {
$orderStatus = $o_secondinfo['statusCode'];
/*$accountacc = $_SESSION['accountacc'];
$oc_where = " where orderStatus='$orderStatus' ";
if($accountacc){
$oc_where .= ' AND ('.$accountacc.') ';
}*/
$s_total = $OrderindexAct->act_showSearchOrderNum($orderStatus);
//$s_total = $omAvailableAct->act_getTNameCount("om_unshipped_order", $oc_where);
$second_count[$o_secondinfo['statusCode']] = $s_total;
$s_type = $omAvailableAct->act_getTNameList("om_status_menu", "*", "WHERE is_delete=0 and groupId='{$orderStatus}' order by sort asc");
$second_type[$o_secondinfo['statusCode']] = $s_type[0]['statusCode'];
}
//var_dump($second_count);
$this->smarty->assign('second_count', $second_count);
$this->smarty->assign('second_type', $second_type);
//退款数量
$refund_total = $omAvailableAct->act_getTNameCount("om_order_refund", " where is_delete=0");
$this->smarty->assign('refund_total', $refund_total);
//三级目录
$o_threelevel = $omAvailableAct->act_getTNameList("om_status_menu", "*", "WHERE is_delete=0 and groupId='{$ostatus}' order by sort asc");
$this->smarty->assign('o_threelevel', $o_threelevel);
$three_count = array();
foreach ($o_threelevel as $o_threeinfo) {
$orderType = $o_threeinfo['statusCode'];
$s_total = $OrderindexAct->act_showSearchOrderNum($ostatus, $orderType);
//$s_total = $omAvailableAct->act_getTNameCount("om_unshipped_order"," where orderStatus='$ostatus' and orderType='$orderType' and storeId=1 and is_delete=0");
$three_count[$o_threeinfo['statusCode']] = $s_total;
}
$this->smarty->assign('three_count', $three_count);
$toptitle = '订单显示页面';
//头部title
$this->smarty->assign('toptitle', $toptitle);
$this->smarty->assign('toplevel', 0);
$threelevel = '1';
//当前的三级菜单
$this->smarty->assign('threelevel', $threelevel);
$statusMenu = $omAvailableAct->act_getTNameList('om_status_menu', ' * ', 'WHERE is_delete=0 ');
$this->smarty->assign('statusMenu', $statusMenu);
$value = '';
$where = '';
switch ($searchTransportationType) {
case '1':
$transportation = CommonModel::getCarrierList(1);
//快递
break;
case '2':
$transportation = CommonModel::getCarrierList(0);
//平邮
break;
default:
$transportation = CommonModel::getCarrierList();
//所有的
break;
}
//var_dump($transportation); exit;
$transportationList = array();
foreach ($transportation as $tranValue) {
$transportationList[$tranValue['id']] = $tranValue['carrierNameCn'];
}
//var_dump($transportationList); exit;
$this->smarty->assign('transportation', $transportation);
$this->smarty->assign('transportationList', $transportationList);
//var_dump($orderid, $ostatus,$otype);
$omOrderList = $OrderModifyAct->act_getModifyOrderList($orderid, $ostatus, $otype, $storeId = 1);
//var_dump($omOrderList);
//$sku = array();
$account_where = ' WHERE is_delete = 0 ';
if ($searchPlatformId) {
$account_where .= ' AND platformId = ' . $searchPlatformId;
}
$accountList = $UserCompetenceAct->act_showGlobalUser();
if ($accountList) {
$account_where .= ' AND id in ( ' . join(',', $accountList) . ' ) ';
}
//帐号信息
$accountList = $omAvailableAct->act_getTNameList('om_account', '*', $account_where);
//var_dump($accountList); exit;
$account = array();
foreach ($accountList as $v) {
$account[$v['id']] = $v['account'];
}
//包材信息
$pm = GoodsModel::getMaterInfoByList();
//获取系统所有状态
$statusList = copyOrderModel::selectStatusList();
$CurrencyAct = new CurrencyAct();
$currencyList = $CurrencyAct->act_getCurrencyListById();
//echo "<pre>"; print_r($currencyList); exit;
$this->smarty->assign('currencyList', $currencyList);
$this->smarty->assign('statusList', $statusList);
$this->smarty->assign('show_page', $show_page);
$this->smarty->assign('account', $account);
$this->smarty->assign('accountList', $accountList);
$this->smarty->assign('pm', $pm);
$this->smarty->assign('omOrderList', $omOrderList);
$this->smarty->display('orderModify.htm');
}
$configFile = WEB_PATH_CONF_SCRIPTS_KEYS_TAOBAO . "config_" . $taobao_user . ".php";
$logfile = SCRIPT_DATA_LOG . "taobao/shipment/taobao_shipment_" . $taobao_user . "_" . date("Y-m-d") . ".log";
//echo $logfile;die;
if (file_exists($configFile)) {
include_once $configFile;
} else {
echo "error： 未找对应的config文件!\n";
exit;
}
$debug_mode = 'false';
$user = '******';
$start = strtotime("-72 hour");
$account_info = get_account_id($account);
$omAvailableAct = new OmAvailableAct();
$where = " WHERE accountId = '{$account_info['accountid']}' AND is_delete = 0 AND b.weighTime>{$start}";
$alldata = $omAvailableAct->act_getTNameList('om_shipped_order as a left join om_shipped_order_warehouse as b on a.id=b.omOrderId', 'a.id,a.recordNumber,a.accountId,a.transportId', $where);
$sum = sizeof($alldata);
if ($sum > 0) {
foreach ($alldata as $val) {
$log_data = array();
$carrier = CommonModel::getShipingNameById($val['transportId']);
$where = " WHERE omOrderId = '{$val['id']}' AND is_delete = 0 ";
$res = $omAvailableAct->act_getTNameList('om_order_tracknumber', 'tracknumber', $where);
$log_data['time'] = date("Y-m-d H:i:s");
$log_data['recordnumber'] = $recordnumber = $val['recordnumber'];
$log_data['ebay_carrier'] = $carrier;
$log_data['tracknumber'] = $tracknumber = $res[0]['tracknumber'];
$log_data['ebay_id'] = $val['id'];
$company_code = getLogisticCode($carrier);
$log_data['company_code'] = $company_code;
if (empty($res)) {
function initPurchaser2Id()
{
$omAvailableAct = new OmAvailableAct();
$where = '';
$field = 'global_user_id, global_user_name';
$resultList = $omAvailableAct->act_getTNameList('power_global_user', $field, $where);
if (count($resultList) == 0) {
return false;
}
//$expire = 0;
global $memc_obj, $global_expire;
foreach ($resultList as $result) {
$id = $result['global_user_id'];
$name = $result['global_user_name'];
if ($name == '') {
continue;
}
$key = 'purchase_purchaser_name_' . $name;
$ret = $memc_obj->set_extral($key, $id, $global_expire);
echo "key = {$key} \n";
if (!$ret) {
echo $key;
echo '写入缓存出错,请查看mencache相关信息/n';
return false;
}
}
return true;
}
$json_data = taobaoTradesSoldGet($url, $session, $appSecret, $appKey, $status, $cur_page, $page_size);
}
//出错处理
if (isset($json_data['error_response'])) {
echo "error: " . $json_data['error_response']['msg'] . " error code:" . $json_data['error_response']['code'] . "\n";
} else {
//数据入库
$data = $json_data['trades_sold_get_response']['trades']['trade'];
foreach ($data as $trade) {
$insertOrder = array();
$trade_data = taobaoTradeGet($url, $appSecret, $session, $appKey, $trade['sid']);
$recordnumber = $trade['sid'];
//淘宝订单号
//$omAvailableAct = new OmAvailableAct();
$where = " WHERE recordNumber = '{$recordnumber}' AND is_delete = 0 ";
$res = $omAvailableAct->act_getTNameList('om_unshipped_order', 'id', $where);
if (!empty($res)) {
$error_data[] = "交易ID{$recordnumber}的已经存在与系统中!\n";
continue;
}
if (!empty($recordnumber)) {
$account_info = array();
$account_info = get_account_id($account);
if (empty($account_info)) {
$error_data[] = "交易ID{$recordnumber}的已经存在与系统中!\n";
continue;
}
/***************BEGIN 订单表数据***************/
$orderdata = array();
$orderdata['recordNumber'] = $recordnumber;
$orderdata['platformId'] = $account_info['platformid'];
public function view_getNoPassSpuList()
{
$omAvailableAct = new OmAvailableAct();
$spu = isset($_GET['spu']) ? post_check($_GET['spu']) : '';
$purchaseId = isset($_GET['purchaseId']) ? post_check($_GET['purchaseId']) : '';
$pid = isset($_GET['pid']) ? post_check($_GET['pid']) : '';
$isCounterAudit = isset($_GET['isCounterAudit']) ? post_check($_GET['isCounterAudit']) : '';
$tName = 'pc_spu_archive_no_pass_record';
$select = '*';
$where = 'WHERE 1=1 ';
if (!empty($spu)) {
$where .= "AND spu='{$spu}' ";
}
if (!empty($pid)) {
$where .= "AND categoryPath REGEXP '^{$pid}(-[0-9]+)*\$' ";
}
if (intval($purchaseId) != 0) {
$where .= "AND purchaseId='{$purchaseId}' ";
}
if ($isCounterAudit == 1 || $isCounterAudit == 2) {
$where .= "AND isCounterAudit='{$isCounterAudit}' ";
}
$total = $omAvailableAct->act_getTNameCount($tName, $where);
$num = 100;
//每页显示的个数
$page = new Page($total, $num, '', 'CN');
$where .= 'order by id desc ';
$where .= $page->limit;
$spuNoPassList = $omAvailableAct->act_getTNameList($tName, $select, $where);
if (!empty($spuNoPassList)) {
$platformList = getAllPlatformInfo();
$platformArr = array();
$spuStatusArr = displayAllSpuStatus();
foreach ($platformList as $value) {
$platformArr[$value['id']] = $value['platform'];
}
$countSpuNoPass = count($spuNoPassList);
for ($i = 0; $i < $countSpuNoPass; $i++) {
$spuNoPassList[$i]['platformName'] = $platformArr[$spuNoPassList[$i]['platformId']];
$spuNoPassList[$i]['spuStatusName'] = $spuStatusArr[$spuNoPassList[$i]['spuStatus']]['statusName'];
}
}
if (!empty($_GET['page'])) {
if (intval($_GET['page']) <= 1 || intval($_GET['page']) > ceil($total / $num)) {
$n = 1;
} else {
$n = (intval($_GET['page']) - 1) * $num + 1;
}
} else {
$n = 1;
}
if ($total > $num) {
//输出分页显示
$show_page = $page->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9));
} else {
$show_page = $page->fpage(array(0, 2, 3));
}
$navlist = array(array('url' => 'index.php?mod=autoCreateSpu&act=getAutoCreatePrefixList', 'title' => 'SPU管理'), array('url' => 'index.php?mod=autoCreateSpu&act=getNoPassSpuList', 'title' => 'SPU审核不通过管理'));
$this->smarty->assign('navlist', $navlist);
$this->smarty->assign('onevar', 2);
$this->smarty->assign('twovar', 25);
$this->smarty->assign('show_page', $show_page);
$this->smarty->assign('title', 'SPU审核不通过管理');
//取得搜索类别的记录
$pidArr = explode('-', $pid);
$this->smarty->assign('pidArr', $pidArr);
$this->smarty->assign('spuNoPassList', empty($spuNoPassList) ? null : $spuNoPassList);
$this->smarty->display("spuNoPassList.htm");
}
public function view_getOrderList()
{
global $memc_obj;
$pagesize = isset($_GET['pnum']) && intval($_GET['pnum']) > 0 && intval($_GET['pnum']) < 101 ? intval($_GET['pnum']) : 20;
//页面大小
if ($_GET['debug'] == 1) {
$starttime = time() + microtime();
echo microtime() . '-----' . $starttime . "\n";
}
//菜单
$status = '';
$search = isset($_REQUEST['search']) ? $_REQUEST['search'] : '';
//搜索时使用的数据
//order表
$searchPlatformId = isset($_GET['platformId']) ? $_GET['platformId'] : '';
//搜索平台
$searchAccountId = isset($_GET['accountId']) ? $_GET['accountId'] : '';
//搜索账号
$searchIsNote = isset($_GET['isNote']) ? $_GET['isNote'] : '';
//是否有留言
$searchTransportationType = isset($_GET['transportationType']) ? $_GET['transportationType'] : '';
//运输类型
$searchTransportation = isset($_GET['transportation']) ? $_GET['transportation'] : '';
//运输方式
$searchIsBuji = isset($_GET['isBuji']) ? $_GET['isBuji'] : '';
//是否补寄订单
$searchIsLock = isset($_GET['isLock']) ? $_GET['isLock'] : '';
//是否锁定
$searchOrderTime1 = isset($_GET['OrderTime1']) ? $_GET['OrderTime1'] : '';
//搜索下单初始时间
$searchOrderTime2 = isset($_GET['OrderTime2']) ? $_GET['OrderTime2'] : '';
//搜索下单结束时间
//order_detail表
$searchReviews = isset($_GET['reviews']) ? $_GET['reviews'] : '';
//是否评价
$searchSku = isset($_GET['sku']) ? $_GET['sku'] : '';
//sku
//$searchOmOrderId = ''; //订单编号
$searchOrderType = isset($_GET['selectOrderType']) ? $_GET['selectOrderType'] : '';
//订单种类
//order_userInfo表
//$searchUsername = ''; //买家名
//$searchEmail = '';
$countryName = isset($_GET['country']) ? $_GET['country'] : "";
$state = isset($_GET['state']) ? $_GET['state'] : "";
$city = isset($_GET['city']) ? $_GET['city'] : "";
$zipCode = isset($_GET['zipCode']) ? $_GET['zipCode'] : "";
//order_warehouse表
//$weighTimeStart = isset($_GET['searchTimeStart'])? $_GET['searchTimeStart']:"";
//$weighTimeEnd = isset($_GET['searchTimeEnd'])? $_GET['searchTimeEnd']:"";
$searchTimeType = isset($_GET['searchTimeType']) ? $_GET['searchTimeType'] : '';
//order_tracknumbe表
//$searchTracknumber = ''; //跟踪号
//order_extension_ebay表
//$searchTransId = ''; //交易ID
$searchKeywordsType = isset($_GET['KeywordsType']) ? $_GET['KeywordsType'] : '';
//搜索关键字类型
$searchKeywords = isset($_GET['Keywords']) ? $_GET['Keywords'] : '';
//搜索关键字
$this->smarty->assign('searchPlatformId', $searchPlatformId);
$this->smarty->assign('searchAccountId', $searchAccountId);
$this->smarty->assign('searchIsNote', $searchIsNote);
$this->smarty->assign('searchTransportationType', $searchTransportationType);
$this->smarty->assign('searchTransportation', $searchTransportation);
$this->smarty->assign('searchIsBuji', $searchIsBuji);
$this->smarty->assign('searchIsLock', $searchIsLock);
$this->smarty->assign('searchOrderTime1', $searchOrderTime1);
$this->smarty->assign('searchOrderTime2', $searchOrderTime2);
$this->smarty->assign('searchReviews', $searchReviews);
$this->smarty->assign('searchSku', $searchSku);
$this->smarty->assign('searchOrderType', $searchOrderType);
//$this->smarty->assign('searchEmail', $searchEmail);
$this->smarty->assign('searchKeywordsType', $searchKeywordsType);
$this->smarty->assign('searchKeywords', $searchKeywords);
$this->smarty->assign('searchCountry', $countryName);
$this->smarty->assign('searchState', $state);
$this->smarty->assign('searchCity', $city);
$this->smarty->assign('searchZipCode', $zipCode);
//$this->smarty->assign('searchTimeStart', $weighTimeStart);
//$this->smarty->assign('searchTimeEnd', $weighTimeEnd);
$this->smarty->assign('searchTimeType', $searchTimeType);
if ($_GET['debug'] == 1) {
$dotime = time() + microtime();
echo "firsttime ==={$dotime}=== " . ($dotime - $starttime) . "\n\n";
}
$OrderRefundAct = new OrderRefundAct();
$omAvailableAct = new OmAvailableAct();
$OrderindexAct = new OrderindexAct();
//平台信息
$OmAccountAct = new OmAccountAct();
$WarehouseAPIAct = new WarehouseAPIAct();
if ($_GET['debug'] == 1) {
$dotime1 = time() + microtime();
echo "secondtime === " . ($dotime1 - $dotime) . "\n\n";
}
$AbOrderList = $WarehouseAPIAct->act_getAbOrderList();
//var_dump($AbOrderList); exit;
if ($_GET['debug'] == 1) {
$dotime = time() + microtime();
echo "thirdtime === " . ($dotime - $dotime1) . "\n\n";
}
$AbOrderListArr = array();
$AbOrderids = array();
$AbOrderShow = array();
foreach ($AbOrderList as $orderId) {
$AbOrderInfo = $WarehouseAPIAct->act_getAbOrderInfo($orderId['id']);
$AbOrderListArr[$orderId['originOrderId']] = $AbOrderInfo;
$AbOrderids[] = $orderId['originOrderId'];
$AbOrderShow[$orderId['originOrderId']] = $orderId['id'];
}
if ($_GET['debug'] == 1) {
$dotime1 = time() + microtime();
echo "forthtime === " . ($dotime1 - $dotime) . "\n\n";
}
//var_dump($AbOrderListArr); exit;
$this->smarty->assign('AbOrderListArr', $AbOrderListArr);
$this->smarty->assign('AbOrderShow', $AbOrderShow);
//$platform = $omAvailableAct->act_getTNameList('om_platform','id,platform','WHERE is_delete=0');
$platform = $OmAccountAct->act_getPlatformListByPower();
//var_dump($platform);
if ($_GET['debug'] == 1) {
$dotime = time() + microtime();
echo "fiftytime === " . ($dotime - $dotime1) . "\n\n";
}
$this->smarty->assign('platform', $platform);
/**导航 start**/
$default_ostatus = isset($_GET['ostatus']) ? $_GET['ostatus'] : C('STATEPENDING');
/*if(isset($_GET['ostatus']) && !empty($_GET['ostatus'])){
$ostatus = $_GET['ostatus'];
}else{
$ostatus = C('STATEPENDING');
}*/
$ostatus = $_GET['ostatus'];
//echo C('STATEPENDING');
$this->smarty->assign('ostatus', $ostatus);
$otype = isset($_GET['otype']) ? $_GET['otype'] : '';
$this->smarty->assign('otype', $otype);
//二级目录
$StatusMenuAct = new StatusMenuAct();
$ostatusList = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = 0 AND is_delete=0');
//var_dump($ostatusList);
$this->smarty->assign('ostatusList', $ostatusList);
if ($ostatus) {
$otypeList = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = "' . $ostatus . '" AND is_delete=0');
} else {
$otypeList = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = "' . $default_ostatus . '" AND is_delete=0');
}
if ($_GET['debug'] == 1) {
$dotime1 = time() + microtime();
echo "sixtytime === " . ($dotime1 - $dotime) . "\n\n";
}
//var_dump($otypeList);
$this->smarty->assign('otypeList', $otypeList);
/*$o_secondlevel = $omAvailableAct->act_getTNameList('om_status_menu','*','WHERE is_delete=0 and groupId=0 order by sort asc');
$this->smarty->assign('o_secondlevel', $o_secondlevel);*/
$second_count = array();
$second_type = array();
$accountacc = $_SESSION['accountacc'];
//var_dump($ostatusList); echo "<br>";
foreach ($ostatusList as $o_secondinfo) {
$orderStatus = $o_secondinfo['statusCode'];
//echo $orderStatus."============"; echo "<br>";
$s_total = 0;
//$OrderindexAct->act_showSearchOrderNum($orderStatus);
//echo $orderStatus."==".$s_total; echo "<br>";
$second_count[$o_secondinfo['statusCode']] = $s_total;
//$s_type = $omAvailableAct->act_getTNameList("om_status_menu","*","WHERE is_delete=0 and groupId='$orderStatus' order by sort asc");
$s_type = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = "' . $orderStatus . '" AND is_delete=0 order by sort asc');
$second_type[$orderStatus] = $s_type[0]['statusCode'];
}
if ($_GET['debug'] == 1) {
$dotime = time() + microtime();
echo "seventime === " . ($dotime - $dotime1) . "\n\n";
}
//var_dump($second_count);
$this->smarty->assign('second_count', $second_count);
$this->smarty->assign('second_type', $second_type);
//var_dump($second_type);
//退款数量
$accountList = $_SESSION['accountList'];
$platformList = $_SESSION['platformList'];
//echo "<pre>"; print_r($accountList); exit;
$where = " WHERE is_delete=0 ";
$platformsee = array();
for ($i = 0; $i < count($platformList); $i++) {
$platformsee[] = $platformList[$i];
}
if ($platformsee) {
$where .= ' AND platformId IN (' . join(",", $platformsee) . ') ';
} else {
//$where .= " AND 1=2 ";
}
$accountsee = array();
for ($i = 0; $i < count($accountList); $i++) {
$accountsee[] = $accountList[$i];
}
if ($accountsee) {
$where .= ' AND accountId IN (' . join(",", $accountsee) . ') ';
} else {
//$where .= " AND 1=2 ";
}
//echo $where;
//$refund_total = $omAvailableAct->act_getTNameCount("om_order_refund"," where is_delete=0 ");
$refund_total = $OrderRefundAct->act_getRecordNums();
$this->smarty->assign('refund_total', $refund_total);
$parameterArr = array();
//var_dump($AbOrderids);
$parameterArr['AbOrderList'] = $AbOrderids;
$total = $OrderindexAct->act_showABOrder($ostatus, $otype, '', $parameterArr);
$this->smarty->assign('abnormal_total', $total);
if ($_GET['debug'] == 1) {
$dotime1 = time() + microtime();
echo "8time === " . ($dotime1 - $dotime) . "\n\n";
}
//三级目录
$three_count = array();
if ($ostatus) {
$o_threelevel = $omAvailableAct->act_getTNameList("om_status_menu", "*", "WHERE is_delete=0 and groupId='{$ostatus}' order by sort asc");
foreach ($o_threelevel as $o_threeinfo) {
$orderType = $o_threeinfo['statusCode'];
/*$or_where = " where orderStatus='$ostatus' and orderType='$orderType' ";
if($accountacc){
$or_where .= ' AND ('.$accountacc.') ';
}*/
//$s_total = $OrderindexAct->act_showSearchOrderNum($ostatus, $orderType);
$s_total = $default_ostatus == 900 && $orderType == 21 ? 'n' : $OrderindexAct->act_showSearchOrderNum($default_ostatus, $orderType);
//$s_total = $omAvailableAct->act_getTNameCount("om_unshipped_order", $or_where);
$three_count[$o_threeinfo['statusCode']] = $s_total;
}
} else {
$or_where = "WHERE is_delete=0 and groupId='{$default_ostatus}' ";
if ($accountacc) {
$or_where .= ' AND (' . $accountacc . ') ';
}
$or_where .= " order by sort asc";
$o_threelevel = $omAvailableAct->act_getTNameList("om_status_menu", "*", "WHERE is_delete=0 and groupId='{$default_ostatus}' order by sort asc");
foreach ($o_threelevel as $o_threeinfo) {
$orderType = $o_threeinfo['statusCode'];
/*$or_where = " where orderStatus='$ostatus' and orderType='$orderType' ";
if($accountacc){
$or_where .= ' AND ('.$accountacc.') ';
}*/
$s_total = $default_ostatus == 900 && $orderType == 21 ? 'n' : $OrderindexAct->act_showSearchOrderNum($default_ostatus, $orderType);
//$s_total = $omAvailableAct->act_getTNameCount("om_unshipped_order", $or_where);
$three_count[$o_threeinfo['statusCode']] = $s_total;
}
}
//
if ($_GET['debug'] == 1) {
$dotime = time() + microtime();
echo "9time === " . ($dotime - $dotime1) . "\n\n";
}
$this->smarty->assign('o_threelevel', $o_threelevel);
$this->smarty->assign('three_count', $three_count);
$toptitle = '订单显示页面';
//头部title
$this->smarty->assign('toptitle', $toptitle);
$this->smarty->assign('toplevel', 0);
$threelevel = '1';
//当前的三级菜单
$this->smarty->assign('threelevel', $threelevel);
$statusMenu = $omAvailableAct->act_getTNameList('om_status_menu', ' * ', 'WHERE is_delete=0 ');
$this->smarty->assign('statusMenu', $statusMenu);
$value = '';
$where = '';
switch ($searchTransportationType) {
case '1':
$transportation = CommonModel::getCarrierList(1);
//快递
break;
case '2':
$transportation = CommonModel::getCarrierList(0);
//平邮
break;
default:
$transportation = CommonModel::getCarrierList();
//所有的
break;
}
if ($_GET['debug'] == 1) {
$dotime1 = time() + microtime();
echo "10time === " . ($dotime1 - $dotime) . "\n\n";
}
//var_dump($transportation); exit;
$transportationList = array();
foreach ($transportation as $tranValue) {
$transportationList[$tranValue['id']] = $tranValue['carrierNameCn'];
}
//var_dump($transportationList); exit;
$this->smarty->assign('transportation', $transportation);
$this->smarty->assign('transportationList', $transportationList);
if ($search == '') {
/*$where = ' WHERE is_delete = 0 AND storeId = 1 AND orderStatus = '.$ostatus;
if($otype != ''){
$where .= ' AND orderType = '.$otype;
}*/
//$total = $omAvailableAct->act_getTNameCount($orderForm, $where);
$total = $OrderindexAct->act_showOrder($ostatus, $otype);
//echo $total; exit;
$num = $pagesize;
//每页显示的个数
$page = new Page($total, $num, '', 'CN');
//$where .= " ORDER BY ordersTime " . $page->limit;
//echo "========订单系统升级中========="; echo "<br>";
$omOrderList = $OrderindexAct->act_showOrder($ostatus, $otype, $page->limit);
//echo "<pre>"; var_dump($omOrderList); exit;
//$omOrderList = $omAvailableAct->act_getTNameList($orderForm, '*', $where);
} else {
$parameterArr = array();
$parameterArr['searchPlatformId'] = $searchPlatformId;
$parameterArr['searchAccountId'] = $searchAccountId;
$parameterArr['searchIsNote'] = $searchIsNote;
$parameterArr['searchTransportationType'] = $searchTransportationType;
$parameterArr['searchTransportation'] = $searchTransportation;
$parameterArr['searchIsBuji'] = $searchIsBuji;
$parameterArr['searchIsLock'] = $searchIsLock;
$parameterArr['searchOrderTime1'] = $searchOrderTime1;
$parameterArr['searchOrderTime2'] = $searchOrderTime2;
$parameterArr['searchReviews'] = $searchReviews;
$parameterArr['searchSku'] = trim($searchSku);
$parameterArr['searchOrderType'] = $searchOrderType;
$parameterArr['searchKeywordsType'] = $searchKeywordsType;
$parameterArr['countryName'] = trim($countryName);
$parameterArr['state'] = trim($state);
$parameterArr['city'] = trim($city);
$parameterArr['zipCode'] = trim($zipCode);
$parameterArr['searchTimeType'] = trim($searchTimeType);
$parameterArr['searchKeywords'] = trim($searchKeywords);
//$parameterArr['searchKeywords'] = trim($searchKeywords);
/*if($_SESSION['sysUserId'] == 8){
var_dump($ostatus.'---'.$otype);
}*/
//echo "订单系统升级中。。。。。。。<br>";
//var_dump($parameterArr); echo "<br>";
//$total = $OrderindexAct->act_index($parameterArr,$searchKeywordsType,$searchKeywords);
$total = $OrderindexAct->act_showOrder($ostatus, $otype, '', $parameterArr);
//echo $total; exit;
$num = $pagesize;
//每页显示的个数
$page = new Page($total, $num, '', 'CN');
//$limit = $page->limit;
//var_dump($parameterArr);
$omOrderList = $OrderindexAct->act_showOrder($ostatus, $otype, $page->limit, $parameterArr);
//var_dump($omOrderList);
//$omOrderList = OrderindexAct::act_index($parameterArr,$searchKeywordsType,$searchKeywords,$limit,$ostatus);
}
if ($_GET['debug'] == 1) {
$dotime = time() + microtime();
echo "11time ={$dotime}== " . ($dotime - $dotime1) . "\n\n";
}
//$sku = array();
$account_where = ' WHERE is_delete = 0 ';
if ($searchPlatformId) {
$account_where .= ' AND platformId = ' . $searchPlatformId;
}
$UserCompetenceAct = new UserCompetenceAct();
$accountList = $UserCompetenceAct->act_showGlobalUser();
if ($accountList) {
$account_where .= ' AND id in ( ' . join(',', $accountList) . ' ) ';
}
//帐号信息
$accountList = $omAvailableAct->act_getTNameList('om_account', '*', $account_where);
//var_dump($accountList); exit;
$account = array();
foreach ($accountList as $v) {
$account[$v['id']] = $v['account'];
}
//包材信息
$pm = GoodsModel::getMaterInfoByList();
if (!empty($_GET['page'])) {
if (intval($_GET['page']) <= 1 || intval($_GET['page']) > ceil($total / $num)) {
$n = 1;
} else {
$n = (intval($_GET['page']) - 1) * $num + 1;
}
} else {
$n = 1;
}
//var_dump($page);
if ($total > $num) {
//输出分页显示
$show_page = $page->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9));
} else {
$show_page = $page->fpage(array(0, 2, 3));
}
//echo $show_page;
//获取系统所有状态
$statusList = copyOrderModel::selectStatusList();
if ($_GET['debug'] == 1) {
$dotime1 = time() + microtime();
echo "12time ={$dotime1}== " . ($dotime1 - $dotime) . "\n\n";
}
//echo $show_page;
$this->smarty->assign('statusList', $statusList);
$this->smarty->assign('show_page', $show_page);
$this->smarty->assign('account', $account);
$this->smarty->assign('accountList', $accountList);
$this->smarty->assign('pm', $pm);
$this->smarty->assign('omOrderList', $omOrderList);
$this->smarty->display('orderindex.htm');
}
public function view_deletePlatformList()
{
$id = isset($_GET['id']) ? post_check($_GET['id']) : '';
$status = '';
if (intval($id) == 0) {
$status = '数据异常，删除失败';
header("location:index.php?mod=omPlatform&act=getOmPlatformList&status={$status}");
exit;
}
$omAvailableAct = new OmAvailableAct();
$tName = 'om_platform';
$where = "WHERE is_delete=0 and id='{$id}'";
$count = $omAvailableAct->act_getTNameCount($tName, $where);
if (!$count) {
$status = '记录不存在，删除失败';
header("location:index.php?mod=omPlatform&act=getOmPlatformList&status={$status}");
exit;
}
//获取原始平台账号
$platformInfo = $omAvailableAct->act_getTNameList($tName, 'platform', ' where id=' . $id);
$old_platform = $platformInfo[0]['platform'];
$set = "SET is_delete=1 ";
$where = "WHERE id='{$id}'";
$affectRow = $omAvailableAct->act_updateTNameRow($tName, $set, $where);
if ($affectRow) {
//更新老系统
$returnInfo = OldsystemModel::erpSyncPlatform($old_platform, 'delete', $old_platform);
if ($returnInfo['res_code'] == 200) {
$status = '删除成功';
} else {
$status = '更新老系统失败';
}
} else {
$status = '删除失败';
}
header("location:index.php?mod=omPlatform&act=getOmPlatformList&status={$status}");
}
public function view_getNewGoodsList()
{
//调用action层， 获取列表数据
$start1 = getMicrotime();
$sku = $_GET['sku'] ? post_check(trim($_GET['sku'])) : '';
$purchaseId = intval($_GET['purchaseId']) > 0 ? intval($_GET['purchaseId']) : 0;
$whId = intval($_GET['whId']) > 0 ? intval($_GET['whId']) : 1;
$omAvailableAct = new OmAvailableAct();
$tName = 'pc_goods';
$select = 'spu';
$where = "WHERE is_delete=0 AND isNew=1 AND substring(sku, 1, 1)<>'M' AND substring(sku, 1, 1)<>'Z' and substring(sku, 1, 1)<>'F' ";
if (!empty($sku)) {
$where .= "AND sku like'{$sku}%' ";
}
if (!empty($purchaseId)) {
$where .= "AND purchaseId='{$purchaseId}' ";
}
//第一步筛选，选出isNew=1,并且goodsName!=''和'无'，sku不已F和Z开头的spu
$spuList1 = $omAvailableAct->act_getTNameList($tName, $select, $where);
$spuArr1 = array();
foreach ($spuList1 as $value) {
if (!empty($value['spu'])) {
$spuArr1[] = $value['spu'];
}
}
//此时 $spuSkuRelationArr1中保存的是spu和sku的关系数组，形如 array('1201'=>array('1201_B','1201_W'),'1202'=>array('1202'));
//此时 $spuSkuRelationArr1中保存的是spu和sku的关系数组，形如 array('1201'=>array('1201_B','1201_W'),'1202'=>array('1202'));
//第二步，选择出制作表已经存在的数据
$tName = 'pc_products';
$select = 'sku';
$where = "WHERE is_delete=0 ";
$skuList2 = OmAvailableModel::getTNameList($tName, $select, $where);
$spuArr2 = array();
foreach ($skuList2 as $value) {
$tmpArr = explode('_', $value['sku']);
if (!empty($tmpArr[0])) {
$spu = $tmpArr[0];
$spuArr2["{$spu}"] = $spu;
//SPU
}
}
//第三步，找出新品领料单中存在的sku;
$tName = 'pc_products_iostore_detail';
$select = 'sku';
$where = "WHERE is_delete=0 AND iostoreTypeId=1 AND useTypeId=1 AND isAudit<3 ";
$skuList3 = OmAvailableModel::getTNameList($tName, $select, $where);
$spuArr3 = array();
foreach ($skuList3 as $value) {
$tmpArr = explode('_', $value['sku']);
if (!empty($tmpArr[0])) {
$spu = $tmpArr[0];
$spuArr3["{$spu}"] = $spu;
//SPU
}
}
$saveSpuArr = array();
//要保留的SPU
foreach ($spuArr1 as $value) {
if (!in_array($value, $spuArr2, true) && !in_array($value, $spuArr3, true)) {
//SPU不在$spuArr2，$spuArr3时保留
$saveSpuArr[] = "'" . $value . "'";
}
$saveSpuArr = array();
//要保留的SPU
foreach ($spuArr1 as $value) {
if (!in_array($value, $spuArr2) && !in_array($value, $spuArr3)) {
//SPU不在$spuArr2，$spuArr3时保留
$saveSpuArr[] = "'" . $value . "'";
}
}
if (empty($saveSpuArr)) {
$saveSpuStr = "'0'";
} else {
$saveSpuStr = implode(',', $saveSpuArr);
}
$tName = 'pc_goods';
$select = 'spu,sku,isNew';
$where = "WHERE is_delete=0 AND spu IN({$saveSpuStr})";
$skuList4 = OmAvailableModel::getTNameList($tName, $select, $where);
$spuSkuRelationArr1 = array();
$unSaveSpu = '';
}
$tName = 'pc_goods';
$select = 'spu,sku,isNew';
$where = "WHERE is_delete=0 AND spu IN({$saveSpuStr})";
$skuList4 = OmAvailableModel::getTNameList($tName, $select, $where);
$spuSkuRelationArr1 = array();
$unSaveSpu = '';
foreach ($skuList4 as $value) {
if ($value['isNew'] == 0) {
//过滤出全是新品的SPU
$unSaveSpu = $value['spu'];
}
if ($unSaveSpu == $value['spu']) {
continue;
}
$spuSkuRelationArr1[$value['spu']][] = $value['sku'];
}
$skuArr4 = array();
foreach ($skuList4 as $value) {
$skuArr4[] = "'" . $value['sku'] . "'";
}
if (empty($skuArr4)) {
$skuArrStr = "'0'";
} else {
$skuArrStr = implode(',', $skuArr4);
}
$tName = 'pc_goods_whId_location_raletion';
$select = 'sku';
$where = "WHERE location<>'' AND sku In({$skuArrStr}) ";
$where .= "AND whId={$whId} ";
$skuList5 = OmAvailableModel::getTNameList($tName, $select, $where);
$spuSkuRelationArr2 = array();
foreach ($skuList5 as $value) {
$tmpSpuArr = explode('_', $value['sku']);
if (!empty($tmpSpuArr[0])) {
$spuSkuRelationArr2[$tmpSpuArr[0]][] = $value['sku'];
}
}
$spuLastArr = array();
foreach ($spuSkuRelationArr1 as $spu => $skuArr) {
$tmpArray = $spuSkuRelationArr2[$spu];
if (count($skuArr) == count($tmpArray)) {
$spuLastArr[] = "'" . $spu . "'";
}
}
if (empty($spuLastArr)) {
$spuLastStr = "'0'";
} else {
$spuLastStr = implode(',', $spuLastArr);
}
$tName = 'pc_goods';
$select = 'spu,sku,goodsName,purchaseId,goodsCreatedTime';
$where = "WHERE is_delete=0 AND spu IN({$spuLastStr})";
$total = $omAvailableAct->act_getTNameCount($tName, $where);
$num = 1000;
//每页显示的个数
$page = new Page($total, $num, '', 'CN');
$where .= "order by sku " . $page->limit;
$newGoodsList = $omAvailableAct->act_getTNameList($tName, $select, $where);
$total = $omAvailableAct->act_getTNameCount($tName, $where);
$num = 1000;
//每页显示的个数
$page = new Page($total, $num, '', 'CN');
$where .= "order by sku " . $page->limit;
$newGoodsList = $omAvailableAct->act_getTNameList($tName, $select, $where);
if (!empty($_GET['page'])) {
if (intval($_GET['page']) <= 1 || intval($_GET['page']) > ceil($total / $num)) {
$n = 1;
} else {
$n = (intval($_GET['page']) - 1) * $num + 1;
}
} else {
$n = 1;
}
if ($total > $num) {
//输出分页显示
$show_page = $page->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9));
} else {
$show_page = $page->fpage(array(0, 2, 3));
}
$navlist = array(array('url' => 'index.php?mod=products&act=getProductsComfirmList', 'title' => '产品制作'), array('url' => 'index.php?mod=products&act=getProductsComfirmList', 'title' => '新品列表'));
$this->smarty->assign('navlist', $navlist);
$this->smarty->assign('onevar', 5);
$this->smarty->assign('twovar', 55);
$this->smarty->assign('show_page', $show_page);
$this->smarty->assign('title', '新品列表');
$whInfo = getWhInfo();
$whArr = array();
foreach ($whInfo as $value) {
$whArr[$value['id']] = $value['whName'];
}
if (!empty($newGoodsList)) {
$countNewGL = count($newGoodsList);
for ($i = 0; $i < $countNewGL; $i++) {
$tName = 'pc_goods_whId_location_raletion';
$select = '*';
$where = "WHERE sku='{$newGoodsList[$i]['sku']}' ";
$skuInfoList = OmAvailableModel::getTNameList($tName, $select, $where);
$newGoodsList[$i]['whId'] = $skuInfoList[0]['whId'];
$newGoodsList[$i]['wh'] = $whArr[$skuInfoList[0]['whId']];
$newGoodsList[$i]['location'] = $skuInfoList[0]['location'];
$newGoodsList[$i]['storageTime'] = $skuInfoList[0]['storageTime'];
}
}
$end1 = getMicrotime();
//echo $end1-$start1;exit;
$this->smarty->assign('newGoodsList', empty($newGoodsList) ? array() : $newGoodsList);
$this->smarty->display("newGoodsList.htm");
}
public function view_getInputList()
{
//调用action层， 获取列表数据
$omAvailableAct = new OmAvailableAct();
$status = $_GET['status'] ? $_GET['status'] : '';
$inputName = $_GET['inputName'] ? post_check(trim($_GET['inputName'])) : '';
$textStatus = $_GET['textStatus'] ? post_check(trim($_GET['textStatus'])) : '';
$pid = $_GET['pid'] ? post_check(trim($_GET['pid'])) : '';
$tName = 'pc_archive_input';
$select = '*';
$where = 'WHERE 1=1 ';
if (!empty($inputName)) {
$where .= "AND inputName='{$inputName}' ";
}
if (!empty($textStatus)) {
$where .= "AND textStatus='{$textStatus}' ";
}
if (!empty($pid)) {
$where .= "AND categoryPath REGEXP '^{$pid}(-[0-9]+)*\$' ";
//$where .= "AND categoryPath='$pid' ";
}
$total = $omAvailableAct->act_getTNameCount($tName, $where);
$num = 100;
//每页显示的个数
$page = new Page($total, $num, '', 'CN');
$where .= $page->limit;
$inputList = $omAvailableAct->act_getTNameList($tName, $select, $where);
if (!empty($_GET['page'])) {
if (intval($_GET['page']) <= 1 || intval($_GET['page']) > ceil($total / $num)) {
$n = 1;
} else {
$n = (intval($_GET['page']) - 1) * $num + 1;
}
} else {
$n = 1;
}
if ($total > $num) {
//输出分页显示
$show_page = $page->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9));
} else {
$show_page = $page->fpage(array(0, 2, 3));
}
$navlist = array(array('url' => 'index.php?mod=category&act=getCategoryList', 'title' => '类别管理'), array('url' => 'index.php?mod=property&act=getInputList', 'title' => '文本属性列表'));
$this->smarty->assign('navlist', $navlist);
$this->smarty->assign('onevar', 4);
$this->smarty->assign('twovar', 43);
$this->smarty->assign('show_page', $show_page);
$this->smarty->assign('title', '文本属性列表');
$this->smarty->assign('status', $status);
//取得搜索类别的记录
$pidArr = explode('-', $pid);
$this->smarty->assign('pidArr', $pidArr);
$this->smarty->assign('inputList', empty($inputList) ? null : $inputList);
$this->smarty->display("inputList.htm");
}
public function view_scanUpdateAccountList()
{
$omAvailableAct = new OmAvailableAct();
$id = isset($_GET['id']) ? post_check($_GET['id']) : '';
if (intval($id) == 0) {
//id为空时，跳转到列表页面，输出错误信息
$status = '<font color="red">数据异常</font>';
header("location:index.php?mod=omAccount&act=getAccountList&status={$status}");
exit;
}
$where = "WHERE id={$id} ";
$omAccountList = $omAvailableAct->act_getTNameList('om_account', '*', $where);
if (empty($omAccountList)) {
$status = '<font color="red">找不到要修改记录的id</font>';
header("location:index.php?mod=omAccount&act=getOmAccountList&status={$status}");
exit;
} else {
$value = $omAccountList[0];
}
//设置修改页面上指定字段的值
$navlist = array(array('url' => 'index.php?mod=omPlatform&act=getOmPlatformList', 'title' => '系统设置'), array('url' => 'index.php?mod=omAccount&act=getAccountList', 'title' => '平台账号'), array('url' => '', 'title' => '修改账号'));
$this->smarty->assign('navlist', $navlist);
$this->smarty->assign('toptitle', '修改账号');
$this->smarty->assign('toplevel', 3);
$this->smarty->assign('secondlevel', '32');
$this->smarty->assign("id", $value['id']);
$this->smarty->assign("account", $value['account']);
$this->smarty->assign("appname", $value['appname']);
$this->smarty->assign("platformId", $value['platformId']);
$this->smarty->assign("email", $value['email']);
$this->smarty->assign("suffix", $value['suffix']);
$this->smarty->assign("charger", $value['charger']);
$this->smarty->display("omUpdateAccountList.htm");
}
public function view_updateBlackList()
{
$omAvailableAct = new OmAvailableAct();
if (!isset($_REQUEST['platformUsername'])) {
//读取要修改的数据并显示到黑名单修改页面
$navlist = array(array('url' => 'index.php?mod=omPlatform&act=getOmPlatformList', 'title' => '系统设置'), array('url' => 'index.php?mod=OmBlackList&act=getOmBlackList', 'title' => '平台黑名单'), array('url' => '', 'title' => '修改黑名单'));
$platform = $omAvailableAct->act_getTNameList('om_platform', 'id,platform', 'WHERE is_delete=0');
$omBlackList = $omAvailableAct->act_getTNameList('om_blacklist', '*', ' WHERE id = ' . $_REQUEST['id']);
$platformselected = isset($_REQUEST['platformId']) ? $_REQUEST['platformId'] : $omBlackList[0]['platformId'];
$account = $omAvailableAct->act_getTNameList('om_account', 'account,id', 'WHERE is_delete=0 AND platformId = ' . $platformselected);
$this->smarty->assign('navlist', $navlist);
$this->smarty->assign('toptitle', '平台黑名单');
$this->smarty->assign('toplevel', 3);
$this->smarty->assign('secondlevel', '34');
$this->smarty->assign('account', $account);
$this->smarty->assign('platformselected', $platformselected);
$this->smarty->assign('platform', $platform);
$this->smarty->assign('omBlackList', $omBlackList[0]);
$this->smarty->display("updateBlackList.htm");
} else {
//修改黑名单
$id = $_REQUEST['id'];
$platformUsername = $_REQUEST['platformUsername'];
$username = $_REQUEST['username'];
$usermail = $_REQUEST['usermail'];
$street = $_REQUEST['street'];
$phone = $_REQUEST['phone'];
$platformId = $_REQUEST['platformId'];
$account = $_REQUEST['account'];
$status = '';
$omAvailableAct = new OmAvailableAct();
$tName = 'om_blacklist';
$addUser = '******';
$addTime = time();
$set = "SET platformUsername='******',username='******',usermail='{$usermail}',street='{$street}',phone='{$phone}',addTime='{$addTime}',platformId='{$platformId}',account='{$account}'";
$where = "WHERE id='{$id}'";
$affectRow = $omAvailableAct->act_updateTNameRow($tName, $set, $where);
if ($affectRow !== false) {
$status = '修改成功';
} else {
$status = '修改失败';
}
header('location:index.php?mod=omBlackList&act=getOmBlackList&status=' . $status);
}
}
public function view_abnormalStockList()
{
global $memc_obj;
$pagesize = 200;
//页面大小
//var_dump($AbOrderList); exit;
$omAvailableAct = new OmAvailableAct();
$TransAPIAct = new TransAPIAct();
$OrderindexAct = new OrderindexAct();
$GoodsAct = new GoodsAct();
$OrderRefundAct = new OrderRefundAct();
//平台信息
$OmAccountAct = new OmAccountAct();
$WarehouseAPIAct = new WarehouseAPIAct();
$AbOrderList = $WarehouseAPIAct->act_getAbOrderList();
//var_dump($AbOrderList); exit;
$AbOrderListArr = array();
$AbOrderids = array();
$AbOrderShow = array();
foreach ($AbOrderList as $orderId) {
$AbOrderInfo = $WarehouseAPIAct->act_getAbOrderInfo($orderId['id']);
$AbOrderListArr[$orderId['originOrderId']] = $AbOrderInfo;
$AbOrderids[] = $orderId['originOrderId'];
$AbOrderShow[$orderId['originOrderId']] = $orderId['id'];
}
//var_dump($AbOrderListArr); exit;
$this->smarty->assign('AbOrderListArr', $AbOrderListArr);
$this->smarty->assign('AbOrderShow', $AbOrderShow);
//var_dump($AbOrderListArr); exit;
$platform = $OmAccountAct->act_getPlatformListByPower();
$this->smarty->assign('platform', $platform);
$account = $OmAccountAct->act_accountAllListById();
//账号信息
/**导航 start**/
$ostatus = isset($_GET['ostatus']) ? $_GET['ostatus'] : 0;
$this->smarty->assign('ostatus', 770);
$StatusMenuAct = new StatusMenuAct();
$ostatusList = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = 0 AND is_delete=0');
//var_dump($ostatusList);
$this->smarty->assign('ostatusList', $ostatusList);
//二级目录
/*$o_secondlevel = $omAvailableAct->act_getTNameList('om_status_menu','*','WHERE is_delete=0 and groupId=0 order by sort asc');
$this->smarty->assign('o_secondlevel', $o_secondlevel);*/
$second_count = array();
$second_type = array();
foreach ($ostatusList as $o_secondinfo) {
$orderStatus = $o_secondinfo['statusCode'];
//echo $orderStatus."============"; echo "<br>";
$s_total = $OrderindexAct->act_showSearchOrderNum($orderStatus);
//echo $orderStatus."==".$s_total; echo "<br>";
$second_count[$o_secondinfo['statusCode']] = $s_total;
$s_type = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = "' . $orderStatus . '" AND is_delete=0 order by sort asc');
$second_type[$orderStatus] = $s_type[0]['statusCode'];
}
$this->smarty->assign('second_count', $second_count);
$this->smarty->assign('second_type', $second_type);
//退款数量
$where = " WHERE is_delete=0 ";
$accountList = $_SESSION['accountList'];
$platformList = $_SESSION['platformList'];
//echo "<pre>"; print_r($accountList); exit;
$platformsee = array();
for ($i = 0; $i < count($platformList); $i++) {
$platformsee[] = $platformList[$i];
}
if ($platformsee) {
$where .= ' AND platformId IN (' . join(",", $platformsee) . ') ';
} else {
//$where .= " AND 1=2 ";
}
$accountsee = array();
for ($i = 0; $i < count($accountList); $i++) {
$accountsee[] = $accountList[$i];
}
if ($accountsee) {
$where .= ' AND accountId IN (' . join(",", $accountsee) . ') ';
} else {
//$where .= " AND 1=2 ";
}
//if($where){
//$refund_total = $omAvailableAct->act_getTNameCount("om_order_refund"," where is_delete=0 ");
$refund_total = $OrderRefundAct->act_getRecordNums();
//}else{
//$refund_total = 0;
//}
$this->smarty->assign('refund_total', $refund_total);
//三级目录
/*$refund_one = $omAvailableAct->act_getTNameCount("om_order_refund"," where is_delete=0 and status=0");
$this->smarty->assign('refund_one', $refund_one);
$refund_two = $omAvailableAct->act_getTNameCount("om_order_refund"," where is_delete=0 and status=1");
$this->smarty->assign('refund_two', $refund_two);
$refund_three = $omAvailableAct->act_getTNameCount("om_order_refund"," where is_delete=0 and status=2");
$this->smarty->assign('refund_three', $refund_three);*/
/**导航 end**/
$toptitle = '异常缺货统计页面';
//头部title
$this->smarty->assign('toptitle', $toptitle);
$this->smarty->assign('toplevel', 0);
$threelevel = '1';
//当前的三级菜单
$this->smarty->assign('threelevel', $threelevel);
$statusMenu = $omAvailableAct->act_getTNameList('om_status_menu', ' * ', 'WHERE is_delete=0');
$this->smarty->assign('statusMenu', $statusMenu);
/* $where = ' WHERE is_delete = 0 '.$where;
$total = $omAvailableAct->act_getTNameCount('om_order_refund', $where);*/
$parameterArr = array();
$parameterArr['AbOrderList'] = $AbOrderids;
$total = $OrderindexAct->act_showABOrder($ostatus, $otype, '', $parameterArr);
$this->smarty->assign('abnormal_total', $total);
//echo $total; exit;
$num = $pagesize;
//每页显示的个数
$page = new Page($total, $num, '', 'CN');
//$limit = $page->limit;
//var_dump($parameterArr);
$omOrderList = $OrderindexAct->act_showABOrder($ostatus, $otype, $page->limit, $parameterArr);
$this->smarty->assign('omOrderList', $omOrderList);
$pm = $GoodsAct->act_getMaterInfoByList();
$transportationList = $TransAPIAct->act_getCarrierListById();
$this->smarty->assign('transportationList', $transportationList);
if (!empty($_GET['page'])) {
if (intval($_GET['page']) <= 1 || intval($_GET['page']) > ceil($total / $num)) {
$n = 1;
} else {
$n = (intval($_GET['page']) - 1) * $num + 1;
}
} else {
$n = 1;
}
if ($total > $num) {
//输出分页显示
$show_page = $page->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9));
} else {
$show_page = $page->fpage(array(0, 2, 3));
}
//获取系统所有状态
//$statusList = copyOrderModel::selectStatusList();
//var_dump($statusList); exit;
//$this->smarty->assign('statusList', $statusList);
$this->smarty->assign('show_page', $show_page);
$this->smarty->assign('account', $account);
//$this->smarty->assign('sku', $sku);
$this->smarty->assign('pm', $pm);
$this->smarty->assign('omOrderList', $omOrderList);
$this->smarty->display('orderindex.htm');
}
function getOrderDetailsById($orderId)
{
$purOrderId = isset($orderId) ? trim($orderId) : '';
if ($purOrderId == '') {
self::$errCode = 101;
self::$errMsg = '参数有误！';
return false;
}
$table = "`ph_order_detail`";
$field = " * ";
$condition = " WHERE po_id = '{$purOrderId}' AND is_delete = '0' ";
$ret = OmAvailableAct::act_getTNameList($table, $field, $condition);
return $ret;
}
function checkDuplicateOrder($orderId, $platformId)
{
$omAvailableAct = new OmAvailableAct();
$where = " WHERE recordNumber = '{$orderId}' AND is_delete = 0 and platformId = '{$platformId}'";
$res = $omAvailableAct->act_getTNameList('om_unshipped_order', 'id', $where);
$res2 = $omAvailableAct->act_getTNameList('om_shipped_order', 'id', $where);
if (empty($res) && empty($res2)) {
return false;
} else {
return true;
}
}
public function view_applyTheLineEUBTrackNumber()
{
global $memc_obj;
$OmEUBTrackNumberAct = new OmEUBTrackNumberAct();
if (isset($_GET) && !empty($_GET)) {
$orderid = isset($_GET['orderid']) ? $_GET['orderid'] : '';
$ostatus = isset($_GET['ostatus']) ? $_GET['ostatus'] : '';
$otype = isset($_GET['otype']) ? $_GET['otype'] : '';
}
$showerrorinfo = '';
//print_r($_POST);
if (isset($_FILES) && !empty($_FILES)) {
$info = $OmEUBTrackNumberAct->act_applyTheLineEUBTrackNumber();
if ($info) {
$showerrorinfo = "<font color=\"green\">上传成功！<br></font><font color=\"red\">" . $OmEUBTrackNumberAct::$errMsg . "</font>";
} else {
$showerrorinfo = "<font color=\"red\">上传成功！<br>" . $OmEUBTrackNumberAct::$errMsg . "</font>";
}
}
$this->smarty->assign('showerrorinfo', $showerrorinfo);
$omAvailableAct = new OmAvailableAct();
//平台信息
$platform = $omAvailableAct->act_getTNameList('om_platform', 'id,platform', 'WHERE is_delete=0');
//var_dump($platform);
$platformList = array();
foreach ($platform as $v) {
$platformList[$v['id']] = $v['platform'];
}
$this->smarty->assign('platformList', $platformList);
/**导航 start**/
$this->smarty->assign('ostatus', $ostatus);
$this->smarty->assign('otype', $otype);
//二级目录
$StatusMenuAct = new StatusMenuAct();
$ostatusList = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = 0 AND is_delete=0');
//var_dump($ostatusList);
$this->smarty->assign('ostatusList', $ostatusList);
$otypeList = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = "' . $ostatus . '" AND is_delete=0');
//var_dump($otypeList);
$this->smarty->assign('otypeList', $otypeList);
/*$o_secondlevel = $omAvailableAct->act_getTNameList('om_status_menu','*','WHERE is_delete=0 and groupId=0 order by sort asc');
$this->smarty->assign('o_secondlevel', $o_secondlevel);*/
$second_count = array();
$second_type = array();
foreach ($ostatusList as $o_secondinfo) {
$orderStatus = $o_secondinfo['statusCode'];
$accountacc = $_SESSION['accountacc'];
$oc_where = " where orderStatus='{$orderStatus}' and storeId=1 and is_delete=0 ";
if ($accountacc) {
$oc_where .= ' AND (' . $accountacc . ') ';
}
$s_total = $omAvailableAct->act_getTNameCount("om_unshipped_order", $oc_where);
$second_count[$o_secondinfo['statusCode']] = $s_total;
$s_type = $omAvailableAct->act_getTNameList("om_status_menu", "*", "WHERE is_delete=0 and groupId='{$orderStatus}' order by sort asc");
$second_type[$o_secondinfo['statusCode']] = $s_type[0]['statusCode'];
}
//var_dump($second_count);
$this->smarty->assign('second_count', $second_count);
$this->smarty->assign('second_type', $second_type);
//退款数量
$refund_total = $omAvailableAct->act_getTNameCount("om_order_refund", " where is_delete=0");
$this->smarty->assign('refund_total', $refund_total);
//三级目录
$o_threelevel = $omAvailableAct->act_getTNameList("om_status_menu", "*", "WHERE is_delete=0 and groupId='{$ostatus}' order by sort asc");
$this->smarty->assign('o_threelevel', $o_threelevel);
$three_count = array();
foreach ($o_threelevel as $o_threeinfo) {
$orderType = $o_threeinfo['statusCode'];
$s_total = $omAvailableAct->act_getTNameCount("om_unshipped_order", " where orderStatus='{$ostatus}' and orderType='{$orderType}' and storeId=1 and is_delete=0");
$three_count[$o_threeinfo['statusCode']] = $s_total;
}
$this->smarty->assign('three_count', $three_count);
$toptitle = '订单显示页面';
//头部title
$this->smarty->assign('toptitle', $toptitle);
$this->smarty->assign('toplevel', 0);
$threelevel = '1';
//当前的三级菜单
$this->smarty->assign('threelevel', $threelevel);
$statusMenu = $omAvailableAct->act_getTNameList('om_status_menu', ' * ', 'WHERE is_delete=0 ');
$this->smarty->assign('statusMenu', $statusMenu);
//var_dump($data); exit;
$this->smarty->display('eubTheLineApply.htm');
}
