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'; }