function _process($type, $image_group, $position, $opacity, $watermark = true)
{
global $osC_Database;
if ($type == 'products') {
$Qimages = $osC_Database->query('select image from :table_products_images');
$Qimages->bindTable(':table_products_images', TABLE_PRODUCTS_IMAGES);
} else {
$Qimages = $osC_Database->query('select articles_image as image from :table_articles');
$Qimages->bindTable(':table_articles', TABLE_ARTICLES);
}
$Qimages->execute();
$osC_Image = new osC_Image_Admin();
while ($Qimages->next()) {
$image = $Qimages->value('image');
if ($watermark === true) {
$original_image = DIR_FS_CATALOG . DIR_WS_IMAGES . $type . '/originals/' . $image;
$original_watermarked_image = DIR_FS_CATALOG . DIR_WS_IMAGES . $type . '/originals/' . 'watermark_' . $image;
toc_draw_watermark($original_image, $original_watermarked_image, DIR_FS_CATALOG . DIR_WS_IMAGES . WATERMARK_FILE_NAME, $position, $opacity);
}
foreach ($osC_Image->getGroups() as $group) {
if ($group['id'] == $image_group) {
$osC_Image->resize($image, $group['id'], $type, $watermark);
}
}
}
return true;
}
function loadImageGroups()
{
global $toC_Json;
$osC_Image = new osC_Image_Admin();
foreach ($osC_Image->getGroups() as $group) {
if ($group['id'] != 1) {
$modules[] = array('id' => $group['id'], 'text' => $group['code']);
}
}
$response = array(EXT_JSON_READER_ROOT => $modules);
echo $toC_Json->encode($response);
}
function uploadImage()
{
global $toC_Json, $osC_Database, $osC_Session;
$osC_Image = new osC_Image_Admin();
if (is_array($_FILES)) {
$products_image = array_keys($_FILES);
$products_image = $products_image[0];
}
$products_image = new upload($products_image);
if (isset($_REQUEST['products_id']) && $_REQUEST['products_id'] > 0) {
if ($products_image->exists()) {
$image_path = '../images/products/originals/';
$products_image->set_destination($image_path);
if ($products_image->parse() && $products_image->save()) {
$default_flag = 1;
$Qcheck = $osC_Database->query('select id from :table_products_images where products_id = :products_id and default_flag = :default_flag limit 1');
$Qcheck->bindTable(':table_products_images', TABLE_PRODUCTS_IMAGES);
$Qcheck->bindInt(':products_id', $_REQUEST['products_id']);
$Qcheck->bindInt(':default_flag', 1);
$Qcheck->execute();
if ($Qcheck->numberOfRows() === 1) {
$default_flag = 0;
}
$Qimage = $osC_Database->query('insert into :table_products_images (products_id, image, default_flag, sort_order, date_added) values (:products_id, :image, :default_flag, :sort_order, :date_added)');
$Qimage->bindTable(':table_products_images', TABLE_PRODUCTS_IMAGES);
$Qimage->bindInt(':products_id', $_REQUEST['products_id']);
$Qimage->bindValue(':image', $products_image->filename);
$Qimage->bindInt(':default_flag', $default_flag);
$Qimage->bindInt(':sort_order', 0);
$Qimage->bindRaw(':date_added', 'now()');
$Qimage->execute();
if (!$osC_Database->isError()) {
$image_id = $osC_Database->nextID();
$new_image_name = $_REQUEST['products_id'] . '_' . $image_id . '_' . $products_image->filename;
@rename($image_path . $products_image->filename, $image_path . $new_image_name);
$Qupdate = $osC_Database->query('update :table_products_images set image = :image where id = :id');
$Qupdate->bindTable(':table_products_images', TABLE_PRODUCTS_IMAGES);
$Qupdate->bindValue(':image', $new_image_name);
$Qupdate->bindInt(':id', $image_id);
$Qupdate->execute();
}
foreach ($osC_Image->getGroups() as $group) {
if ($group['id'] != '1') {
$osC_Image->resize($new_image_name, $group['id']);
}
}
}
}
} else {
$image_path = '../images/products/_upload/' . $osC_Session->getID() . '/';
toc_mkdir($image_path);
if ($products_image->exists()) {
$products_image->set_destination($image_path);
$products_image->parse();
$products_image->save();
}
}
header('Content-Type: text/html');
$response['success'] = true;
$response['feedback'] = $osC_Language->get('ms_success_action_performed');
echo $toC_Json->encode($response);
}
function uploadImage()
{
global $toC_Json, $osC_Database;
$osC_Image = new osC_Image_Admin();
if (is_array($_FILES)) {
$products_image = array_keys($_FILES);
$products_image = $products_image[0];
}
if (isset($_REQUEST['products_id'])) {
$products_image = new upload($products_image);
if ($products_image->exists()) {
$products_image->set_destination(realpath('../images/products/originals'));
if ($products_image->parse() && $products_image->save()) {
$default_flag = 1;
$Qcheck = $osC_Database->query('select id from :table_products_images where products_id = :products_id and default_flag = :default_flag limit 1');
$Qcheck->bindTable(':table_products_images', TABLE_PRODUCTS_IMAGES);
$Qcheck->bindInt(':products_id', $_REQUEST['products_id']);
$Qcheck->bindInt(':default_flag', 1);
$Qcheck->execute();
if ($Qcheck->numberOfRows() === 1) {
$default_flag = 0;
}
$Qimage = $osC_Database->query('insert into :table_products_images (products_id, image, default_flag, sort_order, date_added) values (:products_id, :image, :default_flag, :sort_order, :date_added)');
$Qimage->bindTable(':table_products_images', TABLE_PRODUCTS_IMAGES);
$Qimage->bindInt(':products_id', $_REQUEST['products_id']);
$Qimage->bindValue(':image', $products_image->filename);
$Qimage->bindInt(':default_flag', $default_flag);
$Qimage->bindInt(':sort_order', 0);
$Qimage->bindRaw(':date_added', 'now()');
$Qimage->setLogging($_SESSION['module'], $_REQUEST['products_id']);
$Qimage->execute();
foreach ($osC_Image->getGroups() as $group) {
if ($group['id'] != '1') {
$osC_Image->resize($products_image->filename, $group['id']);
}
}
}
}
}
header('Content-Type: text/html');
$response['success'] = true;
$response['feedback'] = $osC_Language->get('ms_success_action_performed');
echo $toC_Json->encode($response);
}
function insertProduct($product, $descriptions, $categories_id, $images)
{
global $osC_Database;
$insert = true;
$products_id = (int) $product['products_id'];
unset($product['products_id']);
if ($products_id > 0 && osC_Products_Importer::isProductExist($products_id)) {
$insert = false;
}
if ($insert == true) {
$products_id = toC_Importer::insertData(TABLE_PRODUCTS, $product);
//categories
if (is_array($categories_id) && !empty($categories_id)) {
foreach ($categories_id as $category) {
$data = array('categories_id' => $category, 'products_id' => $products_id);
toC_Importer::insertData(TABLE_PRODUCTS_TO_CATEGORIES, $data);
}
}
//description
foreach ($descriptions as $description) {
$description['products_id'] = $products_id;
toC_Importer::insertData(TABLE_PRODUCTS_DESCRIPTION, $description);
}
$sort_id = 1;
foreach ($images as $image) {
$image['products_id'] = $products_id;
$image['default_flag'] = $sort_id == 1 ? 1 : 0;
$image['sort_order'] = $sort_id++;
if (file_exists(DIR_FS_CATALOG . DIR_WS_IMAGES . 'products/_upload/' . $image['image'])) {
$image_id = toC_Importer::insertData(TABLE_PRODUCTS_IMAGES, $image);
copy('../images/products/_upload/' . $image['image'], '../images/products/originals/' . $image['image']);
$new_image_name = $products_id . '_' . $image_id . '_' . $image['image'];
@rename('../images/products/originals/' . $image['image'], '../images/products/originals/' . $new_image_name);
$Qupdate = $osC_Database->query('update :table_products_images set image = :image where id = :id');
$Qupdate->bindTable(':table_products_images', TABLE_PRODUCTS_IMAGES);
$Qupdate->bindValue(':image', $new_image_name);
$Qupdate->bindInt(':id', $image_id);
$Qupdate->execute();
$osC_Image = new osC_Image_Admin();
foreach ($osC_Image->getGroups() as $group) {
if ($group['id'] != '1') {
$osC_Image->resize($new_image_name, $group['id'], 'products');
}
}
}
}
}
}
function insertProduct($product, $descriptions, $categories_id, $images)
{
global $osC_Database;
$products_id = toC_Importer::insertData(TABLE_PRODUCTS, $product);
if (isset($products_id) && $products_id != '') {
foreach ($descriptions as $description) {
$description['products_id'] = $products_id;
toC_Importer::insertData(TABLE_PRODUCTS_DESCRIPTION, $description);
}
$category['categories_id'] = $categories_id;
$category['products_id'] = $products_id;
toC_Importer::insertData(TABLE_PRODUCTS_TO_CATEGORIES, $category);
$sort_id = 1;
foreach ($images as $image) {
$image['products_id'] = $products_id;
$image['default_flag'] = $sort_id == 1 ? 1 : 0;
$image['sort_order'] = $sort_id++;
if (file_exists(DIR_FS_CATALOG . DIR_WS_IMAGES . 'products/_upload/' . $image['image'])) {
copy('../images/products/_upload/' . $image['image'], '../images/products/originals/' . $image['image']);
$osC_Image = new osC_Image_Admin();
foreach ($osC_Image->getGroups() as $group) {
if ($group['id'] != '1') {
$osC_Image->resize($image['image'], $group['id'], 'products');
}
}
toC_Importer::insertData(TABLE_PRODUCTS_IMAGES, $image);
}
}
}
}
public static function fileUpload()
{
global $osC_Database, $_module;
$osC_Image = new osC_Image_Admin();
if (is_numeric($_GET[$_module])) {
$products_image = new upload('products_image');
$products_image->set_extensions(array('gif', 'jpg', 'jpeg', 'png'));
if ($products_image->exists()) {
$products_image->set_destination(realpath('../images/products/originals'));
if ($products_image->parse() && $products_image->save()) {
$default_flag = 1;
$Qcheck = $osC_Database->query('select id from :table_products_images where products_id = :products_id and default_flag = :default_flag limit 1');
$Qcheck->bindTable(':table_products_images', TABLE_PRODUCTS_IMAGES);
$Qcheck->bindInt(':products_id', $_GET[$_module]);
$Qcheck->bindInt(':default_flag', 1);
$Qcheck->execute();
if ($Qcheck->numberOfRows() === 1) {
$default_flag = 0;
}
$Qimage = $osC_Database->query('insert into :table_products_images (products_id, image, default_flag, sort_order, date_added) values (:products_id, :image, :default_flag, :sort_order, :date_added)');
$Qimage->bindTable(':table_products_images', TABLE_PRODUCTS_IMAGES);
$Qimage->bindInt(':products_id', $_GET[$_module]);
$Qimage->bindValue(':image', $products_image->filename);
$Qimage->bindInt(':default_flag', $default_flag);
$Qimage->bindInt(':sort_order', 0);
$Qimage->bindRaw(':date_added', 'now()');
$Qimage->setLogging($_SESSION['module'], $_GET[$_module]);
$Qimage->execute();
foreach ($osC_Image->getGroups() as $group) {
if ($group['id'] != '1') {
$osC_Image->resize($products_image->filename, $group['id']);
}
}
}
}
}
$result = array('result' => 1, 'rpcStatus' => RPC_STATUS_SUCCESS);
echo json_encode($result);
}
