$goods_value = array('goods_name' => '', 'goods_class' => $goods_class, 'shop_class' => 0, 'new_level' => 0, 'province' => $shop_province, 'city' => $shop_city, 'sell_type' => '"b"', 'shop_price' => 0, 'add_price' => 0, 'goods_number' => 0, 'die_day' => 14, 'load_type' => 1, 'post_express' => $post_express, 'ems' => $ems, 'express' => $express, 'pay_type' => '', 'allow_alipay' => '', 'invoice' => 0, 'repair' => 0, 'resend' => 1, 'is_store' => 0, 'window' => 0, 'add_time' => '"1980-1-1 0:00:00"', 'story' => '', 'goods_desc' => '', 'goods_img' => '', 'goods_attr' => '', 'group_buy' => '', 'group_buy_num' => '', 'template' => 0, 'discount' => 0, 'modify_time' => '"2011-5-1 0:00:00"', 'upload_status' => 100, 'img_status' => 1, 'img_status' => '', 'rebate_proportion' => 0, 'new_goods_img' => '', 'video' => '', 'marketing_property_mix' => '', 'user_input_ID_numbers' => '', 'input_user_name_value' => '', 'sellers_code' => '', 'another_of_marketing_property' => '', 'charge_type' => '0', 'treasure_number' => '', 'ID_number' => ''); $content = implode("\t", $_LANG['taobao46']) . "\n"; while ($row = $db->fetchRow($res)) { /* 压缩图片 */ if (!empty($row['goods_img']) && is_file(ROOT_PATH . $row['goods_img'])) { $row['new_goods_img'] = preg_replace("/(^images\\/)+(.*)(.gif|.jpg|.jpeg|.png)\$/", "\${2}.tbi", $row['goods_img']); @copy(ROOT_PATH . $row['goods_img'], ROOT_PATH . "images\\/" . $row['new_goods_img']); if (is_file(ROOT_PATH . "images\\/" . $row['new_goods_img'])) { $zip->add_file(file_get_contents(ROOT_PATH . "images\\/" . $row['new_goods_img']), $row['new_goods_img']); unlink(ROOT_PATH . "images\\/" . $row['new_goods_img']); } } $goods_value['goods_name'] = '"' . $row['goods_name'] . '"'; $goods_value['shop_price'] = $row['shop_price']; $goods_value['goods_number'] = $row['goods_number']; $goods_value['goods_desc'] = replace_special_char($row['goods_desc']); if (!empty($row['new_goods_img'])) { $row['new_goods_img'] = str_ireplace('/', '\\', $row['new_goods_img'], $row['new_goods_img']); $row['new_goods_img'] = str_ireplace('.tbi', '', $row['new_goods_img'], $row['new_goods_img']); $goods_value['new_goods_img'] = '"' . $row['new_goods_img'] . ':0:0:|;' . '"'; } $content .= implode("\t", $goods_value) . "\n"; } if (EC_CHARSET != 'utf-8') { $content = ecs_iconv(EC_CHARSET, 'utf-8', $content); } $zip->add_file("��" . utf82u2($content), 'goods_list.csv'); header("Content-Disposition: attachment; filename=goods_list.zip"); header("Content-Type: application/unknown"); die($zip->file()); }
$goods_field_value[$field] = '""'; } } $content = '"' . implode('","', $goods_field_name) . "\"\n"; while ($row = $db->fetchRow($res)) { $goods_value = $goods_field_value; isset($goods_value['goods_name']) && ($goods_value['goods_name'] = '"' . $row['goods_name'] . '"'); isset($goods_value['goods_sn']) && ($goods_value['goods_sn'] = '"' . $row['goods_sn'] . '"'); isset($goods_value['brand_name']) && ($goods_value['brand_name'] = $row['brandname']); isset($goods_value['market_price']) && ($goods_value['market_price'] = $row['market_price']); isset($goods_value['shop_price']) && ($goods_value['shop_price'] = $row['shop_price']); isset($goods_value['integral']) && ($goods_value['integral'] = $row['integral']); isset($goods_value['original_img']) && ($goods_value['original_img'] = '"' . $row['original_img'] . '"'); isset($goods_value['keywords']) && ($goods_value['keywords'] = '"' . $row['keywords'] . '"'); isset($goods_value['goods_brief']) && ($goods_value['goods_brief'] = '"' . replace_special_char($row['goods_brief']) . '"'); isset($goods_value['goods_desc']) && ($goods_value['goods_desc'] = '"' . replace_special_char($row['goods_desc']) . '"'); isset($goods_value['goods_weight']) && ($goods_value['goods_weight'] = $row['goods_weight']); isset($goods_value['goods_number']) && ($goods_value['goods_number'] = $row['goods_number']); isset($goods_value['warn_number']) && ($goods_value['warn_number'] = $row['warn_number']); isset($goods_value['is_best']) && ($goods_value['is_best'] = $row['is_best']); isset($goods_value['is_new']) && ($goods_value['is_new'] = $row['is_new']); isset($goods_value['is_hot']) && ($goods_value['is_hot'] = $row['is_hot']); isset($goods_value['is_on_sale']) && ($goods_value['is_on_sale'] = $row['is_on_sale']); isset($goods_value['is_alone_sale']) && ($goods_value['is_alone_sale'] = $row['is_alone_sale']); isset($goods_value['is_real']) && ($goods_value['is_real'] = $row['is_real']); $sql = "SELECT `attr_id`, `attr_value` FROM " . $ecs->table('goods_attr') . " WHERE `goods_id` = '" . $row['goods_id'] . "'"; $query = $db->query($sql); while ($attr = $db->fetchRow($query)) { if (in_array($attr['attr_id'], $goods_fields)) { $goods_value[$attr['attr_id']] = '"' . $attr['attr_value'] . '"'; }
$goods_field_value[$field] = '""'; } } $content = '"' . implode('","', $goods_field_name) . "\"\n"; while ($row = $db->fetchRow($res)) { $goods_value = $goods_field_value; isset($goods_value['goods_name']) && ($goods_value['goods_name'] = '"' . $row['goods_name'] . '"'); isset($goods_value['goods_sn']) && ($goods_value['goods_sn'] = '"' . $row['goods_sn'] . '"'); isset($goods_value['brand_name']) && ($goods_value['brand_name'] = $row['brandname']); isset($goods_value['market_price']) && ($goods_value['market_price'] = $row['market_price']); isset($goods_value['shop_price']) && ($goods_value['shop_price'] = $row['shop_price']); isset($goods_value['integral']) && ($goods_value['integral'] = $row['integral']); isset($goods_value['original_img']) && ($goods_value['original_img'] = $row['original_img']); isset($goods_value['keywords']) && ($goods_value['keywords'] = '"' . $row['keywords'] . '"'); isset($goods_value['goods_brief']) && ($goods_value['goods_brief'] = replace_special_char($row['goods_brief'])); isset($goods_value['goods_desc']) && ($goods_value['goods_desc'] = replace_special_char($row['goods_desc'])); isset($goods_value['goods_weight']) && ($goods_value['goods_weight'] = $row['goods_weight']); isset($goods_value['goods_number']) && ($goods_value['goods_number'] = $row['goods_number']); isset($goods_value['warn_number']) && ($goods_value['warn_number'] = $row['warn_number']); isset($goods_value['is_best']) && ($goods_value['is_best'] = $row['is_best']); isset($goods_value['is_new']) && ($goods_value['is_new'] = $row['is_new']); isset($goods_value['is_hot']) && ($goods_value['is_hot'] = $row['is_hot']); isset($goods_value['is_on_sale']) && ($goods_value['is_on_sale'] = $row['is_on_sale']); isset($goods_value['is_alone_sale']) && ($goods_value['is_alone_sale'] = $row['is_alone_sale']); isset($goods_value['is_real']) && ($goods_value['is_real'] = $row['is_real']); $sql = "SELECT `attr_id`, `attr_value` FROM " . $ecs->table('goods_attr') . " WHERE `goods_id` = '" . $row['goods_id'] . "'"; $query = $db->query($sql); while ($attr = $db->fetchRow($query)) { if (in_array($attr['attr_id'], $goods_fields)) { $goods_value[$attr['attr_id']] = '"' . $attr['attr_value'] . '"'; }