public function calculateForeverListingSchedule()
{
echo date("H") . "\n";
if (in_array(date("H"), array('02', '12', '17', '18'))) {
require_once __DOCROOT__ . '/module/template.php';
$today = date("Y-m-d");
//$Site = $argv[2];
switch (date("H")) {
case "02":
$day = date("Y-m-d", time() + 24 * 60 * 60);
$Site = "Australia";
$sql_1 = "select Id,accountId,ForeverListingTime,ForeverListingChinaTime from template where status = 7 and Site = 'Australia'";
break;
case "12":
$day = date("Y-m-d", time() + 24 * 60 * 60);
$Site = "US";
$sql_1 = "select Id,accountId,ForeverListingTime,ForeverListingChinaTime from template where status = 7 and (Site = 'US' or Site = 'eBayMotors')";
break;
case "17":
$day = date("Y-m-d", time() + 24 * 60 * 60);
$Site = "UK";
$sql_1 = "select Id,accountId,ForeverListingTime,ForeverListingChinaTime from template where status = 7 and Site = 'UK'";
break;
case "18":
$day = date("Y-m-d", time() + 24 * 60 * 60);
$Site = "Germany";
$sql_1 = "select Id,accountId,ForeverListingTime,ForeverListingChinaTime from template where status = 7 and (Site = 'Germany' or Site = 'France')";
break;
}
//$sql_1 = "select scheduleTemplateName,accountId from template where status = 2 and Site = '".$Site."'";
$this->log("calculateForeverListingSchedule-" . $Site . ".html", $sql_1 . "<br>");
$result_1 = mysql_query($sql_1, Cron::$database_connect);
$i = 0;
$template = new Template();
$template->setBatch(true);
while ($row_1 = mysql_fetch_assoc($result_1)) {
$sql_2 = "select count(*) as num from items where Status = 2 and TemplateID = " . $row_1['Id'];
$result_2 = mysql_query($sql_2, Cron::$database_connect);
$row_2 = mysql_fetch_assoc($result_2);
if ($row_2['num'] > 0) {
$this->log("calculateForeverListingSchedule-" . $Site . ".html", $row_1['Id'] . " has active listings.<br>");
continue;
}
$template->setAccountId($row_1['accountId']);
//$local_time = $day." ".$row_1['ForeverListingTime'];
$china_time = $day . " " . substr($template->getSiteTime($Site, "1983-11-16", $row_1['ForeverListingTime']), 11, 5);
$local_time = $template->getLocalTimeByChinaTime($Site, $china_time);
//$china_time = $day." ".$row_1['ForeverListingChinaTime'];
$item_id = $template->changeTemplateToItem($row_1['Id'], $china_time, $local_time, 1);
if (strpos($item_id, "error") !== false) {
$this->log("calculateForeverListingSchedule-" . $Site . ".html", $item_id . "<br>");
continue;
}
$this->log("calculateForeverListingSchedule-" . $Site . ".html", "t:" . $row_1['Id'] . " ==> i:" . $item_id . ". BeiJing:" . $china_time . ", " . $Site . ": " . $local_time . "<br>");
$this->log("calculateForeverListingSchedule-" . $Site . ".html", "<br><font color='red'>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++</font><br>");
}
}
}
private function eBayUpdateItem($item, $userId)
{
global $nest, $storeNest;
switch ($item->SellingStatus->ListingStatus) {
case "Active":
$Status = 2;
break;
case "Completed":
if ($item->SellingStatus->QuantitySold > 0) {
$Status = 6;
} else {
$Status = 5;
}
break;
case "Ended":
if ($item->SellingStatus->QuantitySold > 0) {
$Status = 6;
} else {
$Status = 5;
}
break;
}
switch ($item->PictureDetails->GalleryType) {
case "Featured":
$GalleryTypeFeatured = 1;
$GalleryTypeGallery = 0;
$GalleryTypePlus = 0;
break;
case "Gallery":
$GalleryTypeGallery = 1;
$GalleryTypeFeatured = 0;
$GalleryTypePlus = 0;
break;
case "Plus":
$GalleryTypePlus = 1;
$GalleryTypeFeatured = 0;
$GalleryTypeGallery = 0;
break;
}
$nest = 0;
$storeNest = 0;
$PrimaryCategoryCategoryName = $this->getCategoryPathById($this->getSiteIdByName($item->Site), $item->PrimaryCategory->CategoryID);
$SecondaryCategoryCategoryName = $this->getCategoryPathById($this->getSiteIdByName($item->Site), $item->SecondaryCategory->CategoryID);
$StoreCategoryName = $this->getStoreCategoryPathById($this->account_id, $item->Storefront->StoreCategoryID);
$StoreCategory2Name = $this->getStoreCategoryPathById($this->account_id, $item->Storefront->StoreCategory2ID);
/*
$sql = "update items set AutoPay='".mysql_escape_string($item->AutoPay)."',
BuyItNowPrice='".mysql_escape_string($item->BuyItNowPrice)."',Country='".mysql_escape_string($item->Country)."',
Currency='".mysql_escape_string($item->Currency)."',
DispatchTimeMax='".mysql_escape_string($item->DispatchTimeMax)."',StartTime='".mysql_escape_string($item->ListingDetails->StartTime)."',
EndTime='".mysql_escape_string($item->ListingDetails->EndTime)."',ViewItemURL='".mysql_escape_string($item->ListingDetails->ViewItemURL)."',ListingDuration='".mysql_escape_string($item->ListingDuration)."',
ListingType='".mysql_escape_string($item->ListingType)."',Location='".mysql_escape_string($item->Location)."',
PaymentMethods='".mysql_escape_string($item->PaymentMethods)."',PayPalEmailAddress='".mysql_escape_string($item->PayPalEmailAddress)."',
PostalCode='".mysql_escape_string($item->PostalCode)."',PrimaryCategoryCategoryID='".mysql_escape_string($item->PrimaryCategory->CategoryID)."',
PrimaryCategoryCategoryName='".mysql_escape_string($PrimaryCategoryCategoryName)."',Quantity='".mysql_escape_string($item->Quantity)."',
ReturnPolicyDescription='".mysql_escape_string($item->ReturnPolicy->Description)."',ReturnPolicyRefundOption='".mysql_escape_string($item->ReturnPolicy->RefundOption)."',
ReturnPolicyReturnsAcceptedOption='".mysql_escape_string($item->ReturnPolicy->ReturnsAcceptedOption)."',ReturnPolicyReturnsWithinOption='".mysql_escape_string($item->ReturnPolicy->ReturnsWithinOption)."',
ReturnPolicyShippingCostPaidByOption='".mysql_escape_string($item->ReturnPolicy->ShippingCostPaidByOption)."',
CurrentPrice='".mysql_escape_string($item->SellingStatus->CurrentPrice)."',QuantitySold='".mysql_escape_string($item->SellingStatus->QuantitySold)."',
ListingStatus='".mysql_escape_string($item->SellingStatus->ListingStatus)."',SecondaryCategoryCategoryID='".$item->SecondaryCategory->CategoryID."',SecondaryCategoryCategoryName='".mysql_escape_string($SecondaryCategoryCategoryName)."',
ShippingType='".mysql_escape_string($item->ShippingDetails->ShippingType)."',
Site='".mysql_escape_string($item->Site)."',SKU='".mysql_escape_string($item->SKU)."',
StartPrice='".mysql_escape_string($item->StartPrice)."',StoreCategory2ID='".mysql_escape_string($item->Storefront->StoreCategory2ID)."',StoreCategory2Name='".mysql_escape_string($StoreCategory2Name)."',
StoreCategoryID='".mysql_escape_string($item->Storefront->StoreCategoryID)."',StoreCategoryName='".mysql_escape_string($StoreCategoryName)."',Title='".htmlentities($item->Title, ENT_QUOTES)."',
UserID='".mysql_escape_string($userId)."',Status='".$Status."',
GalleryTypeFeatured=".$GalleryTypeFeatured.",GalleryTypeGallery=".$GalleryTypeGallery.",GalleryTypePlus=".$GalleryTypePlus.",GalleryURL='".$item->PictureDetails->GalleryURL."' where ItemID = '".$item->ItemID."'";
*/
$sql = "update items set QuantitySold='" . mysql_escape_string($item->SellingStatus->QuantitySold) . "',\n\tListingStatus='" . mysql_escape_string($item->SellingStatus->ListingStatus) . "',\n\tUserID='" . mysql_escape_string($userId) . "',Status='" . $Status . "' where ItemID = '" . $item->ItemID . "'";
//echo $sql;
//echo "<br>";
//debugLog("eBay-update-item-track.log", $sql);
//$sql = "update items set CurrentPrice='".$item->SellingStatus->CurrentPrice."',QuantitySold='".$item->SellingStatus->QuantitySold."',ListingStatus='".$item->SellingStatus->ListingStatus.",Status='".$Status."''
//where ItemID = '".$item->ItemID."'";
echo $sql;
echo "<br>\n";
$result = mysql_query($sql, eBayListing::$database_connect);
$sql = "select Id,TemplateID from items where ItemID = '" . $item->ItemID . "'";
$result = mysql_query($sql, eBayListing::$database_connect);
$row = mysql_fetch_assoc($result);
//get template status for forever listing
$sql_1 = "select status from template where Id = " . $row['TemplateID'];
$result_1 = mysql_query($sql_1, eBayListing::$database_connect);
$row_1 = mysql_fetch_assoc($result_1);
if ($row_1 == 7) {
require_once "template.php";
$template = new Template();
$item_id = $template->changeTemplateToItem($row['TemplateID'], '', date("Y-m-d H:i:s", time() + 2 * 60), 1);
$this->log("template", "TemplateID: " . $row['TemplateID'] . " auto change to item upload(forever listing status).");
}
return $row['Id'];
}
