';
print_r($_REQUEST);
echo '';
die();*/
require_once('../../config/config.php');
include("../../common_pages/paging_crm.php");
include("../../common_pages/common_functions.php");
require_once("../../common_pages/enc.php");
$converter = new Encryption($_SESSION['unique_enc_id']);
require_once('constants.php');
?>
","min",$id);
if($a!="")
{
$ccode = find_sort_id_code("product",$a);
$ssi = find_sort_id("product",$id);
$qry = "Update product set sort_id='".$a."' where code='".$id."'";
mysql_query($qry);
$qry = "Update product set sort_id='".$ssi."' where code='".$ccode."'";
mysql_query($qry);
}
return true;
}
function find_sort_id($tb,$id)
{
echo $qry = "SELECT sort_id FROM $tb where code = '".$id."'";
$result = mysql_query($qry);
$rows = mysql_num_rows($result);
while($rows = mysql_fetch_assoc($result))
{
return $rows['sort_id'];
}
}
function sort_id($tb,$co,$co2,$data)
{
$qry = "SELECT $co2(sort_id) as si FROM $tb where sort_id $co '".find_sort_id($tb,$data)."'";
$result = mysql_query($qry);
$rows = mysql_num_rows($result);
while( $rows = mysql_fetch_array($result))
{
return $rows['si'];
}
}
function find_sort_id_code($tb,$id)
{
$qry = "SELECT code FROM $tb where sort_id = '".$id."'";
$result = mysql_query($qry);
$rows = mysql_num_rows($result);
while($rows = mysql_fetch_array($result))
{
return $rows['product_id'];
}
}
function find_max_sort_id($tb)
{
$qry = "SELECT max(sort_id) as sort_id FROM $tb";
//echo $qry;
$result = mysql_query($qry);
$rows = mysql_num_rows($result);
while( $rows = mysql_fetch_array($result))
{
return $rows['sort_id'];
}
}
function find_sort_id_max_gn($tb)
{
$sql = "SELECT max(sort_id) as mm from $tb";
$res = mysql_query($sql);
$rows = mysql_fetch_assoc($res);
if($rows['mm'])
return $rows['mm'];
else
return 0;
}
function no_of_products($pcode)
{
$sql = "SELECT count(*) as c FROM product_pictures WHERE client_id = '".$_SESSION['client_id']."' product_code='".$pcode."' ";
$res = mysql_query($sql);
$rows = mysql_fetch_assoc($res);
return (int)$rows['c'];
}
// print_r($_REQUEST);
switch($_REQUEST['task'])
{
case'ProductDetails':
{
/*$s = "UPDATE product SET product_style_code='0'";
//echo '';
print_r($_POST);
echo ' '; */
if($_REQUEST['store_id']<>"")
$where.=" AND p.store_id = '".$_REQUEST['store_id']."' ";
if($_REQUEST['status']<>"")
$where.=" AND p.status = '".$_REQUEST['status']."' ";
if($_REQUEST['s_stock']<>"" and $_REQUEST['s_stock']<=1)
$where.=" AND p.is_stock = '".$_REQUEST['s_stock']."' ";
if($_REQUEST['s_stock']==2)
$where.=" AND p.product_sold_out = '1' ";
if($_REQUEST['s_product_style_code']>0)
$where.=" AND p.product_style_code = '".$_REQUEST['s_product_style_code']."' ";
$q = "SELECT p.*,dt.title as d_name,mt.name as m_name ,gt.title as g_name,p.product_id,st.name as style_name,st.c_date as created_date,supplier.name as supplier_name,store.name as store_name,size.title as product_size_default FROM product p
INNER JOIN diamond_type dt ON dt.code=diamond_type_default
INNER JOIN metal_type mt ON mt.code=metal_type_default
LEFT JOIN gems_type gt ON gt.code=gems_type_default
LEFT JOIN supplier_master as supplier ON supplier.code=supplier_code
LEFT JOIN store_master as store ON store.code=store_id
LEFT JOIN product_style_master st ON st.code=product_style_code
LEFT JOIN product_size_master size ON size.code=product_size_default
WHERE product_sale_inside=1 and p.is_deleted =0 and st.c_date $where ORDER BY product_ccode,product_name ";
// WHERE product_sale_inside=1 and p.is_deleted =0 and st.c_date BETWEEN '2022-02-01' AND '2022-06-20' $where ORDER BY
if($_REQUEST['page']>=1)
$_SESSION['page'] = $_REQUEST['page'];
if($_REQUEST['page']=='undefined')
$_SESSION['page'] = 1;
$_REQUEST['page'] = $_SESSION['page'];
if($_REQUEST['s_all_records']==1)
$p = paging_prepare($q,0,999999999);
else
$p = paging_prepare($q,$_REQUEST['page']);
//Paging New Script //
//$p = paging_prepare($q,$_SESSION['page']);
$p['task'] = 'ProductDetails';
$p['div'] = 'main_result_div';
$p['response_file'] = 'response_index';
$q .= " LIMIT ".$p['Page_Start'].",".$p['Per_Page']." ";
//end of Pageing
//echo '+++++=====> '.$q;
$qr = mysql_query($q) or die('Error: '.mysql_error());
?>
(+) Add New Product
#
Supplier Name
Product Code/SKU
Store Name
Certificate
Style
Product Name
Size
Diamond C/C
DD(%)
Weight
Appr Value
Metal
MD(%)
Weight
Appr Value
Stone
SD(%)
Weight
Value
MCD(%)
Making Charges
TAX (3%)
Total (Aprx)
Category
Availability
Status
Date
Action
'.$rows['product_id'];
?>
%
ct
0){
?>
gm
0){
?>
mm
0){
?>
0)
$d=$rows['making_charges'];
else
$d=($rows['metal_weight']*making_charges_rate(1));
$d1 = $d;
if($rows['making_charges_discount_percentage']>0){
?>
'.$total.'':'');?>
|
Pagination Finish
}
break;
case 'moveFAQ':
{
//print_r($_REQUEST);
moveProduct($_REQUEST['id'],$_REQUEST['direction']);
}
break;
case 'add_edit':
{
require_once("index.class.php");
$objpl=new Product();
$objpl->add_edit(fetch_details('product','product_id',$_REQUEST['id']));
}
break;
case 'save_key':
{
$data = $_POST;
/* echo '';
print_r($_POST);
echo ' '; */
$data['supplier_invoice_date'] = date("Y-m-d",strtotime($data['supplier_invoice_date']));
if(trim($data['supplier_code'])=='')
{ echo 'Error : Please Select Supplier Name ! ';
return;
}
/* if(trim($data['store_name'])=='')
{ echo 'Error : Please Select Store ! ';
return;
} */
if(trim($data['supplier_have_supplier_invoice_no'])=='')
{ echo 'Error : Select supplier have invoice or not? ';
return;
}
if(trim($data['supplier_invoice_no'])=='' and $data['supplier_have_supplier_invoice_no']>0)
{ echo 'Error : Select enter invoice Number? ';
return;
}
if(trim($data['supplier_invoice_date'])=='' and $data['supplier_have_supplier_invoice_no']>0)
{
echo 'Error : Select enter invoice date? ';
return;
}
$data['supplier_code'] = trim($data['supplier_code']);
$data['store_id'] = trim($data['store_name']);
$s = "select * from product_style_master where name ='".trim($data['product_style_code'])."'";
$r = mysql_query($s);
$ro = mysql_fetch_assoc($r);
if($ro['code']>0)
$data['product_style_code'] = $ro['code'];
else
{
echo 'Error : Product style code does not exits or not selected ';
return;
}
// die();
// get category code
$getCat = "Select cat_code from menu_category where code='".trim($data['menu_category'])."'";
$category = mysql_query($getCat);
$catCode = mysql_fetch_row($category);
// get last product code
$getCat = "Select cat_code from menu_category where code='".trim($data['menu_category'])."'";
$category = mysql_query($getCat);
$catCode = mysql_fetch_row($category);
$getProductId = "SELECT product_id from product ORDER BY product_id DESC";
$productCode = mysql_query($getProductId);
$pCode = mysql_fetch_row($productCode);
$productCode = (!empty($pCode[0]) ? ($pCode[0]+1) :0);
$productSku = 'JS'.$catCode[0].$productCode;
// product_category_id
if($_REQUEST['is_stock']==1)
{
if(trim($data['certificate_number'])=='')
{ echo '0|0|Error : Enter Certificate Number!! ';
return;
}
/* if(trim($data['product_ccode'])=='')
{ echo '0|0|Error : Enter Product Code!! ';
return;
} */
if(!check_duplicate_where('product','product_ccode',trim($productSku),$_REQUEST['id'],'product_id'," and is_deleted=0 "))
{
echo 'Error : Duplicate Product code/SKU!! ';
return;
}
if(!check_duplicate_where('product','certificate_number',trim($data['certificate_number']),$_REQUEST['id'],'product_id'," and is_deleted=0 "))
{
echo 'Error : Duplicate Certificate Number!! ';
return;
}
}
$data['product_sale_inside']=1;
/*if(count($data['menu_category'])==0)
{ echo '0|0|Error : Select atleast one category!! ';
return;
}*/
if($data['menu_category']<=0)
{ echo '0|0|Error : Select atleast one category!! ';
return;
}
/*if(count($data['diamond_type_code'])==0)
{ echo '0|0|Error : Select Diamond Customization!! ';
return;
}*/
if(($data['diamond_type_default'])<=0)
{ echo '0|0|Error : Select Default Diamond Type!! ';
return;
}
/*if(count($data['metal_type_code'])==0)
{ echo '0|0|Error : Select Metal Customization!! ';
return;
}*/
if(($data['metal_type_default'])<=0)
{ echo '0|0|Error : Select Default Metal Type!! ';
return;
}
if(($data['gems'])>0)
{
if(($data['gems_type_default'])<=0)
{ echo '0|0|Error : Select Gem stone Type!! ';
return;
}
}
$metalCals = (trim($data['metal_weight']) * 0.15);
// check if products is out of calculationi
if(empty(trim($data['flag'])) && $metalCals > trim($data['diamond_total_weight'])){
$data['flag'] = 1;
echo ' Product is out of company calculation criteria, Please accept and proceed !! ';
return;
}
// metal_weight diamond_total_weight
/*if(count($data['product_size_code'])==0)
{ echo '0|0|Error : Select Size Customization!! ';
return;
}*/
//$data['product_size_default'] = 10;
if(($data['product_size_default'])<=0)
{ echo '0|0|Error : Select Default Size!! ';
return;
}
$data['free_shipping'] = (!empty($_POST['free_shipping']) ? trim($_POST['free_shipping']) :0);
$data['is_stock'] = (!empty($_POST['is_stock']) ? trim($_POST['is_stock']) :0);
$data['is_featured_product'] = (!empty($_POST['is_featured_product']) ? trim($_POST['is_featured_product']) :0);
$data['is_new'] = (!empty($_POST['is_new']) ? trim($_POST['is_new']) :0);
$data['sku'] = $productSku;
$data['product_ccode'] = $productSku;
$data['product_category_id'] = trim($data['menu_category']);
$data['shipping_sku_name'] = $productSku;
$data['client_id'] = (!empty($_SESSION['client_id']) ? $_SESSION['client_id']:0);
$data['sp_description'] = (!empty($_POST['description']) ? $_POST['description']:0);
$data['weight'] = (!empty($_POST['total_item_weight']) ? $_POST['total_item_weight']:0);
if(!empty($data['gems'])){
$data['gem_price'] = trim($data['gem_price']);
$data['gems_size'] = trim($data['gems_size']);
$data['gems_total_no'] = trim($data['gems_total_no']);
$data['gems_shape'] = trim($data['gems_shape']);
$data['gems_setting_type'] = trim($data['gems_setting_type']);
}else{
$data['gem_price'] = 0;
$data['gems_size'] = 0;
$data['gems_total_no'] = 0;
$data['gems_shape'] = 0;
$data['gems_setting_type'] = 0;
}
if(trim($data['product_title'])=="")
$data['product_title'] = strtolower($data['product_name']);
$data['product_title'] = str_replace(""","inch",$data['product_title']);
$data['product_title'] = str_replace(" "," ",$data['product_title']);
$data['product_title'] = str_replace(" "," ",$data['product_title']);
$data['product_title'] = str_replace(" "," ",$data['product_title']);
$data['product_title'] = str_replace(" ","-",$data['product_title']);
$data['product_title'] = str_replace('"',"inch",$data['product_title']);
$data['product_title'] = str_replace("'","feet",$data['product_title']);
$data['product_title'] = strtolower(clean($data['product_title']));
$data['product_name_crm'] = strtolower(clean($data['product_title']));
/*if(check_duplicate_where('product','product_name',trim($data['product_name']),$_REQUEST['id'],'product_id'," and is_deleted=0 "))
{*/
// gem_price gems
$n = count($data);
$i = 1;
$key = array_keys($data);
$j = 1;
while($i<=($n))
{
if($key[$i]<>"chbox" AND $key[$i]<>"photoimg" AND $key[$i]<>"id" AND $key[$i]<>"upload_pic" AND $key[$i]<>"task2" AND $key[$i]<>"status" AND $key[$i]<>"task_n" AND $key[$i]<>"task" AND $key[$i]<>"picture" AND $key[$i]<>"menu_category" AND $key[$i]<>"" AND $key[$i]<>"code" AND $key[$i]<>"group_specification" AND $key[$i]<>"diamond_type_code" AND
$key[$i]<>"metal_type_code_w" AND $key[$i]<>"metal_type_code" AND $key[$i]<>"supplier" AND
$key[$i]<>"product_size_code_weight" AND $key[$i]<>"product_size_code" AND
$key[$i]<>"product_size_code_width" AND
$key[$i]<>"product_size_code_height" AND
$key[$i]<>"product_size_code_making_charges" AND
$key[$i]<>"gems_type_code" AND
$key[$i]<>"gems_type_code_price" AND
$key[$i]<>"store_name" AND
$key[$i]<>"op" AND substr($key[$i],0,5)<>"cat__" AND substr($key[$i],0,4)<>"mce_" AND substr($key[$i],0,4)<>"null")
{
if($j==1)
{ $s = " SET $key[$i] = '".trim($data[$key[$i]])."' ";
$j++;
}
else
$s = $s.",$key[$i] = '".mysql_real_escape_string(trim($data[$key[$i]]))."' ";
}
$i++;
}
$s = $s.",status = '".mysql_real_escape_string(trim($data['status']))."' ";
$s = $s.",admin_id = '".(!empty($_SESSION['admin_code']) ?$_SESSION['admin_code'] :0)."' ";
if($data['task2']=="Add")
{
$s = $s.",sort_id = '".(find_sort_id_max_gn("product")+10)."' ";
$s = "INSERT INTO product ".$s;
}else{
$s = "UPDATE product ".$s;
$s = $s." WHERE product_id='".$data['id']."'";
}
//echo $data['gems'].' -- '.$s;
if(mysql_query($s))
{
$id = mysql_insert_id();
if($data['id']>0)
{ $_SESSION['pcode'] = $data['id'];
$id = $data['id'];
}else{
$_SESSION['pcode'] = $id;
}
$s = " delete from product_variations where product_code='".$id."' ";
mysql_query($s);
if(count($data['op'])>0)
{
foreach($data['op'] as $r)
{
if($r<>"")
{
$s2 = " INSERT INTO product_variations SET product_code='".$id."',variation='".$r."'";
mysql_query($s2);
}
}
}
$s = " delete from menu_category_codes where product_code='".$id."' ";
mysql_query($s);
/*if(count($data['menu_category'])>0)
{
foreach($data['menu_category'] as $r)
{*/
$s2 = " INSERT INTO menu_category_codes SET product_code='".$id."',category='".$data['menu_category']."'";
mysql_query($s2);
/*}
} */
/*$s = " delete from diamond_type_code where product_code='".$id."' ";
mysql_query($s);
if(count($data['diamond_type_code'])>0)
{
foreach($data['diamond_type_code'] as $r)
{
$s2 = " INSERT INTO diamond_type_code SET product_code='".$id."',diamond_type_code='".$r."'";
mysql_query($s2);
}
} */
/*$s = " delete from metal_type_code where product_code='".$id."' ";
mysql_query($s);
if(count($data['metal_type_code'])>0)
{
foreach($data['metal_type_code'] as $r)
{
$s2 = " INSERT INTO metal_type_code SET product_code='".$id."',metal_type_code='".$r."',weight='".$data['metal_type_code_w'][$r]."'";
//echo 'Record Inserted successfully!! ';
}else
echo 'Record Updated successfully!! ';
}else{
echo 'Error : in Updation!! ';
}
/*}
else
{
echo 'Error : Duplicate Product Name!! ';
}*/
}
break;
case 'clone_product':
{
$data = $_POST;
$sql = "Select * from product where product_ccode='".$data['product_code_old']."' and is_deleted=0";
$rr = mysql_query($sql);
$row = mysql_fetch_assoc($rr);
if($row['product_id']<=0)
{
echo '0|0|Error: Old Product Code Not Exist';
return;
}
if(trim($data['product_code_new'])=='')
{
echo '0|0|Error: Enter New Product code';
return;
}
$sql2 = "Select * from product where product_ccode='".$data['product_code_new']."' and is_deleted=0";
$rr2 = mysql_query($sql2);
$row2 = mysql_fetch_assoc($rr2);
if($row2['product_id']>0)
{
echo '0|0|Error: Product Code Already Exist';
return;
}
$old_id = $row['product_id'];
$id = DuplicateMySQLRecord ('product', 'product_id', $row['product_id'],'product_ccode',trim($data['product_code_new']));
$sql = "Select * from product_extra_table where product_code='".$old_id."' ";
//echo 'Error : in Updation!! ';
return true;
}
}
echo 'Error : Can\'t Delete record!! ';
}
break;
//Events
case'Product_eventsDetails':
{
$_SESSION['pcode'] =$pcode=$_REQUEST["pcode"];
$s = "SELECT * FROM product WHERE product_id='".$pcode."'";
$r = mysql_query($s);
$prod = mysql_fetch_assoc($r);
$q = "SELECT * FROM product_pictures WHERE product_code='".$pcode."' ORDER BY code ";
$qr = mysql_query($q) or die('Error: '.mysql_error());
?>
Product Product Code : Go Back
(+) Add New Picture
Picture
Title
Alternate Text
SID
Is main?
>
Edit
|
Pagination Finish
}
break;
case'GernalDetails2':
{
$q = "SELECT * FROM ".TABLE_NAME2." WHERE product_code='".$_REQUEST['p_code']."' ORDER BY sort_website,code ";
$p['task'] = 'GernalDetails2';
$p['div'] = 'main_result_div';
$p['response_file'] = 'response_index';
//$q .= " LIMIT ".$p['Page_Start'].",".$p['Per_Page']." ";
//end of Pageing
$qr = mysql_query($q) or die('Error: '.mysql_error());
?>
Pagination Finish
}
break;
case 'moveFAQ2':
{
//print_r($_REQUEST);
moveGernal(TABLE_NAME2,$_REQUEST['id'],$_REQUEST['direction']);
}
break;
case'size_display':
{
require_once("index.class.php");
$objpl=new Product();
$objpl->size_display($_REQUEST['product_code'],$_REQUEST['cat']);
}
break;
case 'add_edit2':
{
require_once("index.class.php");
$objpl=new Product();
$objpl->add_edit2(fetch_details('product_pictures','code',$_REQUEST['id']));
}
break;
case 'save_key2':
{
$data = $_POST;
// print_r($data);
if(check_duplicate_where('product_pictures','title_picture',trim($data['title_picture']),$_REQUEST['id'],'code'," and product_code='".$data['product_code']."'"))
{
$n = count($data);
$i = 1;
$key = array_keys($data);
$j = 1;
while($i<=($n-2))
{
if($key[$i]<>"chbox" AND $key[$i]<>"photoimg" AND $key[$i]<>"id" AND $key[$i]<>"upload_pic" AND $key[$i]<>"upload_pic2" AND $key[$i]<>"task2" AND $key[$i]<>"task_n" AND $key[$i]<>"task" AND $key[$i]<>"picture" AND $key[$i]<>"picture2" AND $key[$i]<>"status" AND $key[$i]<>"photoimg" AND $key[$i]<>"" )
{
if($j==1)
{
$s = " SET $key[$i] = '".trim($data[$key[$i]])."' ";
$j=2;
}
else
$s = $s.",$key[$i] = '".mysql_real_escape_string(trim($data[$key[$i]]))."' ";
}
$i++;
}
$s = $s.",product_code = '".$data['pcode']."' ";
if($data['task2']=="Add")
{
//$s = $s.",sort_id = '".(find_sort_id_max_gn("product_pictures")+10)."' ";
$s = "INSERT INTO product_pictures ".$s;
}
else
{
$s = "UPDATE product_pictures ".$s;
$s = $s." WHERE code='".$data['id']."'";
}
//echo $s;
if(mysql_query($s))
{
$id = mysql_insert_id();
if($data['id']>0)
$id = $data['id'];
if($data['is_main']==1)
{
$s = "UPDATE product_pictures SET is_main=0 WHERE product_code = '".$data['product_code']."' and not code='".$data['id']."'";
mysql_query($s);
/* $s = "UPDATE product_pictures SET is_main=0 WHERE code='".$data['id']."'";
mysql_query($s);
*/
}
if($data['picture']<>"")
{
$sql = "Select * from raw_pictures where code = '".$data['picture']."'";
$res = mysql_query($sql);
$rows = mysql_fetch_assoc($res);
$pic = $rows['image'];
$iid = $rows['product_id'];
copy('../ajaximage/uploads/'.$pic,'../../../product_images/'.$pic);
unlink('../ajaximage/uploads/'.$pic);
copy('../ajaximage/uploads/'.'sub_'.$pic,'../../../product_images/'.'sub_'.$pic);
unlink('../ajaximage/uploads/'.'sub_'.$pic);
$sql = "Update product_pictures SET pic_name='".$pic."' where code = '".$id."' ";
$res = mysql_query($sql);
$sql = "Delete FROM raw_pictures where code = '".$iid."' or date <= '".date("Y-m-d",strtotime("-2 Days"))."'";
$res = mysql_query($sql);
}
if($data['task2']=="Add")
echo 'Record Inserted successfully!! ';
else
echo 'Record Updated successfully!! ';
}
else
echo 'Error : in Updation!! ';
}
else
echo 'Duplicate Title !! ';
}
break;
case 'delete_row2':
{
if($_REQUEST['id']>0)
{
$sql = "delete from product_pictures WHERE code='".$_REQUEST['id']."'";
if(mysql_query($sql))
{ echo 'Deleted Successfully';
return true;
}
else
{ echo 'Error : in Updation!! ';
return true;
}
}
echo 'Error : Can\'t Delete record!! ';
}
break;
// Extra Product Details
case'Product_extraDetails':
{
$_SESSION['pcode'] =$pcode=$_REQUEST["pcode"];
$s = "SELECT * FROM product WHERE product_id='".$pcode."'";
$r = mysql_query($s);
$prod = mysql_fetch_assoc($r);
$q = "SELECT * FROM product_extra_table WHERE product_code='".$pcode."' ORDER BY title ";
$qr = mysql_query($q) or die('Error: '.mysql_error());
?>
Product Code : Go Back
(+) Add New Product Extra Values
Extra Title
Extra Description
>
Edit
|
Pagination Finish
}
break;
case 'add_edit3':
{
require_once("index.class.php");
$objpl=new Product();
$objpl->add_edit3(fetch_details('product_extra_table','code',$_REQUEST['id']));
}
break;
case 'save_key3':
{
$data = $_POST;
//print_r($data);
if(check_duplicate_where('product_extra_table','title',trim($data['title']),$_REQUEST['id'],'code'," and product_code='".$data['product_code']."'"))
{
$n = count($data);
$i = 1;
$key = array_keys($data);
$j = 1;
while($i<=($n-2))
{
if($key[$i]<>"chbox" AND $key[$i]<>"photoimg" AND $key[$i]<>"id" AND $key[$i]<>"upload_pic" AND $key[$i]<>"task2" AND $key[$i]<>"task_n" AND $key[$i]<>"task" AND $key[$i]<>"picture" AND $key[$i]<>"status" AND $key[$i]<>"photoimg" AND $key[$i]<>"" )
{
if($j==1)
{
$s = " SET $key[$i] = '".trim($data[$key[$i]])."' ";
$j=2;
}
else
$s = $s.",$key[$i] = '".mysql_real_escape_string(trim($data[$key[$i]]))."' ";
}
$i++;
}
$s = $s.",product_code = '".$data['product_code']."' ";
if($data['task2']=="Add")
{
//$s = $s.",sort_id = '".(find_sort_id_max_gn("product_extra_table")+10)."' ";
$s = "INSERT INTO product_extra_table ".$s;
}
else
{
$s = "UPDATE product_extra_table ".$s;
$s = $s." WHERE code='".$data['id']."'";
}
if(mysql_query($s))
{
$id = mysql_insert_id();
if($data['id']>0)
$id = $data['id'];
if($data['task2']=="Add")
echo 'Record Inserted successfully!! ';
else
echo 'Record Updated successfully!! ';
}
else
echo 'Error : in Updation!! ';
}
else
echo 'Duplicate Product Extra Title!! ';
}
break;
case 'delete_row3':
{
if($_REQUEST['id']>0)
{
$sql = "delete from product_extra_table WHERE code='".$_REQUEST['id']."'";
if(mysql_query($sql))
{ echo '';
return true;
}
else
{ echo 'Error : in Updation!! ';
return true;
}
}
echo 'Error : Can\'t Delete record!! ';
}
break;
//End of Extra Product Details
// Extra Specification Details
case'spc_list':
{
echo create_select('specification','specification_title','specification','',$data['specification'],'mandatory',$code="code","--Select Specification --","","","",""," and is_deleted=0 and specification_category_id='".$_REQUEST['specification_category_id']."'");
}break;
case'Product_specificationDetails':
{
$_SESSION['pcode'] =$pcode=$_REQUEST["pcode"];
$s = "SELECT * FROM product WHERE product_id='".$pcode."'";
$r = mysql_query($s);
$prod = mysql_fetch_assoc($r);
$q = " SELECT specification_title,a.*,category_name FROM specification_code a,specification b,specification_category c WHERE a.specification=b.code and product_code='".$pcode."' and b.specification_category_id=c.specification_category_id ORDER BY c.sort_id,b.sort_id ";
$qr = mysql_query($q) or die('Error: '.mysql_error());
?>
Product Code : Go Back
(+) Add New Product Specification
Category
Specification
Value
>
Edit
|
Pagination Finish
}
break;
case 'add_edit4':
{
require_once("index.class.php");
$objpl=new Product();
$objpl->add_edit4(fetch_details('specification_code','code',$_REQUEST['id']));
}
break;
case 'save_key4':
{
$data = $_POST;
if(check_duplicate_where('specification_code','specification',trim($data['specification']),$_REQUEST['id'],'code'," and product_code='".$data['product_code']."'"))
{
$n = count($data);
$i = 1;
$key = array_keys($data);
$j = 1;
while($i<=($n-2))
{
if($key[$i]<>"chbox" AND $key[$i]<>"photoimg" AND $key[$i]<>"id" AND $key[$i]<>"upload_pic" AND $key[$i]<>"task2" AND $key[$i]<>"task_n" AND $key[$i]<>"task" AND $key[$i]<>"picture" AND $key[$i]<>"status" AND $key[$i]<>"photoimg" AND $key[$i]<>"specification_category_id" AND $key[$i]<>"" )
{
if($j==1)
{
$s = " SET $key[$i] = '".trim($data[$key[$i]])."' ";
$j=2;
}
else
$s = $s.",$key[$i] = '".mysql_real_escape_string(trim($data[$key[$i]]))."' ";
}
$i++;
}
$s = $s.",product_code = '".$data['product_code']."' ";
if($data['task2']=="Add")
{
//$s = $s.",sort_id = '".(find_sort_id_max_gn("product_extra_table")+10)."' ";
$s = "INSERT INTO specification_code ".$s;
}
else
{
$s = "UPDATE specification_code ".$s;
$s = $s." WHERE code='".$data['id']."'";
}
//echo $s;
if(mysql_query($s))
{
$id = mysql_insert_id();
if($data['id']>0)
$id = $data['id'];
if($data['task2']=="Add")
echo 'Record Inserted successfully!! ';
else
echo 'Record Updated successfully!! ';
}
else
echo 'Error : in Updation!! ';
}
else
echo 'Duplicate Product Specification!! ';
}
break;
case 'delete_row4':
{
if($_REQUEST['id']>0)
{
$sql = "delete from specification_code WHERE code='".$_REQUEST['id']."'";
if(mysql_query($sql))
{ echo '';
return true;
}
else
{ echo 'Error : in Updation!! ';
return true;
}
}
echo 'Error : Can\'t Delete record!! ';
}
break;
//End of Extra Product Details
// Extra Features Details
case'Product_product_featuresDetails':
{
$_SESSION['pcode'] =$pcode=$_REQUEST["pcode"];
$s = "SELECT * FROM product WHERE product_id='".$pcode."'";
$r = mysql_query($s);
$prod = mysql_fetch_assoc($r);
$q = "SELECT product_features_title,details,c.* FROM product_features_code c,product_features d WHERE c.product_features=d.code and product_code='".$pcode."' ORDER BY product_features_title";
$qr = mysql_query($q) or die('Error: '.mysql_error());
?>
Product Code : Go Back
(+) Add New Product Features
Features
Details
>
Edit
|
Pagination Finish
}
break;
case 'add_edit5':
{
require_once("index.class.php");
$objpl=new Product();
$objpl->add_edit5(fetch_details('product_features_code','code',$_REQUEST['id']));
}
break;
case 'save_key5':
{
$data = $_POST;
//print_r($data);
if(check_duplicate_where('product_features_code','product_features',trim($data['product_features']),$_REQUEST['id'],'code'," and product_code='".$data['product_code']."'"))
{
$n = count($data);
$i = 1;
$key = array_keys($data);
$j = 1;
while($i<=($n-2))
{
if($key[$i]<>"chbox" AND $key[$i]<>"photoimg" AND $key[$i]<>"id" AND $key[$i]<>"upload_pic" AND $key[$i]<>"task2" AND $key[$i]<>"task_n" AND $key[$i]<>"task" AND $key[$i]<>"picture" AND $key[$i]<>"status" AND $key[$i]<>"photoimg" AND $key[$i]<>"" )
{
if($j==1)
{
$s = " SET $key[$i] = '".trim($data[$key[$i]])."' ";
$j=2;
}
else
$s = $s.",$key[$i] = '".mysql_real_escape_string(trim($data[$key[$i]]))."' ";
}
$i++;
}
$s = $s.",product_code = '".$data['product_code']."' ";
if($data['task2']=="Add")
{
//$s = $s.",sort_id = '".(find_sort_id_max_gn("product_extra_table")+10)."' ";
$s = "INSERT INTO product_features_code ".$s;
}
else
{
$s = "UPDATE product_features_code ".$s;
$s = $s." WHERE code='".$data['id']."'";
}
if(mysql_query($s))
{
$id = mysql_insert_id();
if($data['id']>0)
$id = $data['id'];
if($data['task2']=="Add")
echo 'Record Inserted successfully!! ';
else
echo 'Record Updated successfully!! ';
}
else
echo 'Error : in Updation!! ';
}
else
echo 'Duplicate Product Features!! ';
}
break;
case 'delete_row5':
{
if($_REQUEST['id']>0)
{
$sql = "delete from product_features_code WHERE code='".$_REQUEST['id']."'";
if(mysql_query($sql))
{ echo '';
return true;
}
else
{ echo 'Error : in Updation!! ';
return true;
}
}
echo 'Error : Can\'t Delete record!! ';
}
break;
};
}
function clean($string) {
$string = str_replace(' ', '-', $string); // Replaces all spaces with hyphens.
return preg_replace('/[^A-Za-z0-9\-]/', '', $string); // Removes special chars.
}
function DuplicateMySQLRecord ($table, $id_field, $id,$extra_feild,$extra_value) {
// load the original record into an array
$result = mysql_query("SELECT * FROM {$table} WHERE {$id_field}={$id}");
$original_record = mysql_fetch_assoc($result);
// insert the new record and get the new auto_increment id
mysql_query("INSERT INTO {$table} (`{$id_field}`) VALUES (NULL)");
$newid = mysql_insert_id();
// generate the query to update the new record with the previous values
$query = "UPDATE {$table} SET ";
foreach ($original_record as $key => $value) {
if ($key != $id_field)
{
if($extra_feild==$key)
$query .= '`'.$extra_feild.'` = "'.str_replace('"','\"',$extra_value).'", ';
else
$query .= '`'.$key.'` = "'.str_replace('"','\"',$value).'", ';
}
}
$query = substr($query,0,strlen($query)-2); // lop off the extra trailing comma
$query .= " WHERE {$id_field}={$newid}";
mysql_query($query);
// return the new id
return $newid;
}
?>
|