<?php
global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
tep_db_connect();
use_class('element');
//LIST 1
//$elements_todelete = array(1704,1705,1706,1707,1708,1066,1070,1744,1276,1735,1736,1737,1738,1741,1742,1743,1745,1746,1747,1748,1749,1750,1751,1752,1753,1754,1755,1756,1757,1758,1759,1760,1761,1762,1763,1764,1765,1766,1767,1768,1769,1771,1772,1773,1774,1775,1776,1777,1778,1779,1780,1781,1782,1783,1784,1785,1786,1787,1788,1789,1790,1808,1809,1810,1811,1812,1813,1814,1815,1823,1825,1826,1827,1829,1830,1831,1833,1836,1839,1841,1842,1843,1844,1845,1849,2012,2015,2023,2041,2042,2043,2046,2048,2050,2058,2059,2060,2061,2062,2063,2064,2075,2076,2077,2078,2091,2092,2093,2099,2100,2344,2345,2346,2347,2348,2363,2364,2365,2366,2367,2368,2397,2461,2454,2456,2462,2463,2464,2465,2466,2467,2468,2469,2470,2471,2472,2475,2476,2477,2478,2479,2480,2481,2482,2483,2484,2485,2486,2487,2488,2489,2490,2491,2492,2493,2494,2495,2496,2497,2498,2499,2500,2501,2502,2503,2504,2505,2506,2507,2508,2510,2511,2512,2513,2514,2515,2516,2517,2518,2519,2520,2521,2523,2524,2525,2527,2528,2529,2530,2531,2532,2533,2534,2535,2536,2537,2538,2539,2542,2543,2544,2545,2546,2547,2548,2549,2550,2551,2552,2553,2554,2555,2556,2557,2558,2559,2560,2561,2562,2563,2564,2565,2566,2567,2568,2570,2571,2572,2573,2574,2575,2576,2577,2578,2579,2580,2581,2582,2583,2584,2609,2610,2611,2612,2614,2616,2618,2619,2620,2621,2622,2623,2624,2625,2629,2631,2633,2634,2635,2637,2639,2641,2668,2756,2759,2773,2775,2827,2828,2829,2830,2831,2832,2833,2834,2835,2836,2837,2838,2839,2840,2841,2842,2843,2844,2845,2846,2847,2848,2849,2850,2851,2852,2867,2869,2870,2872,2873,2874,2875,2877,2880,2883,2884,2885,2886,2887,2888,2892,2894,2896,2897,2898,2899,2900,2906,2907,2913,2927,2947,2948,2951,2956,2957,2970,2971,2972,2973,2974,2975,2976,2977,2987,2988,2990,2992,3002,3004,3005,3007,3009,3014,3015,3017,3023,3026,3028,3036,3037,3038,3039,3040,3041,3042,3043,3045,3048,3050,3051,3053,3054,3075,3076,3077,3078,3079,3080,3081,3083,3085,3086,3088,3096,3099,3100,3102,3103,3105,3107,3123,3124,3126,3128,3137,3143,3145,3148,3149,3151,3153,3154,3155,3172,3178,3179,3180,3182,3184,3185,3187,3204,3205,3206,3208,3255,3257,3258,3259,3279,3280,3281,3282,3283,3284,3285,3286,3287,3288,3289,3290,3292,3293,3294,3295,3296,3297,3298,3299,3300,3301,3302,3303,3304,3305,3306,3307,3308,3309,3310,3314,3317,3319,3321,3323,3325,3346,3375);
//LIST 2
//$elements_todelete = array(3898,3901,3902,3939,3954,3994,3995,4010,4011,4024,4025,4026,4027,4028,4029,4030,4031,4032,4033,4034,4035,4036,4037,4038,4039,4040,4041,4042,4043,4044,4045,4046,4047,4048);
//LIST 3
//$elements_todelete = array(1895,1896,1897,1898,1899,1900,1901,1902,1903,1904,1905,1906,1907,1908,1909,1910,1911,1912,1913,1914,1915,1916,1917,1918,1919,1920,1921,1922,1923,1924,1925,1926,1927,1928,1929,1930,2678,2687,2688,2689);
//LIST 4
$elements_todelete = array();
$count = 0;
foreach ($elements_todelete as $eid) {
$element = new element($eid);
if (!is_null($element->id)) {
$element->delete();
$count++;
}
}
echo "{$count} Elements are deleted";
tep_db_close();
function deleteElement($elements_id, $username)
{
use_class('element');
$element = new element($elements_id);
$elements_name = $element->detail['name'];
$element->delete($username);
if ($this->id > 0) {
tep_db_query("DELETE FROM designs_elements WHERE elements_id = '{$elements_id}'");
}
$comment = 'I delete Element ID ' . $elements_id . ' (' . $elements_name . ')';
$this->comments->addComment($username, $comment);
}
function postProcess($post_vars)
{
global $session_userinfo;
$result = array();
if ($post_vars['me_action'] == 'SEARCH') {
$type = $post_vars['type'];
$jng_sp_id = $post_vars['jng_sp_id'];
//another strange case, in live datepicker filter is always given as \'datevalue\' instead of 'datevalue'
//still cant find the root cause (and it's ok in local dev), so for quickwin workaround we simple replace
//the \' value into ' with below update (sahat 11.02.2014)
//$post_filters = explode("|", $post_vars['post_filters']);
$post_filters = explode("|", str_replace('\\\'', "'", $post_vars['post_filters']));
$filters = array();
foreach ($post_filters as $f) {
$f_temp = explode('-', $f);
$field = $f_temp[0];
unset($f_temp[0]);
$value = implode('-', $f_temp);
//explode to array for input on field $multivalue_fields which allowed multivalue separated by $multivalue_separator
if (in_array($field, $this->multivalue_fields)) {
$mv_temp = explode(current($this->multivalue_separator), $value);
if (is_array($mv_temp) && $mv_temp > 0) {
foreach ($mv_temp as $mv) {
$mv = trim($mv);
if (!isset($filters[$field]) || !in_array($mv, $filters[$field])) {
$filters[$field][] = $mv;
}
}
} else {
$filters[$field][] = $value;
}
} else {
$filters[$field][] = $value;
}
}
$query = $this->constructQuery($jng_sp_id, $filters);
$dbq = tep_db_query($query);
$result = '';
$total = 0;
$elements_ids = '';
//$display_spot = '';
while ($r = tep_db_fetch_array($dbq)) {
$total++;
if ($total > 1) {
$elements_ids .= ',';
}
$elements_ids .= $r['elements_id'];
// $display_spot .= '<div id="'.$r['elements_id'].'" class="lists-elements"></div>';
}
$result['type'] = $type;
$result['total'] = $total;
$result['elements_ids'] = $elements_ids;
// $result['display_spot'] = $display_spot;
ajaxReturn($result);
} elseif ($post_vars['me_action'] == 'DISPLAY') {
$type = $post_vars['type'];
$elements_id = $post_vars['elements_id'];
$query = "SELECT e.elements_id, e.elements_code, e.elements_name, e.elements_image, e.elements_price, e.add_date, IFNULL(e.elements_weight,'-') elements_weight, e.stars, e.elements_description";
$query .= ", IFNULL(esup.suppliers_name,'-') suppliers_name";
$query .= ", el.used_in_products, IFNULL(el.weekly_sold, '-') weekly_sold, IFNULL(el.weekly_sold_products, '-') weekly_sold_products, IFNULL(el.sold_monthly_1, '-') last_month_sold";
$query .= ", (IFNULL(els.sold_{$this->last_year}_sp, 0) + IFNULL(els.sold_{$this->last_year}_jg, 0)) sold_{$this->last_year}";
$query .= ", (IFNULL(els.sold_products_{$this->last_year}_sp, 0) + IFNULL(els.sold_products_{$this->last_year}_jg, 0)) sold_products_{$this->last_year}";
$query .= ", ec.name AS cat_name, pm.material_name AS mat_name, cpd.name AS color_name, ei.name AS size_name, eh.name AS holesize_name";
$query .= ", es.name AS shape_name, es.shape_image, eu.name AS surface_name, eu.surface_image, et.name AS cut_name, et.cuts_image AS cut_image";
$query .= ", ehe.name AS height_name, ew.name AS width_name, eth.name AS thickness_name, est.stock";
$query .= ", DATEDIFF(NOW(), e.add_date) AS elements_age";
$query .= " FROM element e";
$query .= " LEFT JOIN elements_log el ON el.elements_id=e.elements_id";
$query .= " LEFT JOIN elements_log_static els ON els.elements_id=e.elements_id";
$query .= " LEFT JOIN elements_to_elements_suppliers etes ON etes.elements_id = e.elements_id AND is_default = 1";
$query .= " LEFT JOIN elements_suppliers esup ON esup.elements_suppliers_id = etes.elements_suppliers_id";
$query .= " LEFT JOIN elements_stock est ON est.elements_id = e.elements_id AND est.jng_warehouses_id = " . WAREHOUSE_ID_ELEMENTS;
$query .= " LEFT JOIN element_category ec ON ec.element_category_id=e.attribute_category_id";
$query .= " LEFT JOIN products_materials pm ON pm.products_materials_id=e.attribute_material_id";
$query .= " LEFT JOIN color_pattern cp ON cp.color_pattern_id=e.attribute_color_id";
$query .= " LEFT JOIN color_pattern_description cpd ON cpd.color_pattern_id=e.attribute_color_id AND languages_id=1";
$query .= " LEFT JOIN element_size ei ON ei.element_size_id=e.attribute_size_id";
$query .= " LEFT JOIN element_holesize eh ON eh.element_holesize_id=e.attribute_holesize_id";
$query .= " LEFT JOIN element_shape es ON es.element_shape_id=e.attribute_shape_id";
$query .= " LEFT JOIN element_surface eu ON eu.element_surface_id=e.attribute_surface_id";
$query .= " LEFT JOIN element_cut et ON et.element_cut_id=e.attribute_cut_id";
$query .= " LEFT JOIN element_height ehe ON ehe.element_height_id=e.attribute_height_id";
$query .= " LEFT JOIN element_width ew ON ew.element_width_id=e.attribute_width_id";
$query .= " LEFT JOIN element_thickness eth ON eth.element_thickness_id=e.attribute_thickness_id";
$query .= " WHERE e.elements_id = '{$elements_id}'";
$dbq = tep_db_query($query);
$res = tep_db_fetch_array($dbq);
$elements_image = webImageWithDetailLink($res['elements_image'], IMAGE_SIZE_THUMBNAIL_1, IMAGE_SIZE_THUMBNAIL_1, 'Element ' . $res['elements_id'], 'img-border');
$elements_created = date('d-M-Y', strtotime($res['add_date']));
$elements_price = $res['elements_price'] < ELEMENTS_LOWER_PRICE ? displayCurrency('EUR', $res['elements_price'], true, 5) : displayCurrency('EUR', $res['elements_price']);
$resultsdt = array();
//0-4
$resultsdt[] = $elements_id;
$resultsdt[] = $elements_image;
//$resultsdt[] = $res['elements_name'];
$resultsdt[] = $res['elements_description'];
$resultsdt[] = $elements_created;
$resultsdt[] = $elements_price;
//5-9
$resultsdt[] = $res['suppliers_name'];
$resultsdt[] = $res['weekly_sold'];
$resultsdt[] = $res['weekly_sold_products'];
$resultsdt[] = $res['sold_' . $this->last_year];
$resultsdt[] = $res['sold_products_' . $this->last_year];
//10-14'd
$resultsdt[] = $res['elements_weight'];
$resultsdt[] = $res['last_month_sold'];
$resultsdt[] = $res['stock'];
$resultsdt[] = drawStars($res['stars']);
$resultsdt[] = $res['elements_age'];
$result['type'] = $type;
$result['result'] = implode($this->result_separator, $resultsdt);
ajaxReturn($result);
} elseif ($post_vars['me_action'] == 'KILLELEMENT') {
use_class('element');
$elid = tep_db_prepare_input($_POST['elid']);
$element = new element($elid);
$is_deleted = $element->delete($session_userinfo['username']);
$result = array();
$result['target_id'] = $elid;
$result['is_deleted'] = $is_deleted;
ajaxReturn($result);
}
}
$fq .= " WHERE {$field}='{$filter_attr_id}'";
}
if ($keywords != '') {
$fq .= $fq == '' ? " WHERE " : " AND ";
if (is_numeric($keywords)) {
$fq .= "elements_id={$keywords}";
} elseif (strlen($keywords) < 10 && strpos($keywords, '-') !== false) {
$fq .= "elements_code='{$keywords}'";
} else {
$fq .= "elements_name LIKE '%{$keywords}%'";
}
}
} elseif ($_POST['me_action'] == 'ELEMENTDELETE') {
$id = tep_db_prepare_input($_POST['elements_id']);
$element = new element($id);
$is_deleted = $element->delete($session_userinfo['username']);
$result = array();
$result['target_id'] = $id;
$result['is_deleted'] = $is_deleted;
ajaxReturn($result);
exit;
}
}
$listofids = array();
$q = "SELECT elements_id FROM element" . $fq;
$q .= " ORDER BY is_finalized ASC, add_date DESC, elements_id DESC";
$r = tep_db_query($q);
if (tep_db_num_rows($r) == 1) {
$row = tep_db_fetch_array($r);
header("Location: ?open=element&id={$row['elements_id']}");
exit;