function act_getProducts2pc($select, $where) { $listArr = UserCacheModel::getOpenSysApi('pc.getEbayProducts2PcProducts', array('all' => 'all'), 'gw88'); if ($listArr) { foreach ($listArr as $value) { $tName = 'pc_products'; $where = "WHERE is_delete=0 and productsStatus=1 and sku='{$value['sku']}'"; $skuCount = OmAvailableModel::getTNameCount($tName, $where); if (!$skuCount) { $pc_pro = array(); $pc_pro['id'] = $value['id']; if (!empty($value['sku'])) { $tmpArr = explode('_', $value['sku']); $pc_pro['spu'] = $tmpArr[0]; } $pc_pro['sku'] = $value['sku']; $pc_pro['productsStatus'] = 1; $pc_pro['productsComfirmerId'] = getPersonIdByName($value['comfirmuser']); $pc_pro['productsComfirmTime'] = $value['comfirmtime']; OmAvailableModel::addTNameRow2arr($tName, $pc_pro); } } self::$errCode = 200; self::$errMsg = 'success'; return true; } else { self::$errCode = 404; self::$errMsg = 'error'; return false; } }
function act_getTNameCount($tName, $where) { $ret = OmAvailableModel::getTNameCount($tName, $where); if ($ret !== false) { return $ret; } else { self::$errCode = OmAvailableModel::$errCode; self::$errMsg = OmAvailableModel::$errMsg; return false; } }
function act_getTNameCount() { $jsonArr = isset($_GET['jsonArr']) ? $_GET['jsonArr'] : ''; //传过来的base64编码的json字符串 if (empty($jsonArr)) { self::$errCode = 101; self::$errMsg = '参数数组为空'; return false; } $jsonArr = json_decode(base64_decode($jsonArr), true); //对base64及json解码 if (!is_array($jsonArr)) { self::$errCode = 103; self::$errMsg = '参数数组不是数组格式'; return false; } $tName = $jsonArr['tName']; //表名 $where = $jsonArr['where']; //where,要带上关键字WHERE if (empty($tName) || empty($where)) { self::$errCode = '300'; self::$errMsg = '必要参数不完整'; return false; } $count = OmAvailableModel::getTNameCount($tName, $where); if ($count !== false) { self::$errCode = '200'; self::$errMsg = '成功'; return $count; } else { self::$errCode = '404'; self::$errMsg = '数据库操作错误'; return false; } }
function push_ebay_orderid_queue($ebay_orderid, $ebay_account, $rabbit = "", $recordNumber = "") { global $dbConn, $rabbitMQClass, $FLIP_GLOBAL_EBAY_ACCOUNT; //var_dump($rabbitMQClass); if ($rabbit != "") { $rabbitMQClass = $rabbit; } $accountId = $FLIP_GLOBAL_EBAY_ACCOUNT[$ebay_account]; /* //step 1 check ebay orderid statistic table $where = " where orderid='".$ebay_orderid."' and accountId='".$accountId."' "; if(OrderidsModel::judgeOrderidsList('orderid',$where) === true){ echo "ebay orderid[$ebay_orderid] already exists in ebay orderid statistic table\n"; return false; }else{ //新增 } */ $tName = 'om_unshipped_order_extension_ebay'; $where = "WHERE orderId='{$ebay_orderid}'"; $flagCountUnshipped = OmAvailableModel::getTNameCount($tName, $where); var_dump($flagCountUnshipped); $tName = 'om_shipped_order_extension_ebay'; $flagCountshipped = OmAvailableModel::getTNameCount($tName, $where); if (!empty($flagCountUnshipped) || !empty($flagCountshipped)) { return false; } //判断队列中是否有相同的值不能发布 //$table_name='ebay_order_id_queue_'.$ebay_account; $exchange = 'ebay_order_id_queue_' . $ebay_account; $rabbitMQClass->queue_publish($exchange, $ebay_orderid); return true; /*$check_sql='select * from '.$table_name.' where ebay_orderid="'.$ebay_orderid.'"'; $check=$dbConn->query($check_sql); $check=$dbConn->fetch_array_all($check); if(count($check)==0){ $sql='insert into '.$table_name.' (ebay_orderid) value("'.$ebay_orderid.'")'; $try_insert_count=0; while(1){ $try_insert_count++; $res=$dbConn->query($sql); if($res){ echo "Push ebay orderid[$ebay_orderid] into queue table successfully!\n"; break; }else{ if($try_insert_count==3){ $lost_orderid_path = EBAY_RAW_DATA_PATH.'lost_ebay_orderid/'.$ebay_account.'/lost_sql.txt'; write_lost_sql($lost_orderid_path, $sql."\n"); echo "oops...failed again,give this order[$ebay_orderid] up finally!\n"; break; } echo "fail to push ebay orderid[$ebay_orderid] into queue table !Sleep 10 sconds then try again\n"; sleep(10); } } }else{ echo "ebay orderid[$ebay_orderid] already exists in queue\n"; }*/ }
echo "\n"; $start = $per * $i; $tName = 'pc_goods_combine'; $select = 'combineSpu,combineUserId,addTime'; $where = "WHERE is_delete=0 limit {$start},{$per}"; $combineSpuList = OmAvailableModel::getTNameList($tName, $select, $where); foreach ($combineSpuList as $value) { $combineSpu = $value['combineSpu']; $combineUserId = $value['combineUserId']; $addTime = $value['addTime']; if (empty($combineSpu)) { continue; } $tName = 'pc_auto_create_spu'; $where = "WHERE spu='{$combineSpu}'"; $count1 = OmAvailableModel::getTNameCount($tName, $where); if (!$count1) { $dataAuto = array(); $dataAuto['spu'] = $combineSpu; $dataAuto['purchaseId'] = $combineUserId; $dataAuto['createdTime'] = $addTime; $dataAuto['status'] = 2; $dataAuto['isSingSpu'] = 2; if (strpos($combineSpu, 'CB') === 0) { $dataAuto['prefix'] = 'CB'; } OmAvailableModel::addTNameRow2arr($tName, $dataAuto); echo "{$combineSpu} insert autoCreateSpu success\n"; } else { echo "{$combineSpu} has exist autoCreateSpu\n"; }
public function view_addOrUpdateSpeicailSpuOn() { $useId = $_SESSION['userId']; $personName = getPersonNameById($useId); if (empty($personName)) { $status = "<font color=red>系统找不到登录人信息!</font><br/>"; echo $status; exit; } if (isset($_POST['submit']) && $_POST['submit'] != '') { $uploadfile = 'addOrUpdateSpeicailSpuExcelImport_' . date("Y") . date("m") . date("d") . date("H") . date('i') . date('s') . '_' . $personName . ".xls"; if (move_uploaded_file($_FILES['upfile']['tmp_name'], 'upload/' . $uploadfile)) { echo "<font color=BLUE>文件上传成功!</font><br>"; } else { echo "<font color=red> 文件上传失败!</font>"; exit; } $fileName = 'upload/' . $uploadfile; $filePath = $fileName; $PHPExcel = new PHPExcel(); $PHPReader = new PHPExcel_Reader_Excel2007(); if (!$PHPReader->canRead($filePath)) { $PHPReader = new PHPExcel_Reader_Excel5(); if (!$PHPReader->canRead($filePath)) { echo 'no Excel'; return; } } $PHPExcel = $PHPReader->load($filePath); $currentSheet = $PHPExcel->getSheet(0); $highestRow = $currentSheet->getHighestRow(); //表格中的最大行数 echo "表格总行数为 {$highestRow} <br />"; if ($highestRow > 30000) { echo "表格不能超过30000行,请重新整理表格导入,谢谢!"; exit; } $status = ''; $flag = true; //标识检测结果 $tName = 'pc_special_property'; $select = 'id,propertyName'; $where = "WHERE isOn=1"; $pspList = OmAvailableModel::getTNameList($tName, $select, $where); $IPArr = array(); foreach ($pspList as $value) { $IPArr[$value['id']] = $value['propertyName']; } if (empty($IPArr)) { echo "启用的特殊属性记录为空,退出"; exit; } for ($i = 2; $i <= $highestRow; $i++) { //先检查导入表格的正确性 $spu = trim($currentSheet->getCell('A' . $i)->getValue()); //spu $spu = preg_replace("/(\\s|\\ \\;| | )/", "", $spu); $spu = strpos($spu, '_') === false ? str_pad($spu, 3, '0', STR_PAD_LEFT) : $spu; $specailPropertyName = trim($currentSheet->getCell('B' . $i)->getValue()); //$specailPropertyName = preg_replace("/(\s|\ \;| |\xc2\xa0)/","",$specailPropertyName); if (empty($spu)) { $status .= "第 {$i} 行,SPU为空 <br/>"; $flag = false; continue; } $tName = 'pc_auto_create_spu'; $where = "WHERE is_delete=0 AND isSingSpu=1 AND spu='{$spu}'"; if (!OmAvailableModel::getTNameCount($tName, $where)) { $status .= "第 {$i} 行,SPU不存在 <br/>"; $flag = false; continue; } $propertyId = intval(array_search($specailPropertyName, $IPArr)); if ($propertyId <= 0) { $status .= "第 {$i} 行,找不到 {$specailPropertyName} 这个特殊属性记录 <br/>"; $flag = false; continue; } } if (!$flag) { //验证不通过 echo "<font color=red>{$status}</font>"; exit; } else { $status = ''; for ($i = 2; $i <= $highestRow; $i++) { //先检查导入表格的正确性 $spu = trim($currentSheet->getCell('A' . $i)->getValue()); //spu $spu = preg_replace("/(\\s|\\ \\;| | )/", "", $spu); $spu = strpos($spu, '_') === false ? str_pad($spu, 3, '0', STR_PAD_LEFT) : $spu; $specailPropertyName = trim($currentSheet->getCell('B' . $i)->getValue()); //spu $propertyId = intval(array_search($specailPropertyName, $IPArr)); $tName = 'pc_special_property_spu'; $where = "WHERE spu='{$spu}' AND propertyId={$propertyId}"; if (OmAvailableModel::getTNameCount($tName, $where)) { $status .= "第 {$i} 行,{$spu} 已经存在 {$specailPropertyName} 这个特殊属性<br/>"; } else { $dataArr = array(); $dataArr['spu'] = $spu; $dataArr['propertyId'] = $propertyId; OmAvailableModel::addTNameRow2arr($tName, $dataArr); $status .= "第 {$i} 行,{$spu} 添加至 {$specailPropertyName} 成功 <br/>"; } } echo "<font color=green>{$status}</font>"; exit; } } }
public function view_getProductsCombineSpuCompleteList() { $combineSpu = $_GET['combineSpu'] ? post_check(trim($_GET['combineSpu'])) : ''; $userId = $_SESSION['userId']; $tName = 'pc_spu_web_maker a,(select spu,max(id) as id from pc_spu_web_maker group by spu) b'; $select = 'a.*'; $where = 'where a.is_delete=0 AND a.isSingSpu=2 AND a.isTake=1 AND a.isComplete=1 AND a.spu=b.spu and a.id=b.id '; if (!isAccessAll('products', 'getAllCombineSpuListPermission')) { $where .= "AND a.webMakerId='{$userId}' "; } if (!empty($combineSpu)) { $skuArr = array_filter(explode(',', $combineSpu)); $countSkuArr = count($skuArr); for ($i = 0; $i < $countSkuArr; $i++) { if (preg_match("/^[A-Z0-9]+\$/", $skuArr[$i])) { if ($i == 0) { $where .= " AND (a.spu like'{$skuArr[$i]}%' "; } else { $where .= " OR a.spu like'{$skuArr[$i]}%'"; } if ($i == $countSkuArr - 1) { $where .= ") "; } } } } $total = OmAvailableModel::getTNameCount($tName, $where); $num = 50; //每页显示的个数 $page = new Page($total, $num, '', 'CN'); $where .= "order by a.completeTime desc " . $page->limit; $productsComfirmList = OmAvailableModel::getTNameList($tName, $select, $where); if (!empty($productsComfirmList)) { $countProComList = count($productsComfirmList); for ($i = 0; $i < $countProComList; $i++) { $tName = 'pc_auto_create_spu'; $select = 'purchaseId'; $where = "WHERE is_delete=0 AND spu='{$productsComfirmList[$i]['spu']}'"; $autoSpuList = OmAvailableModel::getTNameList($tName, $select, $where); if (!empty($autoSpuList)) { $productsComfirmList[$i]['purchaseId'] = $autoSpuList[0]['purchaseId']; } } } 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=getProductsCombineSpuCompleteList', 'title' => '3.虚拟SPU完成')); $this->smarty->assign('navlist', $navlist); $this->smarty->assign('onevar', 5); $this->smarty->assign('twovar', 515); $this->smarty->assign('show_page', $show_page); $this->smarty->assign('title', '3.虚拟SPU完成'); $this->smarty->assign('productsCombineSpuList', empty($productsComfirmList) ? array() : $productsComfirmList); $this->smarty->display("productsCombineSpuCompleteList.htm"); }
//continue; } if (preg_match("/^[A-Z]{2}[0-9]{6}\$/", $spu)) { $sort = intval(substr($spu, 2)); } else { $sort = 0; } $set = "SET spu='{$spu}',purchaseId='{$purchaseId}',createdTime='{$now}',sort='{$sort}',status=2"; if (!$countAutoCreSpu) { OmAvailableModel::addTNameRow($tName, $set); echo "{$spu} autoCreateSpu insert success\n"; } //添加SPU档案 $tName = 'pc_spu_archive'; $where = "WHERE spu='{$spu}'"; $countSpuArchive = OmAvailableModel::getTNameCount($tName, $where); if ($countSpuArchive) { echo "{$spu} spuArchive has exist!\n"; $set = "SET categoryPath='{$value['goods_category']}',purchaseId='{$pcGoodsArr['purchaseId']}'"; OmAvailableModel::updateTNameRow($tName, $set, $where); echo "{$spu} spuArchive update category and purchaseId success! {$value['goods_category']} {$pcGoodsArr['purchaseId']} \n"; //continue; } $dataSpuArchive = array(); $dataSpuArchive['spu'] = $spu; $dataSpuArchive['categoryPath'] = $value['goods_category']; $dataSpuArchive['spuName'] = $value['goods_name']; $dataSpuArchive['spuPurchasePrice'] = $value['goods_cost']; $dataSpuArchive['spuLowestPrice'] = $value['goods_cost']; $dataSpuArchive['spuCalWeight'] = $value['goods_weight']; $dataSpuArchive['isPacking'] = $value['ispacking'] == 0 ? 1 : 2;
public function view_getSpuSpecialTMList() { $spu = $_GET['spu'] ? post_check(trim($_GET['spu'])) : ''; $tName = 'pc_special_transport_manager'; $select = '*'; $where = 'WHERE 1=1 '; $tmpTMIdStr = ''; if (!empty($spu)) { $tNameSpu = 'pc_special_transport_manager_spu'; $selectSpu = 'stmnId'; $whereSpu = "WHERE spu='{$spu}' group by stmnId"; $propertyIdList = OmAvailableModel::getTNameList($tNameSpu, $selectSpu, $whereSpu); $tmpArr = array(); foreach ($propertyIdList as $value) { $tmpArr[] = $value['stmnId']; } if (!empty($tmpArr)) { $tmpTMIdStr = implode(',', $tmpArr); } else { $tmpTMIdStr = '0'; } } if ($tmpTMIdStr != '') { $where .= "AND id in({$tmpTMIdStr})"; } $total = OmAvailableModel::getTNameCount($tName, $where); $num = 100; //每页显示的个数 $page = new Page($total, $num, '', 'CN'); $where .= "order by id desc " . $page->limit; $spuSpecialTMList = OmAvailableModel::getTNameList($tName, $select, $where); foreach ($spuSpecialTMList as $key => $value) { $tName = 'pc_special_stmnid_transportid'; $select = '*'; $where = "WHERE stmnId='{$value['id']}' limit 1"; $psstList = OmAvailableModel::getTNameList($tName, $select, $where); //$spuSpecialTMList[$key]['canOrNot'] = $psstList[0]['canOrNot']; } 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' => '#', 'title' => '特殊料号-运输方式管理列表')); $this->smarty->assign('navlist', $navlist); $this->smarty->assign('onevar', 4); $this->smarty->assign('twovar', 45); $this->smarty->assign('show_page', $show_page); $this->smarty->assign('title', '特殊料号-运输方式管理列表'); $this->smarty->assign('spuSpecialTMList', empty($spuSpecialTMList) ? null : $spuSpecialTMList); $this->smarty->display("spuSpecialTransportList.htm"); }
function act_addProductsCategoryAppoint() { $largeCategoryId = intval($_POST['largeCategoryId']); $appointPEId = intval($_POST['appointPEId']); $addUserId = $_SESSION['userId']; if ($largeCategoryId <= 0 || $appointPEId <= 0 || $addUserId <= 0) { self::$errCode = '101'; self::$errMsg = '必填项为空或登录超时,请检查'; return false; } $tName = 'pc_products_large_category_appoint'; $where = "WHERE is_delete=0 AND appointPEId={$appointPEId} AND largeCategoryId={$largeCategoryId}"; if (OmAvailableModel::getTNameCount($tName, $where)) { self::$errCode = '102'; self::$errMsg = '已经存在该记录'; return false; } $dataArr = array(); $dataArr['largeCategoryId'] = $largeCategoryId; $dataArr['appointPEId'] = $appointPEId; $dataArr['addUserId'] = $addUserId; $dataArr['addTime'] = time(); OmAvailableModel::addTNameRow2arr($tName, $dataArr); self::$errCode = '200'; self::$errMsg = '添加成功'; return true; }
public function view_getSpuModityRecordList() { $spu = isset($_GET['spu']) ? post_check($_GET['spu']) : ''; $recordType = isset($_GET['recordType']) ? post_check($_GET['recordType']) : ''; $PEId = isset($_GET['PEId']) ? post_check($_GET['PEId']) : ''; $status = isset($_GET['status']) ? post_check($_GET['status']) : ''; $addUserId = isset($_GET['addUserId']) ? post_check($_GET['addUserId']) : ''; $timeSearchType = isset($_GET['timeSearchType']) ? post_check($_GET['timeSearchType']) : ''; $startdate = isset($_GET['startdate']) ? post_check($_GET['startdate']) : ''; $enddate = isset($_GET['enddate']) ? post_check($_GET['enddate']) : ''; $tName = 'pc_spu_modify_record'; $select = '*'; $where = 'WHERE is_delete=0 '; if (!empty($spu)) { $where .= "AND spu='{$spu}' "; } if (intval($recordType) > 0) { $where .= "AND recordType='{$recordType}' "; } if (intval($PEId) > 0) { $where .= "AND PEId='{$PEId}' "; } if (intval($status) > 0) { $where .= "AND status='{$status}' "; } if (intval($addUserId) > 0) { if (intval($addUserId) == 9999) { $where .= "AND addUserId='0' "; } else { $where .= "AND addUserId='{$addUserId}' "; } } if (intval($timeSearchType) > 0) { if ($startdate != '') { $start = strtotime($startdate . ' 00:00:00'); if ($timeSearchType == 1) { $where .= "AND addTime>='{$start}' "; } elseif ($timeSearchType == 2) { $where .= "AND handleTime>='{$start}' "; } elseif ($timeSearchType == 3) { $where .= "AND completeTime>='{$start}' "; } } if ($enddate != '') { $end = strtotime($enddate . ' 23:59:59'); if ($timeSearchType == 1) { $where .= "AND addTime<='{$end}' "; } elseif ($timeSearchType == 2) { $where .= "AND handleTime<='{$end}' "; } elseif ($timeSearchType == 3) { $where .= "AND completeTime<='{$end}' "; } } } $total = OmAvailableModel::getTNameCount($tName, $where); $num = 100; //每页显示的个数 $page = new Page($total, $num, '', 'CN'); $where .= 'order by id desc '; $where .= $page->limit; $spuModityRecordList = OmAvailableModel::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=autoCreateSpu&act=getSpuModityRecordList', 'title' => 'SPU产品修改/优化管理')); $this->smarty->assign('navlist', $navlist); $this->smarty->assign('onevar', 2); $this->smarty->assign('twovar', 26); $this->smarty->assign('show_page', $show_page); $this->smarty->assign('title', 'SPU产品修改/优化管理'); $this->smarty->assign('spuModityRecordList', empty($spuModityRecordList) ? array() : $spuModityRecordList); $this->smarty->display("spuModifyRecordList.htm"); }
function isExistAppointByPEId2($PEId) { $tName = 'pc_products_large_category_appoint'; $where = "WHERE is_delete=0 and appointPEId='{$PEId}'"; $PECount = OmAvailableModel::getTNameCount($tName, $where); return $PECount; }
/** * 转移订单对应下的总表信息,没有批量处理事件 * @para $data as array * @add by Herman.Xi * @last modified 20131022 * $in 默认为进入订单模式 */ public static function shiftAllOrderRowNoEvent($orderData, $tName = 'om_shipped_order') { self::initDB(); //var_dump($orderData); exit; $obj_order_data = $orderData['orderData']; $orderExtenData = $orderData['orderExtenData']; $orderUserInfoData = $orderData['orderUserInfoData']; $orderDetailArr = $orderData['orderDetail']; $orderWhInfoData = $orderData['orderWhInfoData']; //var_dump($obj_order_data); exit; //$tName = 'om_unshipped_order'; $where = "WHERE recordNumber='{$obj_order_data['recordNumber']}' AND platformId={$obj_order_data['platformId']}"; $flagCountUnshipped = OmAvailableModel::getTNameCount($tName, $where); //var_dump($flagCountUnshipped); exit; /*$tName = 'om_shipped_order'; $flagCountshipped = OmAvailableModel :: getTNameCount($tName, $where);*/ if ($obj_order_data) { //判断订单是否已经在系统2个订单表(未发货和已发货)中存在 $platfrom = omAccountModel::getPlatformSuffixById($obj_order_data['platformId']); $extension = $platfrom['suffix']; //获取后缀名称 //echo $extension; echo "<br>"; exit; $insertOrderDataRow = self::insertOrderRow($obj_order_data, $tName); //插入到order表 if (empty($insertOrderDataRow)) { self::$errCode = "020"; self::$errMsg = "插入订单失败!"; return false; } //$orderExtenData['omOrderId'] = $obj_order_data['id']; //$orderExtenData['omOrderId'] = $insertOrderDataRow; //$orderUserInfoData['omOrderId'] = $insertOrderDataRow; //$orderUserInfoData['omOrderId'] = $obj_order_data['id']; if ($orderExtenData) { $resultExten = self::insertExtension($orderExtenData, $extension, $tName); //插入到order_extend表 if (!$resultExten) { self::$errCode = "021"; self::$errMsg = "插入订单附加表失败!"; return false; } } if ($orderUserInfoData) { $resultUserInfo = self::insertUserinfoRow($orderUserInfoData, $tName); //插入到order_userInfo表 if (!$resultUserInfo) { self::$errCode = "022"; self::$errMsg = "插入用户信息表失败!"; return false; } } if ($orderWhInfoData) { $resultWhInfo = self::insertWhInfoRow($orderWhInfoData, $tName); //插入到order_userInfo表 if (!$resultWhInfo) { self::$errCode = "022"; self::$errMsg = "插入仓库信息表失败!"; return false; } } foreach ($orderDetailArr as $orderDetail) { $orderDetailData = $orderDetail['orderDetailData']; $orderDetailExtenData = $orderDetail['orderDetailExtenData']; //$orderDetailData['omOrderId'] = $insertOrderDataRow; //$orderDetailData['omOrderId'] = $obj_order_data['id']; $orderDetailData['createdTime'] = time(); $insertOrderDatilRow = self::insertOrderdetail($orderDetailData, $tName); //插入到detail表 if (empty($insertOrderDatilRow)) { self::$errCode = "023"; self::$errMsg = "插入订明细单失败!"; return false; } //$orderDetailExtenData['omOrderdetailId'] = $insertOrderDatilRow; //$orderDetailExtenData['omOrderdetailId'] = $orderDetailData['id']; if ($orderDetailExtenData) { $resultOrderDetailExten = self::insertDetailExtension($orderDetailExtenData, $extension, $tName); //插入到detailExtend if (!$resultOrderDetailExten) { self::$errCode = "024"; self::$errMsg = "插入订单明细附带表失败!"; return false; } } } /*if($obj_order_data['platformId'] == 1 && $in){ $insertOrderidsDada = array('omOrderId'=>$insertOrderDataRow,'PayPalPaymentId'=>$orderData['orderExtenData']['PayPalPaymentId'],'orderid'=>$orderData['orderExtenData']['orderId'],'accountId'=>$orderData['orderData']['accountId'],'saletime'=>time()); $insertOrderids = OrderidsModel::insertOrderidsList($insertOrderidsDada); if (!$insertOrderids) { self::$errCode = "025"; self::$errMsg = "插入ebay订单IDS失败!"; return false; } } if(isset($orderData['orderNote']) && !empty($orderData['orderNote'])){ $orderNote = $orderData['orderNote']; $insertOrderNoteDada = array('omOrderId'=>$insertOrderDataRow,'content'=>$orderNote['content'],'userId'=>$orderNote['userId'],'createdTime'=>$orderNote['createdTime']); $insertOrderNoteids = self::insertOrderNotesRow($insertOrderNoteDada); if (!$insertOrderNoteids) { self::$errCode = "026"; self::$errMsg = "插入订单Note失败!"; return false; } }*/ /*$buyerInfo = $orderUserInfoData; $buyerInfo['platformId'] = $obj_order_data['platformId']; unset($buyerInfo['omOrderId']); unset($buyerInfo['countrySn']); unset($buyerInfo['currency']); unset($buyerInfo['currency']); //var_dump($buyerInfo); $insertBuyerInfo = self::insertBuyerInfoRow($buyerInfo); //var_dump($insertBuyerInfo); if (!$insertBuyerInfo) { return false; } $ProductStatus = new ProductStatus(); if(!$ProductStatus->updateSkuStatusByOrderStatus(array($insertOrderDataRow))){ self::$errCode = "400"; self::$errMsg = "已经包含订单信息,不能重复插入!"; return false; }*/ //var_dump($insertOrderDataRow); exit; //return $insertOrderDataRow; self::$errCode = "200"; self::$errMsg = "转移成功!"; return true; } else { self::$errCode = "400"; self::$errMsg = "已经包含订单信息,不能重复插入!"; return false; } }
public function view_3WithoutGoodsInfoExcelOutPutOn() { $fileName = "3WithoutGoodsInfoExcelOutPut.xls"; $excel = new ExportDataExcel('browser', $fileName); $excel->initialize(); $tableHeader = array('SPU', 'SKU', '仓位', '重量', '包材', '英文品名', '海关编码', '状态'); $excel->addRow($tableHeader); $visbleSpu = ''; $tName = 'pc_goods'; $select = 'spu'; $where = "WHERE is_delete=0 group by spu "; $spuList = OmAvailableModel::getTNameList($tName, $select, $where); foreach ($spuList as $value) { $spu = $value['spu']; $tName = 'pc_spu_tax_hscode'; $select = 'customsNameEN,hsCode'; $where = "WHERE spu='{$spu}'"; $spuHscodeList = OmAvailableModel::getTNameList($tName, $select, $where); $customsNameEN = $spuHscodeList[0]['customsNameEN']; //英文品名 $hsCode = $spuHscodeList[0]['hsCode']; //海关编码 $tName = 'pc_goods'; $select = 'sku,goodsWeight,goodsStatus,pmId'; $where = "WHERE is_delete=0 AND spu='{$spu}'"; $skuList = OmAvailableModel::getTNameList($tName, $select, $where); foreach ($skuList as $v) { $flag = 0; //标识是否属于三无产品 $sku = $v['sku']; $goodsWeight = $v['goodsWeight']; $pmId = $v['pmId']; $goodsStatus = $v['goodsStatus']; $tName = 'pc_goods_whId_location_raletion'; $where = "WHERE sku='{$sku}' AND isHasLocation=1"; $skuWlListCount = OmAvailableModel::getTNameCount($tName, $where); $isHasLocation = $skuWlListCount ? 1 : 2; //如果无内容则默认为无仓位 if (empty($customsNameEN)) { $flag = 1; } if (empty($hsCode)) { $flag = 1; } if ($goodsWeight == 0) { $flag = 1; } if (intval($pmId) <= 0) { $flag = 1; } if ($isHasLocation != 1) { $flag = 1; } if ($flag == 0) { continue; } $tableBody = array(); if ($visbleSpu == $spu) { $tableBody[] = ''; } else { $tableBody[] = $spu; } $tableBody[] = $sku; $tableBody[] = $isHasLocation == 1 ? '有' : '无'; $tableBody[] = $goodsWeight != 0 ? '有' : '无'; $tableBody[] = intval($pmId) > 0 ? '有' : '无'; $tableBody[] = !empty($customsNameEN) ? '有' : '无'; $tableBody[] = !empty($hsCode) ? '有' : '无'; $tableBody[] = $goodsStatus == 1 || $goodsStatus == 51 ? '在线' : '停售'; $visbleSpu = $spu; $excel->addRow($tableBody); } } $excel->finalize(); exit; }
function act_updateSkuConversion() { $id = $_GET['id'] ? post_check(trim($_GET['id'])) : 0; $id = intval($id); $new_sku = $_GET['new_sku'] ? post_check(trim($_GET['new_sku'])) : ''; //new_sku $modifiedUserId = intval($_SESSION['userId']); $modifiedTime = time(); if ($modifiedUserId <= 0) { self::$errCode = '103'; self::$errMsg = "登陆超时,请重试"; return; } if ($id <= 0) { self::$errCode = '100'; self::$errMsg = "异常"; return; } if (empty($new_sku)) { self::$errCode = '101'; self::$errMsg = "新料号不能为空"; return; } if (!preg_match("/^[A-Z0-9]+(_[A-Z0-9]+)*\$/", $new_sku)) { self::$errCode = '100'; self::$errMsg = "新料号 {$new_sku} 格式不合法"; return; } if ($modifiedUserId <= 0) { self::$errCode = '103'; self::$errMsg = "登陆超时,请重试"; return; } $tName = 'pc_sku_conversion'; $select = 'new_sku'; $where = "WHERE id={$id} and is_delete=0"; $skuConNewSkuList = OmAvailableModel::getTNameList($tName, $select, $where); //在料号转换表中找到id所在记录的新料号new_sku $skuConNewSku = $skuConNewSkuList[0]['new_sku']; if (empty($skuConNewSku)) { self::$errCode = '104'; self::$errMsg = "记录的新料号不存在"; return; } if ($skuConNewSku == $new_sku) { self::$errCode = '111'; self::$errMsg = "修改前后料号相同,无修改"; return; } $tName = 'pc_goods'; $select = '*'; $where = "WHERE is_delete=0 AND sku='{$skuConNewSku}'"; $newSkuPcList = OmAvailableModel::getTNameList($tName, $select, $where); //在产品表里找是否存在未修改前的料号 $newSkuPc = $newSkuPcList[0]; //未修改前的料号信息 if (empty($newSkuPc)) { self::$errCode = '105'; self::$errMsg = "修改前的料号 {$skuConNewSku} 在产品列表中不存在"; return; } $newSkuPcSku = $newSkuPc['sku']; //$newSkuPcArr = array_filter(explode('_',$newSkuPc));//修改前的sku按照_来截取 // $newSpuPc = $newSkuPcArr[0];//取得新料号的SPU // $newSkuArr = array_filter(explode('_',$new_sku));//修改后的sku按照_来截取 // $newSpu = $newSkuArr[0];//取得新料号的SPU // if($newSpuPc != $newSpu){ // self::$errCode = '107'; // self::$errMsg = "修改前后的SPU不符,请检查"; // return; // } try { BaseModel::begin(); $tName = 'pc_sku_conversion'; $set = "SET new_sku='{$new_sku}',modifiedUserId='{$modifiedUserId}',modifiedTime='{$modifiedTime}'"; $where = "WHERE id={$id} and is_delete=0"; OmAvailableModel::updateTNameRow($tName, $set, $where); //先将转换记录修改 $tName = 'pc_goods'; $set = "SET goodsStatus=101,is_delete=1"; //将未修改前的sku状态改为 料号转化,并delete $where = "WHERE is_delete=0 and sku='{$newSkuPcSku}'"; OmAvailableModel::updateTNameRow($tName, $set, $where); $where = "WHERE is_delete=0 and sku='{$new_sku}'"; $newSkuCount = OmAvailableModel::getTNameCount($tName, $where); if ($newSkuCount) { //如果新料号在产品中已经存在,则只添加转换记录 self::$errCode = '200'; self::$errMsg = "修改转换记录成功,新料号:{$new_sku} 已经存在记录"; } else { //如果新料号在产品表中不存在,则自动添加旧料号的记录进去 unset($newSkuPc['id']); //去掉旧记录的id $newSkuPc['sku'] = $new_sku; //将旧的sku换成新的sku OmAvailableModel::addTNameRow2arr($tName, $newSkuPc); self::$errCode = '200'; self::$errMsg = "修改转换记录成功,新料号:{$new_sku} 记录已插入成功"; } //下面对关联单料号的组合料号进行修改 $tName = 'pc_sku_combine_relation'; $select = '*'; $where = "WHERE sku='{$newSkuPcSku}' group by combineSku"; $skuRelationList = OmAvailableModel::getTNameList($tName, $select, $where); if (empty($skuRelationList)) { self::$errMsg .= "<br/>其中,无关联组合料号被更新"; } else { $combineSkuArr = array(); foreach ($skuRelationList as $value) { $combineSkuArr[] = $value['combineSku']; } $combineSkuStr = implode(',', $combineSkuArr); $set = "SET sku='{$new_sku}'"; $where = "WHERE sku='{$newSkuPcSku}'"; $affectRows = OmAvailableModel::updateTNameRow($tName, $set, $where); self::$errMsg .= "<br/>"; self::$errMsg .= "其中,组合料号 {$combineSkuStr} 中共有 {$affectRows} 条单料号数据已更新"; } ////// BaseModel::commit(); BaseModel::autoCommit(); return; } catch (Exception $e) { BaseModel::rollback(); BaseModel::autoCommit(); self::$errCode = '404'; self::$errMsg = $e->getMessage(); return; } }
/*include_once "/data/scripts/ebay_order_cron_job/ebay_order_cron_config.php"; include_once "/data/scripts/ebay_order_cron_job/function_purchase.php";*/ $tNameUnShipped = 'om_unshipped_order'; /*$tNameOrderIdList = OrderInfoModel :: getTNameOrderIdByTSA($tNameUnShipped, $start, $end,' 1=1',900); $orderIdArr = array (); foreach ($tNameOrderIdList as $value) { $orderIdArr[] = $value['id']; } $orderIdStr = implode(',', $orderIdArr); if (empty ($orderIdStr)) { $orderIdStr = 0; }*/ //$where = "WHERE id in($orderIdStr) AND channelId = '0' "; $where = "WHERE channelId=0 "; $count = OmAvailableModel::getTNameCount($tNameUnShipped, $where); $start = 0; $per = 5000; $page = ceil($count / $per); echo "totalcount = {$count}"; echo "\n"; echo "totalpage = {$page}"; echo "\n"; for ($i = 0; $i < $page; $i++) { echo "currentPage = {$i}"; echo "\n"; $start = $start * $i; $where = "WHERE channelId=0 "; $where .= " limit {$start},{$per}"; $shipOrderList = OrderindexModel::showOrderList($tNameUnShipped, $where); foreach ($shipOrderList as $key => $value) {
function act_getInStoreDetailList() { $iostoreId = $_GET['iostoreId'] ? post_check(trim($_GET['iostoreId'])) : 0; //退料单状态,草稿或者已经发送至仓库 $iostoreId = intval($iostoreId); if ($iostoreId <= 0) { $status = '退料单非法'; header("Location:index.php?mod=products&act=getInStoreList&status={$status}"); exit; } $tName = 'pc_products_iostore'; $select = '*'; $where = "WHERE iostoreTypeId=2 AND is_delete=0 AND id={$iostoreId} "; $inStoreList = OmAvailableModel::getTNameList($tName, $select, $where); $inStore = $inStoreList[0]; if (empty($inStore)) { $status = '系统不存在该退料单'; header("Location:index.php?mod=products&act=getInStoreList&status={$status}"); exit; } $tName = 'pc_products_iostore_detail'; $select = '*'; $where = "WHERE is_delete=0 AND iostoreId={$iostoreId} "; $total = OmAvailableModel::getTNameCount($tName, $where); $num = 1000; //每页显示的个数 $page = new Page($total, $num, '', 'CN'); $where .= "order by id desc " . $page->limit; $inStoreDetailList = OmAvailableModel::getTNameList($tName, $select, $where); if (!empty($inStoreDetailList)) { $whInfoList = getWhInfo(); //根据接口取得对应仓库信息 $whArr = array(); foreach ($whInfoList as $value) { if (intval($value['id']) > 0) { $whArr[$value['id']] = $value['whName']; } } $countStoreDetailList = count($inStoreDetailList); for ($i = 0; $i < $countStoreDetailList; $i++) { $sku = $inStoreDetailList[$i]['sku']; $tName = 'pc_goods'; $select = 'goodsName'; $where = "WHERE sku='{$sku}'"; $skuInfoList = OmAvailableModel::getTNameList($tName, $select, $where); $inStoreDetailList[$i]['goodsName'] = $skuInfoList[0]['goodsName']; $tName = 'pc_goods_whId_location_raletion'; $select = 'location,whId'; $where = "WHERE sku='{$sku}'"; $skuLocWhInfoList = OmAvailableModel::getTNameList($tName, $select, $where); $inStoreDetailList[$i]['location'] = $skuLocWhInfoList[0]['location']; $inStoreDetailList[$i]['whName'] = $whArr[$skuLocWhInfoList[0]['whId']]; } } 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)); } return array('inStore' => $inStore, 'inStoreDetailList' => $inStoreDetailList, 'show_page' => $show_page); }
function act_isSpuExist() { $spu = $_POST['spu'] ? trim(post_check($_POST['spu'])) : ''; $count = OmAvailableModel::getTNameCount('pc_auto_create_spu', "WHERE spu='{$spu}'"); if ($count) { return true; } else { self::$errCode = 1; self::$errMsg = '不存在此SPU'; return false; } }
function act_addInput() { //$pidNew = $_POST['pidNew']?post_check($_POST['pidNew']):'';//类别 $finalIdArr = $_POST['finalIdStr']; //新建属性-类别4 $inputName = $_POST['inputName'] ? post_check($_POST['inputName']) : ''; //类别 $textStatus = $_POST['textStatus'] ? post_check($_POST['textStatus']) : ''; //文本方式 if (empty($finalIdArr) || empty($inputName)) { self::$errCode = 101; self::$errMsg = '类别或属性名不能为空'; return false; } if (intval($textStatus) <= 0) { self::$errCode = 102; self::$errMsg = '文本方式有误'; return false; } $tmpArr = array(); if (!is_array($finalIdArr)) { $tmpArr[] = $finalIdArr; $finalIdArr = $tmpArr; } $finalPathArr = array(); foreach ($finalIdArr as $cid) { $catePath = CategoryModel::getCategoryPathById($cid); if (empty($catePath)) { self::$errCode = 109; self::$errMsg = '类别有误'; return false; } $finalPathArr[] = $catePath; } $tName = 'pc_goods_category'; foreach ($finalPathArr as $value) { $where = "WHERE path like'%{$value}-%' and is_delete=0"; $count = OmAvailableModel::getTNameCount($tName, $where); if ($count) { self::$errCode = 105; self::$errMsg = '只能在最小分类进行复制'; return false; } } try { $pidNewStr = ''; BaseModel::begin(); $tName = 'pc_archive_input'; foreach ($finalPathArr as $value) { $where = "WHERE inputName='{$inputName}' AND categoryPath='{$value}'"; $countIN = OmAvailableModel::getTNameCount($tName, $where); if (!$countIN) { $pidNewStr .= CategoryModel::getCategoryNameByPath($value) . ' '; $set = "SET inputName='{$inputName}',categoryPath='{$value}',textStatus='{$textStatus}'"; OmAvailableModel::addTNameRow($tName, $set); } } BaseModel::commit(); BaseModel::autoCommit(); self::$errCode = 200; self::$errMsg = "{$inputName} 添加到 {$pidNewStr} 成功"; return true; } catch (Exception $e) { BaseModel::rollback(); BaseModel::autoCommit(); self::$errCode = 201; self::$errMsg = $e->getMessage(); return false; } }
public function act_batchAddSpecialTMSpuOn() { $stmnId = $_POST['stmnId']; $spuArr = $_POST['spuArr']; if (intval($stmnId) <= 0) { self::$errCode = '101'; self::$errMsg = "异常,错误"; return false; } if (!is_array($spuArr) || empty($spuArr)) { self::$errCode = '102'; self::$errMsg = "SPU信息为空"; return false; } $spuArr = array_filter($spuArr); //print_r($spuArr);exit; $returnArr = array(); $spanStatus = ''; $insertSpuArr = array(); foreach ($spuArr as $spu) { if (preg_match("/^[A-Z0-9]+\$/", $spu)) { $tName = 'pc_special_transport_manager_spu'; $where = "WHERE spu='{$spu}'"; $pstmnSpuIsExist = OmAvailableModel::getTNameCount($tName, $where); if (!$pstmnSpuIsExist) { $tName = 'pc_goods'; $where = "WHERE is_delete=0 AND spu='{$spu}'"; $spuIsExist = OmAvailableModel::getTNameCount($tName, $where); if ($spuIsExist) { $tName = 'pc_special_transport_manager_spu'; $dataTmpArr = array(); $dataTmpArr['stmnId'] = $stmnId; $dataTmpArr['spu'] = $spu; $insertId = OmAvailableModel::addTNameRow2arr($tName, $dataTmpArr); $insertSpuArr[$insertId] = $spu; $spanStatus .= "<font color='green'>{$spu} 添加成功</font><br/>"; } else { $spanStatus .= "<font color='red'>{$spu} 在产品信息中不存在</font><br/>"; } } else { $spanStatus .= "<font color='red'>{$spu} 已经存在于特殊料号-运输方式管理中</font><br/>"; } } else { $spanStatus .= "<font color='red'>{$spu} 格式有误</font><br/>"; } } $returnArr['spanStatus'] = $spanStatus; $returnArr['insertSpuArr'] = $insertSpuArr; self::$errCode = '200'; self::$errMsg = "操作成功"; return $returnArr; }
function act_accountCount($accountCondition, $countCondition) { $accAct = new AccountAct(); $accountList = $accAct->act_getAccountList('id,account', "where platformId = 1 and token!='' and is_delete = 0 {$accountCondition}"); $tName = "fb_comment_record_ebay"; foreach ($accountList as $accountInfo) { $account = $accountInfo['account']; $PositiveSql = " where account='{$account}' and CommentType='Positive' {$countCondition}"; $PositiveRes = OmAvailableModel::getTNameCount($tName, $PositiveSql); //好评数 $NeutralSql = " where account='{$account}' and CommentType='Neutral' {$countCondition}"; $NeutralRes = OmAvailableModel::getTNameCount($tName, $NeutralSql); //中评数 $NegativeSql = " where account='{$account}' and CommentType='Negative' {$countCondition}"; $NegativeRes = OmAvailableModel::getTNameCount($tName, $NegativeSql); //差评数 $upNeutralsql = " where account='{$account}' and status='21' {$countCondition}"; $upNeutralRes = OmAvailableModel::getTNameCount($tName, $upNeutralsql); //中评修改数 $upNegativeSql = " where account='{$account}' and status='31' {$countCondition}"; $upNegetiveRes = OmAvailableModel::getTNameCount($tName, $upNegativeSql); //差评修改数 $total = $PositiveRes + $NeutralRes * 0.6 + $NegativeRes; //总评数 $per_positive = $PositiveRes / $total; $per_positive = round($per_positive * 100, 2); $countRes["{$account}"] = array("PositiveRes" => $PositiveRes, "NeutralRes" => $NeutralRes, "NegativeRes" => $NegativeRes, "upNeutralRes" => $upNeutralRes, "upNegetiveRes" => $upNegetiveRes, "total" => $total, "per_positive" => $per_positive); } return $countRes; var_dump($countRes); exit; }
public function view_addInputOn() { $inputName = $_GET['inputName'] ? post_check(trim($_GET['inputName'])) : ''; $pid = $_GET['pid'] ? post_check(trim($_GET['pid'])) : ''; if (empty($inputName)) { $status = "属性名不能为空"; header("Location:index.php?mod=property&act=addInput&status={$status}"); exit; } if (empty($pid)) { $status = "类别不能为空"; header("Location:index.php?mod=property&act=addInput&status={$status}"); exit; } $categoryName = getAllCateNameByPath($pid); $pathImplodeStr = getAllPathBypid($pid); $tName = 'pc_archive_input'; $where = "WHERE inputName='{$inputName}' and categoryPath IN ({$pathImplodeStr})"; $count = OmAvailableModel::getTNameCount($tName, $where); if ($count) { $status = "{$categoryName} 或其父类下已经存在 {$inputName} 属性"; header("Location:index.php?mod=property&act=addInput&status={$status}"); exit; } $set = "SET inputName='{$inputName}',categoryPath='{$pid}'"; $insertId = OmAvailableModel::addTNameRow($tName, $set); if (!$insertId) { $status = "系统插入数据错误"; header("Location:index.php?mod=property&act=addInput&status={$status}"); exit; } $status = "{$categoryName} 中添加 {$inputName} 文本属性成功"; header("Location:index.php?mod=property&act=addInput&status={$status}"); }
function act_getUnusualOrderList() { $sku = isset($_GET['sku']) ? $_GET['sku'] : ''; $purid = isset($_GET['purid']) ? base64_decode($_GET['purid']) : ''; $abStatus = isset($_GET['abStatus']) ? $_GET['abStatus'] : ''; $isConfirm = isset($_GET['isConfirm']) ? $_GET['isConfirm'] : ''; $startTime = isset($_GET['startTime']) ? $_GET['startTime'] : ''; $endTime = isset($_GET['endTime']) ? $_GET['endTime'] : ''; $page = isset($_GET['page']) ? $_GET['page'] : '1'; $where = "where storeId=1 and isConfirm=1 and abStatus=0 "; if (!empty($sku)) { $where .= "and sku='{$sku}' "; } if (!empty($purid)) { $where .= "and purchaseId in ({$purid}) "; } if (!empty($abStatus)) { $where .= "and abStatus='{$abStatus}' "; } if (is_numeric($isConfirm)) { $where .= "and isConfirm='{$isConfirm}' "; } if (!empty($startTime)) { $where .= "and createdTime>='{$startTime}' "; } if (!empty($endTime)) { $where .= "and createdTime<='{$endTime}' "; } $totalrow = OmAvailableModel::getTNameCount("wh_abnormal_purchase_orders", $where); $pagesize = 100; //每页显示条数 $pageindex = $page; $limit = "limit " . ($pageindex - 1) * $pagesize . ",{$pagesize}"; $where .= 'order by id desc ' . $limit; $list = OmAvailableModel::getTNameList("wh_abnormal_purchase_orders", "*", $where); $datalist[0] = $totalrow; $datalist[1] = $list; return json_encode($datalist); }
public function act_getSYNCCount() { $OrderTime1 = !empty($_POST['OrderTime1']) ? $_POST['OrderTime1'] : ''; $OrderTime2 = !empty($_POST['OrderTime2']) ? $_POST['OrderTime2'] : ''; $start = strtotime($OrderTime1); $end = strtotime($OrderTime2); //return $OrderTime1.' '.$OrderTime2; if ($start > 0 && $end > 0) { $tName = 'om_unshipped_order'; $where = " WHERE is_delete=0 AND orderAddTime>={$start} AND orderAddTime<={$end}"; $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 "; } $count = OmAvailableModel::getTNameCount($tName, $where); self::$errCode = 200; self::$errMsg = "同步订单数为 {$count}"; return false; } else { self::$errCode = 101; self::$errMsg = '请选择同步时间'; return false; } }
function act_addAutoSpuForOld() { $data = array(); $data['spu'] = trim($_POST['spu']); $data['isSingSpu'] = trim($_POST['isSingSpu']); $data['createdTime'] = time(); $data['purchaseId'] = $_SESSION['userId']; if (preg_match("/^[A-Z]{2}[0-9]{6}\$/", $data['spu'])) { $data['prefix'] = substr($data['spu'], 0, 2); $data['sort'] = intval(substr($data['spu'], 2)); } //验证spu是否已经存在 if ($data['isSingSpu'] == 1) { $tName = 'pc_goods'; $where = "WHERE spu='{$data['spu']}' and is_delete=0"; } else { $tName = 'pc_goods_combine'; $where = "WHERE combineSpu='{$data['spu']}' and is_delete=0"; } $res = OmAvailableModel::getTNameCount($tName, $where); if (empty($res)) { self::$errCode = 03; self::$errMsg = "{$data['spu']} 不在系统中存在,请重新添加"; return false; } else { $tName = 'pc_auto_create_spu'; $where = "WHERE spu='{$data['spu']}'"; $countSpu = OmAvailableModel::getTNameCount($tName, $where); if ($countSpu) { self::$errCode = 04; self::$errMsg = "{$data['spu']} 已经添加到自动生成SPU列表中"; return false; } if (SpuModel::insertSkuRow($data)) { return true; } else { self::$errCode = 05; self::$errMsg = '添加失败'; return false; } } }
function act_invokeListOrders(MarketplaceWebServiceOrders_Interface $service, $request, $account, $site, $accountId, $flip_transportList, $message) { // /global $account, $site, $accountId, $flip_transportList , $message; try { $response = $service->getOrder($request); //echo ("Service Response\n"); //echo ("=============================================================================\n"); if ($response->isSetGetOrderResult()) { //echo ("ListOrdersResult\n"); $listOrdersResult = $response->getGetOrderResult(); /*if ($listOrdersResult->isSetNextToken()) { //echo (" NextToken----"); //echo ($listOrdersResult->getNextToken() . "\n"); } if ($listOrdersResult->isSetCreatedBefore()) { //echo ("CreatedBefore----"); //echo ($listOrdersResult->getCreatedBefore() . "\n"); } if ($listOrdersResult->isSetLastUpdatedBefore()) { //echo ("LastUpdatedBefore----"); //echo ($listOrdersResult->getLastUpdatedBefore() . "\n"); }*/ if ($listOrdersResult->isSetOrders()) { $orders = $listOrdersResult->getOrders(); $orderList = $orders->getOrder(); $orderIndex = 1; $now = time(); //BaseModel :: begin(); //开始事务 foreach ($orderList as $order) { //echo ("***********Orders $orderIndex************\n\n"); $orderIndex++; $orderData = array(); //om_unshipped_order $orderUserInfoData = array(); //om_unshipped_order_userInfo $orderExtenData = array(); //om_unshipped_order_extension $street2 = ''; //街道2 $street3 = ''; //街道3 if ($order->isSetAmazonOrderId() && $order->isSetOrderStatus() && $order->getOrderStatus() == 'Unshipped') { //$orderData['ebay_status'] = 1; //同步进来的订单的状态 $orderData['recordNumber'] = $order->getAmazonOrderId(); //平台上的订单id //echo "AmazonOrderId ==== {$orderData['recordNumber']}\n"; } else { //echo 'getOrderStatus======' . $order->getOrderStatus() . "\n"; if ($order->getOrderStatus() == 'Shipped') { //表示已经发货了的订单 $shippedRecordNum = $order->getAmazonOrderId(); $tName = 'om_shipped_order'; $where = "WHERE recordNumber='{$shippedRecordNum}' and accountId='{$accountId}' and ShippedTime=''"; $set = "SET ShippedTime='{$now}'"; //标记发货时间 $affectRow = OmAvailableModel::updateTNameRow($tName, $set, $where); if ($affectRow) { $message .= "<font color='green'>update {$shippedRecordNum} ShippedTime success" . "</font><br>"; } else { $message .= "<font color='red'>update {$shippedRecordNum} ShippedTime fail may be has shippedTime or had no this recordNumber" . "</font><br>"; } } continue; } if ($order->isSetPurchaseDate()) { //亚马逊平台上的下单时间 $orderData['ordersTime'] = strtotime($order->getPurchaseDate()); //echo ("addTime ==== {$order->getPurchaseDate()}\n"); } if ($order->isSetLastUpdateDate()) { //支付时间 $orderData['paymentTime'] = strtotime($order->getLastUpdateDate()); //echo ("paidTime ==== {$order->getLastUpdateDate()}\n"); } $orderstatus = ''; //订单状态 //if ($order->isSetOrderStatus()) { // if($order->getOrderStatus() == 'Unshipped'){ // $orderstatus = 1; // } // } if ($order->isSetFulfillmentChannel()) { $orderExtenData['FulfillmentChannel'] = $order->getFulfillmentChannel(); //echo ("FulfillmentChannel ==== "); //订单配送方式 //echo ($orderExtenData['FulfillmentChannel'] . "\n"); } if ($order->isSetSalesChannel()) { $orderExtenData['SalesChannel'] = $order->getSalesChannel(); //echo ("SalesChannel ==== "); //echo ($orderExtenData['SalesChannel'] . "\n"); } if ($order->isSetOrderChannel()) { $orderExtenData['OrderChannel'] = $order->getOrderChannel(); //echo ("OrderChannel ===="); //echo ($orderExtenData['OrderChannel'] . "\n"); } if ($order->isSetShipServiceLevel()) { $orderExtenData['ShipServiceLevel'] = $order->getShipServiceLevel(); //echo ("ShipServiceLevel ==== "); //echo ($orderExtenData['ShipServiceLevel'] . "\n"); } if ($order->isSetShippingAddress()) { //判断是否设置了地址 $shippingAddress = $order->getShippingAddress(); if ($shippingAddress->isSetName()) { //获取收件人姓名 $orderUserInfoData['username'] = htmlentities($shippingAddress->getName(), ENT_QUOTES); //echo ("username ==== "); //echo ($orderUserInfoData['username'] . "\n"); } if ($shippingAddress->isSetAddressLine1()) { //街道1 $orderUserInfoData['street'] = htmlentities($shippingAddress->getAddressLine1(), ENT_QUOTES); //echo ("street ==== "); //echo ($orderUserInfoData['street'] . "\n"); } if ($shippingAddress->isSetAddressLine2()) { //街道2 $street2 = htmlentities($shippingAddress->getAddressLine2(), ENT_QUOTES); } if ($shippingAddress->isSetAddressLine3()) { //街道3 $street3 = htmlentities($shippingAddress->getAddressLine3(), ENT_QUOTES); } if ($shippingAddress->isSetCity()) { //城市 $orderUserInfoData['city'] = htmlentities($shippingAddress->getCity(), ENT_QUOTES); //echo ("city ==== "); //echo ($orderUserInfoData['city'] . "\n"); } if ($shippingAddress->isSetCounty()) { //郡,县 $orderUserInfoData['address2'] = htmlentities($shippingAddress->getCounty() . ' ' . $street2, ENT_QUOTES); $orderUserInfoData['address3'] = htmlentities($shippingAddress->getCounty() . ' ' . $street3, ENT_QUOTES); //echo ("address2 ==== "); //echo ($orderUserInfoData['address2'] . "\n"); //echo ("address3 ==== "); //echo ($orderUserInfoData['address3'] . "\n"); } if ($shippingAddress->isSetDistrict()) { //地方,区 //echo ("District ==== " . $shippingAddress->getDistrict() . "\n"); } if ($shippingAddress->isSetStateOrRegion()) { //州 $orderUserInfoData['state'] = htmlentities($shippingAddress->getStateOrRegion(), ENT_QUOTES); //echo ("state ==== "); //echo ($orderUserInfoData['state'] . "\n"); } if ($shippingAddress->isSetPostalCode()) { //邮编 $orderUserInfoData['zipCode'] = htmlentities($shippingAddress->getPostalCode(), ENT_QUOTES); //echo ("zipCode ==== "); //echo ($orderUserInfoData['zipCode'] . "\n"); } if ($shippingAddress->isSetCountryCode()) { //国家简称 /*$ebay_countrynames = array('US'=>'United States', "UK"=>"United Kingdom"); $orderData['ebay_couny'] = $shippingAddress->getCountryCode() ; $orderData['ebay_site'] = $shippingAddress->getCountryCode() ; $orderData['ebay_countryname'] = $ebay_countrynames[$shippingAddress->getCountryCode()];*/ //$sql = "SELECT regions_en FROM ebay_region WHERE regions_jc = '".$shippingAddress->getCountryCode()."'"; // $sql = $dbcon->execute($sql); // $amazon_countryname = $dbcon->fetch_one($sql); $orderUserInfoData['countrySn'] = $shippingAddress->getCountryCode(); //这里要调用运输方式管理系统的数据,获取国家简称对应的国家名称 $countryNameInfo = CommonModel::getCountrieInfoBySn($orderUserInfoData['countrySn']); //根据国家简称获取该国家的信息 //$orderData['ebay_site'] = $shippingAddress->getCountryCode() ; $orderUserInfoData['countryName'] = trim($countryNameInfo['regions_en']); //获得国家名称 //echo ("getCountryCode==== " . $orderUserInfoData['countrySn'] . "\n"); } if ($shippingAddress->isSetPhone()) { //手机 $orderUserInfoData['phone'] = $shippingAddress->getPhone(); //echo ("phone ==== "); //echo ($orderUserInfoData['phone'] . "\n"); } } if ($order->isSetOrderTotal()) { $orderTotal = $order->getOrderTotal(); if ($orderTotal->isSetCurrencyCode()) { //币种 $orderUserInfoData['currency'] = $orderTotal->getCurrencyCode(); //echo ("currency ==== "); //echo ($orderUserInfoData['currency'] . "\n"); } if ($orderTotal->isSetAmount()) { //订单总价,线上总价 $orderData['onlineTotal'] = $orderTotal->getAmount(); $orderData['actualTotal'] = $orderTotal->getAmount(); //echo ("onlineTotal ==== "); //echo ($orderData['onlineTotal'] . "\n"); } } if ($order->isSetNumberOfItemsShipped()) { //echo ("ItemsShipped ==== " . $order->getNumberOfItemsShipped() . "\n"); } if ($order->isSetNumberOfItemsUnshipped()) { //echo ("NumberOfItemsUnshipped ==== " . $order->getNumberOfItemsUnshipped() . "\n"); } if ($order->isSetPaymentExecutionDetail()) { $paymentExecutionDetail = $order->getPaymentExecutionDetail(); $paymentExecutionDetailItemList = $paymentExecutionDetail->getPaymentExecutionDetailItem(); foreach ($paymentExecutionDetailItemList as $paymentExecutionDetailItem) { echo "######PaymentExecutionDetailItem######\n"; if ($paymentExecutionDetailItem->isSetPayment()) { $payment = $paymentExecutionDetailItem->getPayment(); if ($payment->isSetCurrencyCode()) { //echo ("CurrencyCode ==== "); //echo ($payment->getCurrencyCode() . "\n"); } if ($payment->isSetAmount()) { //echo (" Amount ==== "); //echo ($payment->getAmount() . "\n"); } } if ($paymentExecutionDetailItem->isSetSubPaymentMethod()) { //echo ("SubPaymentMethod ==== "); //echo ($paymentExecutionDetailItem->getSubPaymentMethod() . "\n"); } } } if ($order->isSetPaymentMethod()) { $orderExtenData['PaymentMethod'] = $order->getPaymentMethod(); //echo ("PaymentMethod ==== "); //echo ($orderExtenData['PaymentMethod'] . "\n"); } if ($order->isSetMarketplaceId()) { $orderExtenData['MarketplaceId'] = $order->getMarketplaceId(); //echo ("MarketplaceId ==== "); //echo ($orderExtenData['MarketplaceId'] . "\n"); } if ($order->isSetBuyerName()) { //买家ID $orderUserInfoData['platformUsername'] = htmlentities($order->getBuyerName(), ENT_QUOTES); //echo ("platformUsername ==== "); //echo ($orderUserInfoData['platformUsername'] . "\n"); } if ($order->isSetBuyerEmail()) { //买家email $orderUserInfoData['email'] = $order->getBuyerEmail(); //echo ("email ==== "); //echo ($orderUserInfoData['email'] . "\n"); } if ($order->isSetShipmentServiceLevelCategory()) { $orderExtenData['ShipmentServiceLevelCategory'] = $order->getShipmentServiceLevelCategory(); //echo ("ShipmentServiceLevelCategory ==== "); //echo ($orderExtenData['ShipmentServiceLevelCategory'] . "\n"); } //$orderData['ebay_user'] = $user; $orderData['platformId'] = 11; //amazon的平台ID为11 $orderData['accountId'] = $accountId; //amazon的账号ID //echo ("accountId ==== "); //echo ($orderData['accountId'] . "\n"); $orderData['orderAddTime'] = time(); //添加到系统的时间 //echo ("orderAddTime ==== "); //echo ($orderData['orderAddTime'] . "\n"); $orderData['orderStatus'] = C('STATEPENDING'); //默认订单状态 $orderData['orderType'] = C('STATEPENDING_INITIAL'); //默认订单类型 $orderData = array('orderData' => $orderData, 'orderExtenData' => $orderExtenData, 'orderUserInfoData' => $orderUserInfoData); $tName = 'om_unshipped_order'; $where = "WHERE recordNumber='{$orderData['orderData']['recordNumber']}' AND platformId={$orderData['orderData']['platformId']} and is_delete ='0'"; $flagCountUnshipped = OmAvailableModel::getTNameCount($tName, $where); $tName = 'om_shipped_order'; $flagCountshipped = OmAvailableModel::getTNameCount($tName, $where); if (empty($flagCountUnshipped) && empty($flagCountshipped)) { //判断订单是否已经在系统2个订单表(未发货和已发货)中存在 //$orderData['ebay_ordersn'] = generateOrdersn(); $detailrequest = new MarketplaceWebServiceOrders_Model_ListOrderItemsRequest(); $detailrequest->setSellerId(MERCHANT_ID); $detailrequest->setAmazonOrderId($orderData['orderData']['recordNumber']); $orderDetailArr = self::act_invokeListOrderItems($service, $detailrequest); //var_dump($orderDetailArr); exit; for ($i = 0; $i < count($orderDetailArr); $i++) { $orderDetailArr[$i]['orderDetailData']['recordNumber'] = $orderData['orderData']['recordNumber']; } //print_r($orderDetailArr); if (!empty($orderDetailArr)) { $orderData['orderDetail'] = $orderDetailArr; $insertData = array(); //var_dump($obj_order_detail_data); echo "<br>"; $calcInfo = CommonModel::calcAddOrderWeight($orderDetailArr); //计算重量和包材 //var_dump($calcInfo); exit; $orderData['orderData']['ORcalcWeight'] = $calcInfo[0]; $orderData['orderData']['calcWeight'] = $calcInfo[0]; $orderData['orderData']['pmId'] = $calcInfo[1]; if ($orderData['orderData']['calcWeight'] != $totalweight) { $insertData['old_totalweight'] = $totalweight; $insertData['new_totalweight'] = $orderData['orderData']['calcWeight']; } if ($orderData['orderData']['pmId'] != $pmId) { $insertData['old_pmId'] = $pmId; $insertData['new_pmId'] = $orderData['orderData']['pmId']; } $newcarrier = get_carrier($orderData['orderData']['calcWeight'], $orderData['orderUserInfoData']['countryName'], $account, $orderData['orderUserInfoData']['currency']); $orderData['orderData']['transportId'] = $flip_transportList[$newcarrier]; $orderData['orderData']['ORtransportId'] = $flip_transportList[$newcarrier]; $rtn = OldsystemModel::orderErpInsertorder($orderData); //var_dump($rtn); if ($rtn['errcode'] == 200) { //var_dump($rtn); $rtn_data = $rtn['data']; $orderId = $rtn_data['orderId']; $message .= "<font color='green'>" . date("Y-m-d H:i:s") . " 插入老系统成功,订单编号 [{$orderId}] </font><br>"; $pmId = $rtn_data['pmId']; $totalweight = $rtn_data['totalweight']; $shipfee = $rtn_data['shipfee']; $carrier = $rtn_data['carrier']; $carrierId = $rtn_data['carrierId']; $status = $rtn_data['status']; $orderData['orderData']['id'] = $orderId; //赋予新系统订单编号@20140501 if (count($orderData['orderDetail']) > 1) { $orderData['orderData']['orderAttribute'] = 3; } else { if (isset($orderData['orderDetail'][0]['orderDetailData']['amount']) && $orderData['orderDetail'][0]['orderDetailData']['amount'] > 1) { $orderData['orderData']['orderAttribute'] = 2; } } /*$calcShippingInfo = CommonModel :: calcAddOrderShippingFee($orderData,1);//计算运费 //var_dump($calcShippingInfo); exit; //$insert_orderData['orderData']['calcShipping'] = $calcShippingInfo['fee']['fee']; $orderData['orderData']['channelId'] = $calcShippingInfo['fee']['channelId'];*/ $calcShippingInfo = TransAPIModel::trans_carriers_fix_get($orderData['orderData']['transportId'], $orderData['orderData']['calcWeight'], $orderData['orderUserInfoData']['countryName']); //计算运费 //var_dump($calcShippingInfo); $orderData['orderData']['calcShipping'] = $calcShippingInfo['fee']; //$orderData['orderData']['transportId'] = $calcShippingInfo['carrierId']; $orderData['orderData']['channelId'] = $calcShippingInfo['channelId']; $orderData['orderData']['ORchannelId'] = $calcShippingInfo['channelId']; if ($orderData['orderData']['calcShipping'] != $shipfee) { $insertData['old_shippfee'] = $shipfee; $insertData['new_shippfee'] = $orderData['orderData']['calcShipping']; } if ($orderData['orderData']['transportId'] != $carrierId) { $insertData['old_carrierId'] = $carrierId; $insertData['new_carrierId'] = $orderData['orderData']['transportId']; } if (!empty($insertData)) { $insertData['ebay_id'] = $orderId; $insertData['addtime'] = time(); //var_dump($insertData); OldsystemModel::insertTempSyncRecords($insertData); // 插入临时对比记录表 } $orderData = AutoModel::auto_contrast_intercept($orderData); //print_r($interceptInfo); exit; /*$orderData['orderData']['orderStatus'] = $interceptInfo['orderStatus']; $orderData['orderData']['orderType'] = $interceptInfo['orderType'];*/ //var_dump($orderData); exit; if (OrderAddModel::insertAllOrderRow($orderData)) { //echo 'insert success!' . "\n"; $message .= "<font color='green'>" . date("Y-m-d H:i:s") . ", 新增订单{$orderData['orderData']['recordNumber']}成功</font><br>"; } else { $message .= "<font color='red'>" . date("Y-m-d H:i:s") . ", 新增订单{$orderData['orderData']['recordNumber']}失败</font><br>"; //echo OrderAddModel :: $errMsg; } } } else { //echo "Amazon ID: ".$orderData['recordnumber']." 订单详情添加失败\n"; $message .= "<font color='red'>Amazon ID: " . $orderData['orderData']['recordNumber'] . " has no detail </font><br>"; } } else { $message .= "<font color='red'>Amazon ID: " . $orderData['orderData']['recordNumber'] . " had exist</font><br>"; } } } } } catch (MarketplaceWebServiceOrders_Exception $ex) { $message .= "Caught Exception: " . $ex->getMessage() . "<br>"; $message .= "Response Status Code: " . $ex->getStatusCode() . "<br>"; $message .= "Error Code: " . $ex->getErrorCode() . "<br>"; $message .= "Error Type: " . $ex->getErrorType() . "<br>"; $message .= "Request ID: " . $ex->getRequestId() . "<br>"; $message .= "XML: " . $ex->getXML() . "<br>"; } catch (Exception $e) { BaseModel::rollback(); BaseModel::autoCommit(); $message .= $e->getMessage() . "<br>"; } return $message; }
/** *功能:提供接口,给深圳ERP同步SPU报关相关信息 * */ public function act_getSpuHscodeTaxCount() { $tName = 'pc_spu_tax_hscode'; $where = "WHERE 1=1"; $spuHscodeCount = OmAvailableModel::getTNameCount($tName, $where); self::$errCode = 200; self::$errMsg = "成功"; return $spuHscodeCount; }
function act_updateSpuArchivePid() { $spu = $_POST['spu']; $pid = $_POST['pid']; $userId = $_SESSION['userId']; if (intval($userId) <= 0) { self::$errCode = '100'; self::$errMsg = "登陆超时,请重试"; return false; } if (empty($spu) || empty($pid)) { self::$errCode = '101'; self::$errMsg = "异常,错误!"; return false; } $tName = 'pc_spu_archive'; $select = 'categoryPath'; $where = "WHERE is_delete=0 AND spu='{$spu}'"; $spuList = OmAvailableModel::getTNameList($tName, $select, $where); if (empty($spuList)) { self::$errCode = '102'; self::$errMsg = "该SPU档案不存在"; return false; } if ($spuList[0]['categoryPath'] == $pid) { self::$errCode = '110'; self::$errMsg = "类别无修改"; return false; } $tName = 'pc_goods_category'; $where = "WHERE path='{$pid}' and is_delete=0"; $count = OmAvailableModel::getTNameCount($tName, $where); if (!$count) { self::$errCode = '103'; self::$errMsg = "所选类别不存在,请刷新重试!"; return false; } $where = "WHERE path like'{$pid}-%' and is_delete=0"; $count = OmAvailableModel::getTNameCount($tName, $where); if ($count) { self::$errCode = '104'; self::$errMsg = "产品档案只能建立在最小分类下,请选择最小分类"; return false; } try { BaseModel::begin(); $tName = 'pc_spu_archive'; $where = "WHERE spu='{$spu}'"; $dataTmpArr = array(); $dataTmpArr['categoryPath'] = $pid; OmAvailableModel::updateTNameRow2arr($tName, $dataTmpArr, $where); //更新SPU档案的类别 $tName = 'pc_archive_spu_property_value_relation'; $where = "WHERE spu='{$spu}'"; OmAvailableModel::deleteTNameRow($tName, $where); //物理删除该SPU产品档案选择属性记录 $tName = 'pc_archive_spu_input_value_relation'; $where = "WHERE spu='{$spu}'"; OmAvailableModel::deleteTNameRow($tName, $where); //物理删除SPU产品档案文本记录 $tName = 'pc_goods'; $where = "WHERE is_delete=0 AND spu='{$spu}'"; $dataTmpArr = array(); $dataTmpArr['goodsCategory'] = $pid; OmAvailableModel::updateTNameRow2arr($tName, $dataTmpArr, $where); //更新该SPU下所有SKU的类别 BaseModel::commit(); BaseModel::autoCommit(); OmAvailableModel::newData2ErpInterfOpen('pc.erp.updateGoodsCategoryBySpu', array('spu' => $spu, 'pid' => $pid), 'gw88'); $personName = getPersonNameById($userId); error_log(date('Y-m-d_H:i') . " {$personName} 将SPU:{$spu} 类别改为 {$pid} 原始类别为: {$spuList[0]['categoryPath']} \r\n", 3, WEB_PATH . "log/updateSpuCategoryLog.txt"); self::$errCode = 200; self::$errMsg = "修改成功"; return true; } catch (Exception $e) { BaseModel::rollback(); BaseModel::autoCommit(); self::$errCode = 404; self::$errMsg = '修改失败,原因为:' . $e->getMessage(); return false; } }
public function view_getSkuWeightAuditList() { $sku = isset($_GET['sku']) ? post_check($_GET['sku']) : ''; $status = isset($_GET['status']) ? post_check($_GET['status']) : ''; $addUserId = isset($_GET['addUserId']) ? post_check($_GET['addUserId']) : ''; $auditerId = isset($_GET['auditerId']) ? post_check($_GET['auditerId']) : ''; $timeSearchType = isset($_GET['timeSearchType']) ? post_check($_GET['timeSearchType']) : ''; $startdate = isset($_GET['startdate']) ? post_check($_GET['startdate']) : ''; $enddate = isset($_GET['enddate']) ? post_check($_GET['enddate']) : ''; $tName = 'pc_goods_weight_audit'; $select = '*'; $where = 'WHERE is_delete=0 '; if (!empty($sku)) { $where .= "AND sku='{$sku}' "; } if (intval($status) > 0) { $where .= "AND status='{$status}' "; } if (intval($addUserId) > 0) { $where .= "AND addUserId='{$addUserId}' "; } if (intval($auditerId) > 0) { $where .= "AND auditerId='{$auditerId}' "; } if (intval($timeSearchType) > 0) { if ($startdate != '') { $start = strtotime($startdate . ' 00:00:00'); if ($timeSearchType == 1) { $where .= "AND addTime>='{$start}' "; } elseif ($timeSearchType == 2) { $where .= "AND auditTime>='{$start}' "; } } if ($enddate != '') { $end = strtotime($enddate . ' 23:59:59'); if ($timeSearchType == 1) { $where .= "AND addTime<='{$end}' "; } elseif ($timeSearchType == 2) { $where .= "AND auditTime<='{$end}' "; } } } $total = OmAvailableModel::getTNameCount($tName, $where); $num = 100; //每页显示的个数 $page = new Page($total, $num, '', 'CN'); $where .= 'order by id desc '; $where .= $page->limit; $skuWeightAuditList = OmAvailableModel::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=goods&act=getGoodsList', 'title' => '产品信息'), array('url' => 'index.php?mod=goods&act=getSkuWeightAuditList', 'title' => 'SKU重量审核列表')); $this->smarty->assign('navlist', $navlist); $this->smarty->assign('onevar', 1); $this->smarty->assign('twovar', 110); $this->smarty->assign('show_page', $show_page); $this->smarty->assign('title', 'SKU重量审核列表'); $this->smarty->assign('skuWeightAuditList', empty($skuWeightAuditList) ? array() : $skuWeightAuditList); $this->smarty->display("skuWeightAuditList.htm"); }
public function view_updateSpuPrefixOn() { $id = $_GET['id']; $prefix = $_GET['prefix'] ? post_check(trim($_GET['prefix'])) : ''; $isSingSpu = $_GET['isSingSpu'] ? post_check(trim($_GET['isSingSpu'])) : ''; $companyId = $_GET['companyId'] ? post_check(trim($_GET['companyId'])) : ''; $isUse = $_GET['isUse'] ? post_check(trim($_GET['isUse'])) : ''; if (!preg_match("/^[A-Z]{2}\$/", $prefix)) { $status = "前缀必须是两个大写字母的组合"; header("Location:index.php?mod=spu&act=getSpuPrefixList&status={$status}"); exit; } if (intval($isSingSpu) != 1 && intval($isSingSpu) != 2) { $status = "单/组合料号有误"; header("Location:index.php?mod=spu&act=getSpuPrefixList&status={$status}"); exit; } $companyInfo = getCompanyNameById($companyId); if (empty($companyInfo)) { $status = "公司信息有误"; header("Location:index.php?mod=spu&act=getSpuPrefixList&status={$status}"); exit; } if (intval($isUse) == 0) { $status = "启动/禁用不能为空"; header("Location:index.php?mod=spu&act=getSpuPrefixList&status={$status}"); exit; } $tName = 'pc_auto_create_spu_prefix'; $select = '*'; $where = "WHERE id={$id}"; $spuPrefixList = OmAvailableModel::getTNameList($tName, $select, $where); if (empty($spuPrefixList)) { $status = "不存在该记录"; header("Location:index.php?mod=spu&act=getSpuPrefixList&status={$status}"); exit; } $where = "WHERE prefix='{$prefix}' and companyId='{$companyId}' and id<>'{$id}'"; $count = OmAvailableModel::getTNameCount($tName, $where); if ($count) { $status = "该公司下已经存在 {$prefix} 前缀"; header("Location:index.php?mod=spu&act=getSpuPrefixList&status={$status}"); exit; } $set = "SET prefix='{$prefix}',isSingSpu='{$isSingSpu}',companyId='{$companyId}',isUse='{$isUse}'"; $where = "WHERE id='{$id}'"; $affectRow = OmAvailableModel::updateTNameRow($tName, $set, $where); if (!$affectRow) { $status = "无数据修改"; header("Location:index.php?mod=spu&act=getSpuPrefixList&status={$status}"); exit; } $isSingSpuStr = 1 ? '单料号' : '虚拟料号'; $isUseStr = 1 ? '启用' : '禁用'; $status = "{$spuPrefixList[0]['prefix']} 修改为 {$prefix} 成功,{$isSingSpuStr} {$isUseStr}"; header("Location:index.php?mod=spu&act=getSpuPrefixList&status={$status}"); }