modifications.php
1.98 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
<?php
if(isset($_GET['upd']) && $_GET['upd']>0){
$objCatalogs->db->autoExecute("catalogs_products",array('count_modifications'=>0),DB_AUTOQUERY_UPDATE);
$res = $objCatalogs->db->getAll("select * from catalogs_products",array(),DB_FETCHMODE_ASSOC);
foreach($res as $row){
$count = $objCatalogs->db->getOne("select count(*) from catalogs_modifications where product_id=? and active>0",array($row['id']));
$objCatalogs->db->autoExecute("catalogs_products",array('count_modifications'=>$count),DB_AUTOQUERY_UPDATE,"id='".$row['id']."'");
}
}
if(isset($_POST['save'])){
$objCatalogs->trim($_POST);
if(!$objCatalogs->valid($_POST,$_FILES)){
$saveId = $objCatalogs->SaveModification($_POST,$_FILES);
if($_POST['active']!=$_POST['last_active']){
if($_POST['active']==0)$CountPrefix = '-';
else $CountPrefix = '+';
$objCatalogs->updateProductModificationCountPrefix($_GET['productID'],$CountPrefix);
}
/*
if($_POST['update_id']>0 && $_POST['active']==0 && $_POST['last_active']!=0)$CountPrefix = '-';
elseif() $CountPrefix = '+';
if($_POST['update_id'] || $_POST['active']==1)$objCatalogs->updateProductModificationCountPrefix($_GET['productID'],$CountPrefix);
*/
header("location:" . URL . "admin.php?action={$rule['action']}&modAction=modifications&rubID=" . $_GET['rubID'] . "&productID=" . $_GET['productID']);
}
}elseif(isset($_GET['updateID']) && $_GET['updateID']>0){
$objCatalogs->viewModificationOne($_GET['updateID']);
}elseif(isset($_GET['deleteID']) && $_GET['deleteID']>0){
$objCatalogs->deleteModification($_GET['deleteID']);
if($_GET['active']==1)$objCatalogs->updateProductModificationCountPrefix($_GET['productID'],"-");
header("location:" . URL . "admin.php?action={$rule['action']}&modAction=modifications&rubID=" . $_GET['rubID'] . "&productID=" . $_GET['productID']);
}
$objCatalogs->viewRubricOne($_GET['rubID'],$row);
$objCatalogs->viewProductOne($_GET['productID'],$row);
$objCatalogs->viewModifications($_GET['productID']);
$objCatalogs->displayModifications();
?>