public static function addProvider(Provider $provider)
{
$result = DBClass::execute('INSERT INTO AWS_GCP (Provider_Name,Description, Provider_Image,Service_Model,Deployment_Model,Server_Location,Criteria, Subscription_Method,Suitability,Industry,cloud_id) VALUES (?, ?,?,?,?,?,?,?,?,?,?)', array($provider->name, $provider->description, $provider->image, $provider->service_model, $provider->deploy_model, $provider->location, $provider->criteria, $provider->sub_method, $provider->suitability, $provider->industry, $provider->cloud_id));
//if (count($provider->services) > 0) {
//echo $provider->services;
foreach ($provider->services as $service) {
self::addService($service, $provider);
//echo $result;
}
//}
//echo $result;
return $result;
}
##############电子类产品SKU（指定国家的订单直接走香港小包)#############START
//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']);
public static function addWidget(Widget $widget)
{
$widget_data = json_encode($widget->widget_data);
return DBClass::execute('INSERT INTO uf_widgets (wid, stitle, fSid, wtitle, num_cards, link_text, purl, sharer, textnotes, data) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)', array($widget->wid, $widget->stitle, $widget->fSid, $widget->wtitle, $widget->num_cards, $widget->link_text, $widget->purl, $widget->sharer, $widget->textnotes, $widget_data));
}
<?php
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>
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>';
<?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 = "天天快递";
header("Content-type:text/html;charset=utf-8");
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;
$detail_id = $_POST['detail_id'];
$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);
[ 'client' => 'awesome' ], // ← document
[ '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);
public function deleteOneByName($nam, $val)
{
$sql = 'DELETE FROM ' . static::$table . ' WHERE ' . $nam . '=?';
$db = new DBClass();
return $db->execute($sql, array($val));
}
$start = "2013-08-20 02:00:00";
/**/
$account = "*****@*****.**";
//$account = "*****@*****.**";
$AWS_ACCESS_KEY_ID = "AKIAJWV3E4ZQGNEQH2FQ";
$AWS_SECRET_ACCESS_KEY = "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";
$MERCHANT_ID = "A11S9UEFFS8HNW";
$MARKETPLACE_ID = "ATVPDKIKX0DER";
$serviceUrl = 'https://mws.amazonservices.com/Orders/2011-01-01';
/**************************************/
$account = $_REQUEST['account'];
if (empty($account)) {
die("请选择账号");
}
$ss = "select * from ebay_account where ebay_account ='{$account}' and ebay_user ='******' ";
$ss = $dbcon->execute($ss);
$ss = $dbcon->getResultArray($ss);
$AWS_ACCESS_KEY_ID = $ss[0]['AWS_ACCESS_KEY_ID'];
$AWS_SECRET_ACCESS_KEY = $ss[0]['AWS_SECRET_ACCESS_KEY'];
$MERCHANT_ID = $ss[0]['MERCHANT_ID'];
$MARKETPLACE_ID = $ss[0]['MARKETPLACE_ID'];
$serviceUrl = $ss[0]['serviceUrl'] . '/Orders/2011-01-01';
/**************************************/
define('AWS_ACCESS_KEY_ID', $AWS_ACCESS_KEY_ID);
define('AWS_SECRET_ACCESS_KEY', $AWS_SECRET_ACCESS_KEY);
define('MERCHANT_ID', $MERCHANT_ID);
define('MARKETPLACE_ID', $MARKETPLACE_ID);
set_include_path(get_include_path() . PATH_SEPARATOR . '../../.');
function __autoload($className)
{
$filePath = str_replace('_', DIRECTORY_SEPARATOR, $className) . '.php';
