set_time_limit(0);
ini_set('memory_limit', '800M');
if (strpos($_SERVER['HTTP_HOST'], '113')) {
include "../../include/dbconnect.php";
$agency_host = "http://113.108.97.88:90/glv3/";
} else {
include "db_connect.php";
$agency_host = "http://" . $_SERVER['HTTP_HOST'] . "/";
}
$dbcon = new DBClass();
$defaultstoreid = 12;
$user = "******";
$ss = "select ebay_account from ebay_account where ebay_account like '%@%' and ebay_user ='******' ";
$ss = $dbcon->execute($ss);
$ss = $dbcon->getResultArray($ss);
$options_str = "";
//$agency_host = "http://113.108.97.88:90/glv3/";
foreach ($ss as $key => $val) {
$options_str .= '<option value="' . $val['ebay_account'] . '">' . $val['ebay_account'] . '</option>';
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Amazon订单同步</title>
<script language="javascript" type="text/javascript" src="../../My97DatePicker/WdatePicker.js"></script>
</head>
//add by Herman.Xi 2012-10-26
$__elecsku_countrycn_array = array('阿尔巴尼亚','奥地利','比利时','保加利亚','白俄罗斯','捷克','爱沙尼亚','希腊','克罗地亚','匈牙利','爱尔兰','冰岛','立陶宛','卢森堡','拉脱维亚','摩尔多瓦','马耳他','葡萄牙','罗马尼亚','塞尔维亚','瑞典','斯洛文尼亚','斯洛伐克');
$__liquid_items_elecsku=array('7769_1','7769_2','7769_3','166','869','312','24','298','329','1039','1378','4243','4276','947','361','269','819','1114','1406','1897','1992','6342','1407','1992','4124','4766','4878','5884','5885','5886','734','1602','1603','1631','1632','1634','2351','3620_B','50','195','207','TK0014','TK0015','TK0016','TK0017','TK0018','TK0023','TK0025','TK0026','TK0049','TK0050','TK0051','TK0052','TK0053','TK0054','TK0055','TK0080','TK0087','TK0091','TK0092','TK0131','TK0132','TK0133','TK0134','TK0135','TK0136','TK0137','TK0138','TK0139','TK0140','TK0151','TK0152','TK0160','TK0163','TK0164','TK0165','TK0183','TK0187','TK0189','TK0193','TK0201','TK0213','TK0215','TK0217','TK0224','TK0230','TK0231','TK0233','TK0239','TK0244','TK0245','TK0246','TK0269');
##############电子类产品SKU(指定国家的订单直接走香港小包)#############END*/
///////////////some global configuration//////////////////
include_once SCRIPT_ROOT . 'config_row/config_database_row_scripts.php';
include_once SCRIPT_ROOT . "dbconnect.php";
include_once SCRIPT_ROOT . "xmlhandle.php";
include_once SCRIPT_ROOT . "cls_page.php";
//include_once "ebay_order_cron_func.php";
//include_once "shipping_calc_fun.php";
$dbcon = new DBClass();
$sql = "select category,skulist,original_transport,current_transport,country from ebay_adjust_transport ";
//特殊料号数据库
$result = $dbcon->execute($sql);
$ebay_adjust_transport = $dbcon->getResultArray($result);
$dbcon->free_result($result);
$__liquid_items_postbyhkpost = explode(",", $ebay_adjust_transport[0]['skulist']);
//液体产品
$__liquid_items_postbyfedex = explode(",", $ebay_adjust_transport[1]['skulist']);
//贵重物品走联邦
$__liquid_items_cptohkpost = explode(",", $ebay_adjust_transport[2]['skulist']);
//指甲油转香港小包
$__liquid_items_elecsku = explode(",", $ebay_adjust_transport[3]['skulist']);
//电子类产品走香港小包
$__elecsku_countrycn_array = explode(",", $ebay_adjust_transport[3]['country']);
//电子类产品指定国家
$__liquid_items_fenmocsku = explode(",", $ebay_adjust_transport[4]['skulist']);
//粉末状SKU
$__liquid_items_BuiltinBattery = explode(",", $ebay_adjust_transport[5]['skulist']);
//内置电池类产品
<?php
$mctime = time();
echo "脚本开始时间" . date('Y-m-d H:i:s', $mctime) . "\n";
include "include/dbconnect.php";
$dbcon = new DBClass();
include "include/function_general.php";
include "include/function_purchase.php";
$url = 'http://idc.gw.open.valsun.cn/router/rest?';
//idc开放系统入口地址
$token = 'a6c94667ab1820b43c0b8a559b4bc909';
//用户finejo token
error_reporting(-1);
$carriersql = "SELECT * FROM ebay_carrier ";
$carriersql = $dbcon->execute($carriersql);
$carrierList = $dbcon->getResultArray($carriersql);
$carrierArr = array();
$transportList = getCarrierListById();
$flip_transportList = array_flip($transportList);
foreach ($carrierList as $value) {
$carrier = $value['name'];
if ($carrier == '海运运输') {
continue;
}
//echo $carrier; echo "\n";
if ($carrier == "英国专线挂号") {
$carrier = "英国专线挂号";
$id = 63;
} else {
if ($carrier == "天天快递") {
$carrier = "天天快递";
set_time_limit(0);
header("Content-type:text/html;charset=utf-8");
include "db_connect.php";
$dbcon = new DBClass();
/**
$ss = "show tables;";
$ss = $dbcon->execute($ss);
$ss = $dbcon->getResultArray($ss);
var_dump($ss);exit;
/**/
$content = file_get_contents("ebay_order.sql");
$preg = "/;;;ordersn:([^\\s]+)\\s/i";
preg_match_all($preg, $content, $arr);
foreach ($arr[1] as $key => $val) {
$ordersn = trim($val);
$sql = "select ebay_account from ebay_order where ebay_ordersn='{$ordersn}' and ebay_account='*****@*****.**' limit 1";
$sql = $dbcon->execute($sql);
$sql = $dbcon->getResultArray($sql);
if (!empty($sql)) {
$account = $sql[0]['ebay_account'];
if (!empty($account) && $account == '*****@*****.**') {
$update_sql = "update ebay_order set ebay_account='*****@*****.**' where ebay_ordersn='{$ordersn}' and ebay_account='*****@*****.**' limit 1";
//echo $update_sql."<br>";
$dbcon->execute($update_sql);
echo '$ordersn:' . $ordersn . "<br>";
//exit;
}
}
}
echo 'finish<pre>';
echo '<meta http-equiv="Content-Type" content="text/html; charset=utf-8"> ';
include "db_connect.php";
$dbcon = new DBClass();
$defaultstoreid = 12;
$user = "******";
$account = "*****@*****.**";
/**************************************/
$account = $_REQUEST['account'];
$update_addr = $_REQUEST['update_addr'];
if (empty($account)) {
die("Please select amazon account.");
}
if (!empty($update_addr)) {
$sql = "select ebay_id,ebay_street,ebay_street1,ebay_city,ebay_state from ebay_order where ebay_status=822 and ebay_account='{$account}' and ( ebay_countryname='France' or ebay_countryname='Germany' )";
$sql = $dbcon->execute($sql);
$sql = $dbcon->getResultArray($sql);
if (!empty($sql)) {
foreach ($sql as $key => $val) {
$ebay_street = $val['ebay_street'];
$ebay_street1 = $val['ebay_street1'];
$ebay_city = $val['ebay_city'];
$ebay_state = $val['ebay_state'];
$ebay_id = $val['ebay_id'];
$is_update = false;
if (empty($ebay_street) && !empty($ebay_street1)) {
$ebay_street = $ebay_street1;
$is_update = true;
}
if (!empty($ebay_street) && empty($ebay_street1)) {
$ebay_street1 = $ebay_street;
$is_update = true;
$sku = $_POST['sku'];
$type = $_POST['type'];
$check_status = $_POST['check_status'];
$notecontent = isset($_POST['pcontent']) ? $_POST['pcontent'] : '';
//强制拦截时输入拦截理由 add by guanyongjun 2013-09-17
if ($check_status == '2') {
$notecontent = ",notecontent='{$notecontent}'";
}
//审核检查 add by rdh 2013-11-04
if ($check_status == '1') {
$realStore = 0;
$needSend = 0;
$orderSkuNum = 0;
$sql = "select goods_count from ebay_onhandle where goods_sn='{$sku}' and store_id='76' ";
$sql = $dbcon->execute($sql);
$sql = $dbcon->getResultArray($sql);
$realStore = $sql[0]['goods_count'];
//实际库存
$needSend = getpartsaleandnosendall($sku, '76');
//待发货
$sql2 = "select ebay_amount from ebay_orderdetail where ebay_id='{$detail_id}' ";
$sql2 = $dbcon->execute($sql2);
$sql2 = $dbcon->getResultArray($sql2);
$orderSkuNum = $sql2[0]['ebay_amount'];
//订单数量
$diffNum = $realStore - $needSend - $orderSkuNum;
if ($diffNum < 0) {
$res['code'] = '002';
$res['data']['msg'] = "该料号的实际库存{$realStore} - 待发货{$needSend} 小于 订购数量{$orderSkuNum} 审核不通过!";
echo json_encode($res);
return $res;
[ 'w' => 0 ] // ← don't acknowledge writes for this insert
);
*/
$dbcon = new DBClass();
$MemcacheObj = new Memcache();
/*
$sql = "SELECT * FROM `ebay_ordergrossrate` WHERE `is_effectiveorder` = 1 AND `is_delete` = 0 AND `order_scantime` BETWEEN '1404748800' AND '1404835199' ORDER BY `order_scantime` DESC limit 50,50000";
$sql = $dbcon->execute($sql);
$skuinfo = $dbcon->getResultArray($sql);
foreach($skuinfo as $item){
$m->bigdata->ebay->insert($item);
}
*/
$sql = "SELECT ebay_account,ebay_platform FROM ebay_account WHERE ebay_platform!='' ORDER BY ebay_platform ASC";
$sql = $dbcon->execute($sql);
$eaccounts = $dbcon->getResultArray($sql);
$accounts = array();
$cn2enarr = array('ebay平台' => 'ebay', '亚马逊' => 'amazon', '出口通' => 'chukoutong', '国内销售部' => 'guonei', '天猫哲果' => 'zegoo', '天猫芬哲' => 'fenjo', '海外仓' => 'oversea', '线下结算客户' => 'offline');
foreach ($eaccounts as $eaccount) {
$enAccount = $cn2enarr[$eaccount['ebay_platform']];
if (isset($enAccount)) {
$accounts[$enAccount][] = $eaccount['ebay_account'];
} else {
$accounts[$eaccount['ebay_platform']][] = $eaccount['ebay_account'];
}
}
$sql = "SELECT count(*) as total FROM `ebay_goods` ";
$sql = $dbcon->execute($sql);
$number = $dbcon->fetch_one($sql);
$length = ceil($number['total'] / 1000);
for ($i = 0; $i < $length; $i++) {
$dbcon = new DBClass();
/*
$sql = "SELECT * FROM `ebay_ordergrossrate` WHERE `is_effectiveorder` = 1 AND `is_delete` = 0 AND `order_scantime` BETWEEN '1404748800' AND '1404835199' ORDER BY `order_scantime` DESC limit 50,50000";
$sql = $dbcon->execute($sql);
$skuinfo = $dbcon->getResultArray($sql);
foreach($skuinfo as $item){
$m->bigdata->ebay->insert($item);
}
*/
$startTimeStamp = 0;
$endTimeStamp = 0;
$starttime = time();
$currentTime = date('[ Y-m-d H:i:s ]');
$sql = "select model,price from ebay_packingmaterial";
$sql = $dbcon->execute($sql);
$packinglists = $dbcon->getResultArray($sql);
foreach ($packinglists as $packinglist) {
$packings[$packinglist['model']] = $packinglist['price'];
}
unset($packinglists);
//获取所有平台账号信息
$sql = "SELECT ebay_account,ebay_platform FROM ebay_account WHERE ebay_platform!='' ORDER BY ebay_platform ASC";
$sql = $dbcon->execute($sql);
$eaccounts = $dbcon->getResultArray($sql);
$accounts = array();
$cn2enarr = array('ebay平台' => 'ebay', '亚马逊' => 'amazon', '出口通' => 'chukoutong', '国内销售部' => 'guonei', '天猫哲果' => 'zegoo', '天猫芬哲' => 'fenjo', '海外仓' => 'oversea', '线下结算客户' => 'offline');
foreach ($eaccounts as $eaccount) {
$enAccount = $cn2enarr[$eaccount['ebay_platform']];
if (isset($enAccount)) {
$accounts[$enAccount][] = $eaccount['ebay_account'];
} else {
define('EOL', PHP_SAPI == 'cli' ? PHP_EOL : '<br />');
date_default_timezone_set('Europe/London');
/** Include PHPExcel */
require_once dirname(__FILE__) . '/excel/Classes/PHPExcel.php';
$user = '******';
$departments = array(1 => '采购部', 2 => '芬哲', 3 => '哲果');
$fielnames = array(1 => 'sw', 2 => 'fz', 3 => 'zg');
require_once '/data/scripts/ebay_order_cron_job/script_root_path.php';
require_once SCRIPT_ROOT . 'function_purchase.php';
require_once SCRIPT_ROOT . "script_root_path.php";
require_once SCRIPT_ROOT . "ebay_order_cron_config.php";
date_default_timezone_set("Asia/Chongqing");
$dbcon = new DBClass();
$sql = "SELECT ebay_account,ebay_platform FROM ebay_account WHERE ebay_platform!='' ORDER BY ebay_platform ASC";
$sql = $dbcon->execute($sql);
$eaccounts = $dbcon->getResultArray($sql);
$accounts = array();
foreach ($eaccounts as $eaccount) {
$accounts[$eaccount['ebay_platform']][] = $eaccount['ebay_account'];
}
// Create new PHPExcel object
echo date('H:i:s'), " Create new PHPExcel object", EOL;
$objPHPExcel = new PHPExcel();
// Set document properties
echo date('H:i:s'), " Set document properties", EOL;
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")->setLastModifiedBy("Maarten Balliauw")->setTitle("Office 2007 XLSX Test Document")->setSubject("Office 2007 XLSX Test Document")->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")->setKeywords("office 2007 openxml php")->setCategory("Test result file");
// Add some data, we will use printing features
echo date('H:i:s'), " Add some data", EOL;
$objPHPExcel->getActiveSheet()->setCellValue('A1', "主料号");
$objPHPExcel->getActiveSheet()->setCellValue('B1', "料号");
$objPHPExcel->getActiveSheet()->setCellValue('C1', "产品描述");
