$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'] . '"';
}
