public function insert($imageList, $newsletterID)
{
$db = MySQL::getInstance();
$db->query("SELECT COUNT(*) FROM `newsletter_image` WHERE `NewsletterID` = " . $db->escape((int) $newsletterID));
$position = $row = $db->fetchField() ? $row : 0;
foreach ($imageList as $key => $image) {
$position++;
$db->query("INSERT INTO newsletter_image (NewsletterID, `File`, `Position`) VALUES (\n\t\t\t\t" . $db->escape((int) $newsletterID) . ",\n\t\t\t\t" . $db->escape($image) . ",\n\t\t\t\t" . $db->escape((int) $position) . "\n\t\t\t)");
if (File::copy($image, 'thumb_' . $image, 'var/newsletter/gallery/')) {
File::imageCrop('thumb_' . $image, 'var/newsletter/gallery/', 320, 240);
}
File::imageResize($image, 'var/newsletter/gallery/');
}
}
public function insert($imageList, $galleryID, $data)
{
$db = MySQL::getInstance();
$db->query("SELECT COUNT(*) FROM `gallery_image` WHERE `GalleryID` = " . $db->escape((int) $galleryID));
$row = $db->fetchField();
$position = $row ? $row : 0;
$position = $row = $db->fetchField() ? $row : 0;
foreach ($imageList as $key => $image) {
$position++;
$db->query("INSERT INTO gallery_image (GalleryID, `File`, `Title`, `Description`, `Position`) VALUES (\n\t\t\t\t" . $db->escape((int) $galleryID) . ",\n\t\t\t\t" . $db->escape($image) . ",\n\t\t\t\t" . $db->escape($data['Title'][$key], 255) . ",\t\t\t\t\n\t\t\t\t" . $db->escape($data['Description'][$key]) . ",\t\t\t\t\n\t\t\t\t" . $db->escape((int) $position) . "\n\t\t\t)");
if (File::copy($image, 'thumb_' . $image, 'var/gallery/')) {
File::imageCrop('thumb_' . $image, 'var/gallery/', 155, 110);
}
File::imageResize($image, 'var/gallery/');
}
}
public function insert($imageList, $itemID, $data)
{
$db = MySQL::getInstance();
$db->query("SELECT COUNT(*) FROM `catalog_image` WHERE `ItemID` = " . $db->escape((int) $itemID));
$row = $db->fetchField();
$position = $row ? $row : 0;
foreach ($imageList as $key => $image) {
$position++;
$db->query("INSERT INTO catalog_image (ItemID, `File`, `Title`, `Description`, `Position`) VALUES (\n\t\t\t\t" . $db->escape((int) $itemID) . ",\n\t\t\t\t" . $db->escape($image) . ",\n\t\t\t\t" . $db->escape($data['Title'][$key], 125) . ",\n\t\t\t\t" . $db->escape($data['Description'][$key], 255) . ",\n\t\t\t\t" . $db->escape((int) $position) . "\n\t\t\t)");
// if (File::copy($image, 'icon_' . $image, 'var/catalog/gallery/')) {
// File::imageCrop('icon_' . $image, 'var/catalog/gallery/', 10, 10);
// }
if (File::copy($image, 'thumb_' . $image, 'var/catalog/gallery/')) {
File::imageCrop('thumb_' . $image, 'var/catalog/gallery/', 150, 150);
}
// if (File::copy($image, 'main_' . $image, 'var/catalog/gallery/')) {
// File::imageCrop('main_' . $image, 'var/catalog/gallery/', 10, 10);
// }
File::imageResize($image, 'var/catalog/gallery/', 373, 309);
}
}
public function update($data, $catalogID = 0)
{
if (!(isset($data['Title']) && strlen(trim($data['Title'])) > 0)) {
throw new Exception(lang('data_empty', __CLASS__));
}
$db = MySQL::getInstance();
$queryStr = "";
if ($imageName = File::upload('var/catalog/')) {
$this->deleteFile($catalogID);
// if (File::copy($imageName, 'thumb_' . $imageName, 'var/catalog/')) {
// File::imageResize('thumb_' . $imageName, 'var/catalog/', 175, 175);
// }
if (File::copy($imageName, 'tmb/' . $imageName, 'var/catalog/')) {
File::imageResize($imageName, 'var/catalog/tmb/', 100, 100);
}
File::imageResize($imageName, 'var/catalog/', 800, 600);
$queryStr .= ', `Image` = ' . $db->escape($imageName);
}
$status = isset($this->aStatus[$data['Status']]) ? $data['Status'] : 'show';
$db->query('UPDATE `catalog` SET
`Status` = ' . $db->escape($status) . ',
`Title` = ' . $db->escape($data['Title'], 125) . ',
`PropertyID` = ' . $db->escape((int) $data['PropertyID']) . ',
`MetaTitle` = ' . $db->escape($data['MetaTitle'], 125) . ',
`Content2` = ' . $db->escape($data['Content2']) . ',
`Description` = ' . $db->escape($data['Description']) . ',
`Code` = ' . $db->escape($data['Code']) . ',
`Price` = ' . $db->escape((int) $data['Price']) . ',
`Ed` = ' . $db->escape($data['Ed']) . ',
`Content` = ' . $db->escape($data['Content']) . '
' . $queryStr . '
WHERE ItemID = ' . $db->escape((int) $catalogID));
$oImage = new Catalog_Image();
if (($imageList = File::upload('var/catalog/gallery/', 'Gallery', false)) !== false) {
$oImage->insert($imageList, $catalogID, $data['Gallery']);
}
// $oConsistency = new Catalog_Consistency();
// $oConsistency->insertItems($data['ConsistencyID'], $catalogID);
return $catalogID;
}
