public function index()
{
$table = strim($GLOBALS['request']['table']);
$idfields = strim($GLOBALS['request']['idfields']);
$syncfield = strim($GLOBALS['request']['syncfield']);
$list = $GLOBALS['request']['list'];
//logutils::log_str(print_r($list,true));
$root = uploadRecord2($list, $table, $idfields, $syncfield);
//logutils::log_str(print_r($root,true));
//$sql = "select id,parent_id,code,type,store_range,store_dir, value as avalue, sort_order from ecs_shop_config";
//$root['list'] = $GLOBALS['db']->getAll($sql);
logutils::log_str(print_r($root, true));
output($root);
}
function uploadGoods($goods_id, $data_goods, $data_goods_article, $data_goods_attr, $data_goods_cat, $data_goods_gallery, $data_group_goods, $data_link_goods, $data_member_price, $data_volume_price, $data_products, $syncfield)
{
//$data_goods = str_iconv(ECS_CHARSET, EC_CHARSET, $data_goods);
//$data_goods_article = str_iconv(ECS_CHARSET, EC_CHARSET, $data_goods_article);
//$data_goods_attr = str_iconv(ECS_CHARSET, EC_CHARSET, $data_goods_attr);
//$data_goods_cat = str_iconv(ECS_CHARSET, EC_CHARSET, $data_goods_cat);
//$data_goods_gallery = str_iconv(ECS_CHARSET, EC_CHARSET, $data_goods_gallery);
//$data_group_goods = str_iconv(ECS_CHARSET, EC_CHARSET, $data_group_goods);
//$data_link_goods = str_iconv(ECS_CHARSET, EC_CHARSET, $data_link_goods);
//$data_member_price = str_iconv(ECS_CHARSET, EC_CHARSET, $data_member_price);
//logutils::clear_log();
//logutils::log_str( "uploadGoods Begin goods_id:".$goods_id );
//logutils::log_str( $data_goods );
$oldImgList = goodsImgList($goods_id);
//add by chenfq 20090829
$pack = uploadRecord2($data_goods, 'goods', 'goods_id', $syncfield);
//logutils::log_str( "uploadGoods_goods" );
$errmsg = '';
if ($pack['succ'] == false) {
foreach ($pack['items'] as $sync_item) {
if ($sync_item['succ'] == false) {
$errmsg = $errmsg . "," . $sync_item['errmsg'];
}
}
//logutils::log_obj( $pack );
//logutils::log_str( "1errmsg:".$errmsg );
return $errmsg;
}
if (!empty($data_goods_attr)) {
//logutils::log_str( "uploadGoods_goods_attr1" );
$sql = "delete from " . $GLOBALS['ecs']->table('goods_attr') . " where goods_id = {$goods_id}";
//logutils::log_str( $sql );
$GLOBALS['db']->query($sql);
//idfields = 'goods_id'
unset($pack);
//logutils::clear_log();
$pack = uploadRecord2($data_goods_attr, 'goods_attr', 'goods_attr_id', $syncfield);
//logutils::log_str( "uploadGoods_goods_attr2" );
if ($pack['succ'] == false) {
foreach ($pack['items'] as $sync_item) {
if ($sync_item['succ'] == false) {
$errmsg = $errmsg . "," . $sync_item['errmsg'];
}
}
//logutils::log_obj( $pack );
//logutils::log_str( "2errmsg:".$errmsg );
return $errmsg;
}
}
$sql = "delete from " . $GLOBALS['ecs']->table('goods_article') . " where goods_id = {$goods_id}";
//logutils::log_str( $sql );
$GLOBALS['db']->query($sql);
//idfields = 'goods_id,article_id'
if (!empty($data_goods_article)) {
unset($pack);
$pack = uploadRecord2($data_goods_article, 'goods_article', '', $syncfield);
//logutils::log_str( "uploadGoods_goods_article" );
if ($pack['succ'] == false) {
foreach ($pack['items'] as $sync_item) {
if ($sync_item['succ'] == false) {
$errmsg = $errmsg . "," . $sync_item['errmsg'];
}
}
//logutils::log_obj( $pack );
//logutils::log_str( "3errmsg:".$errmsg );
return $errmsg;
}
}
$sql = "delete from " . $GLOBALS['ecs']->table('goods_cat') . " where goods_id = {$goods_id}";
//logutils::log_str( $sql );
$GLOBALS['db']->query($sql);
//idfields = 'goods_id,cat_id'
if (!empty($data_goods_cat)) {
unset($pack);
$pack = uploadRecord2($data_goods_cat, 'goods_cat', '', $syncfield);
//logutils::log_str( "uploadGoods_goods_cat" );
if ($pack['succ'] == false) {
foreach ($pack['items'] as $sync_item) {
if ($sync_item['succ'] == false) {
$errmsg = $errmsg . "," . $sync_item['errmsg'];
}
}
//logutils::log_obj( $pack );
//logutils::log_str( "4errmsg:".$errmsg );
return $errmsg;
}
}
$sql = "delete from " . $GLOBALS['ecs']->table('goods_gallery') . " where goods_id = {$goods_id}";
//logutils::log_str( $sql );
$GLOBALS['db']->query($sql);
//idfields = 'img_id'
if (!empty($data_goods_gallery)) {
unset($pack);
$pack = uploadRecord2($data_goods_gallery, 'goods_gallery', '', $syncfield);
//logutils::log_str( "uploadGoods_goods" );
if ($pack['succ'] == false) {
foreach ($pack['items'] as $sync_item) {
if ($sync_item['succ'] == false) {
$errmsg = $errmsg . "," . $sync_item['errmsg'];
}
}
//logutils::log_obj( $pack );
//logutils::log_str( "5errmsg:".$errmsg );
return $errmsg;
}
}
$sql = "delete from " . $GLOBALS['ecs']->table('group_goods') . " where parent_id = {$goods_id}";
//logutils::log_str( $sql );
$GLOBALS['db']->query($sql);
//idfields = 'parent_id,goods_id'
if (!empty($data_group_goods)) {
unset($pack);
$pack = uploadRecord2($data_group_goods, 'group_goods', '', $syncfield);
//logutils::log_str( "uploadGoods_group_goods" );
if ($pack['succ'] == false) {
foreach ($pack['items'] as $sync_item) {
if ($sync_item['succ'] == false) {
$errmsg = $errmsg . "," . $sync_item['errmsg'];
}
}
//logutils::log_obj( $pack );
//logutils::log_str( "6errmsg:".$errmsg );
return $errmsg;
}
}
$sql = "delete from " . $GLOBALS['ecs']->table('link_goods') . " where goods_id = {$goods_id}";
//logutils::log_str( $sql );
$GLOBALS['db']->query($sql);
//idfields = 'goods_id,link_goods_id'
if (!empty($data_link_goods)) {
unset($pack);
$pack = uploadRecord2($data_link_goods, 'link_goods', '', $syncfield);
//logutils::log_str( "uploadGoods_link_goods" );
if ($pack['succ'] == false) {
foreach ($pack['items'] as $sync_item) {
if ($sync_item['succ'] == false) {
$errmsg = $errmsg . "," . $sync_item['errmsg'];
}
}
//logutils::log_obj( $pack );
//logutils::log_str( "7errmsg:".$errmsg );
return $errmsg;
}
}
$sql = "delete from " . $GLOBALS['ecs']->table('member_price') . " where goods_id = {$goods_id}";
//logutils::log_str( $sql );
$GLOBALS['db']->query($sql);
//idfields = 'price_id'
if (!empty($data_member_price)) {
unset($pack);
$pack = uploadRecord2($data_member_price, 'member_price', '', $syncfield);
//logutils::log_str( "uploadGoods_member_price" );
if ($pack['succ'] == false) {
foreach ($pack['items'] as $sync_item) {
if ($sync_item['succ'] == false) {
$errmsg = $errmsg . "," . $sync_item['errmsg'];
}
}
//logutils::log_obj( $pack );
//logutils::log_str( "8errmsg:".$errmsg );
return $errmsg;
}
}
if (!preg_match('/^(v2.5.0|v2.5.1|v2.6.0|v2.6.1)$/i', VERSION) && $data_volume_price != '-1') {
$sql = "delete from " . $GLOBALS['ecs']->table('volume_price') . " where goods_id = {$goods_id}";
//logutils::log_str( $sql );
$GLOBALS['db']->query($sql);
//idfields = 'price_id'
if (!empty($data_volume_price)) {
unset($pack);
$pack = uploadRecord2($data_volume_price, 'volume_price', '', $syncfield);
//logutils::log_str( "uploadGoods_member_price" );
if ($pack['succ'] == false) {
foreach ($pack['items'] as $sync_item) {
if ($sync_item['succ'] == false) {
$errmsg = $errmsg . "," . $sync_item['errmsg'];
}
}
//logutils::log_obj( $pack );
//logutils::log_str( "8errmsg:".$errmsg );
return $errmsg;
}
}
}
if (!preg_match('/^(v2.5.0|v2.5.1|v2.6.0|v2.6.1|v2.6.2|v2.7.0|v2.7.1)$/i', VERSION) && $data_products != '-1') {
$sql = "delete from " . $GLOBALS['ecs']->table('products') . " where goods_id = {$goods_id}";
$GLOBALS['db']->query($sql);
if (!empty($data_products)) {
unset($pack);
//logutils::clear_log();
$pack = uploadRecord2($data_products, 'products', 'product_id', $syncfield);
//logutils::log_str( "uploadGoods_goods_attr2" );
if ($pack['succ'] == false) {
foreach ($pack['items'] as $sync_item) {
if ($sync_item['succ'] == false) {
$errmsg = $errmsg . "," . $sync_item['errmsg'];
}
}
//logutils::log_obj( $pack );
//logutils::log_str( "2errmsg:".$errmsg );
return $errmsg;
}
}
}
//logutils::log_str( "uploadGoods End goods_id:".$goods_id );
$newImgList = goodsImgList($goods_id);
//add by chenfq 20090829
$total = count($oldImgList);
//logutils::log_obj( $oldImgList );
//logutils::log_obj( $newImgList );
for ($i = 0; $i < $total; $i++) {
if (!in_array($oldImgList[$i], $newImgList)) {
//$file = ROOT_PATH . $oldImgList[$i];
//$file = str_replace( "\\", "/", $file );
$file = '../' . $oldImgList[$i];
if (file_exists($file)) {
//logutils::log_str( "delete:".$file );
@unlink($file);
}
}
}
//clear_cache_files();
return 'true';
}
