<?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;