public static function add_item_auto()
{
$ret = array('done' => 0, 'fail' => 0, 'pass' => 0);
global $db;
$stmt = $db->stmt_init();
$search = "SELECT id,merchant,code,deal_type,start_on,end_on,name,site_wide,url FROM " . DB_TABLE_PREFIX . "popshop_coupon WHERE couponID = 0";
$stmt->prepare($search);
$stmt->execute();
$stmt->bind_result($id, $merchant, $code, $deal_type, $start_on, $end_on, $name, $site_wide, $url);
$popshop_coupons = array();
while ($stmt->fetch()) {
$popshop_coupons[] = array('id' => $id, 'merchant' => $merchant, 'code' => $code, 'deal_type' => $deal_type, 'start_on' => $start_on, 'end_on' => $end_on, 'name' => $name, 'site_wide' => $site_wide, 'url' => $url);
}
if (count($popshop_coupons) > 0) {
//do import
$stores = array();
$deal_types = null;
foreach ($popshop_coupons as $popshop_coupon) {
if (!isset($stores[$popshop_coupon['merchant']])) {
$search = "SELECT id,category,image,popular,visible FROM " . DB_TABLE_PREFIX . "stores WHERE popshopID = " . $popshop_coupon['merchant'];
$stmt->prepare($search);
$stmt->execute();
$stmt->bind_result($id, $category, $image, $popular, $visible);
if ($stmt->fetch()) {
$stores[$popshop_coupon['merchant']] = array('id' => $id, 'category' => $category, 'image' => $image, 'popular' => $popular, 'visible' => $visible);
} else {
$stores[$popshop_coupon['merchant']] = NULL;
}
}
if (!$stores[$popshop_coupon['merchant']]) {
$ret['pass']++;
continue;
}
$stmt->prepare("INSERT INTO " . DB_TABLE_PREFIX . "coupons (popshopID, store, category, popular, title, link, tags, code, visible, start, expiration, lastupdate, date) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW(), NOW())");
$storeid = $stores[$popshop_coupon['merchant']]['id'];
$category = $stores[$popshop_coupon['merchant']]['category'];
$popular = $stores[$popshop_coupon['merchant']]['popular'];
$tags = '';
if ($popshop_coupon['deal_type'] != '') {
if (!$deal_types) {
$deal_types = actions::listDealTypes();
}
$arrs = explode(',', $popshop_coupon['deal_type']);
foreach ($arrs as $arr) {
if (isset($deal_types[intval($arr)])) {
if ($tags == '') {
$tags = $deal_types[intval($arr)];
} else {
$tags .= ',' . $deal_types[intval($arr)];
}
}
}
}
if ($popshop_coupon['site_wide']) {
if ($tags == '') {
$tags = 'Site-Wide';
} else {
$tags .= ',Site-Wide';
}
}
$publish = $stores[$popshop_coupon['merchant']]['visible'];
$stmt->bind_param("iiiissssiss", $popshop_coupon['id'], $storeid, $category, $popular, $popshop_coupon['name'], $popshop_coupon['url'], $tags, $popshop_coupon['code'], $publish, $popshop_coupon['start_on'], $popshop_coupon['end_on']);
$execute = $stmt->execute();
if ($execute) {
$stmt->prepare("SELECT LAST_INSERT_ID() FROM " . DB_TABLE_PREFIX . "stores");
$stmt->execute();
$stmt->bind_result($id);
$stmt->fetch();
$stmt->prepare("UPDATE popshop_coupon SET couponID = ? WHERE id = ?");
$stmt->bind_param("ii", $id, $popshop_coupon['id']);
$execute = $stmt->execute();
$ret['done']++;
} else {
$ret['fail']++;
}
}
}
return $ret;
}
