Session Out!! Relogin Please'; return; } require_once("../../common_pages/enc.php"); $converter = new Encryption($_SESSION['unique_enc_id']); ?> ","min",$id); if($a!="") { $ccode = find_sort_id_code($table,$a); $ssi = find_sort_id($table,$id); $qry = "Update ".$table." set sort_id='".$a."' where code='".$id."'"; mysql_query($qry); $qry = "Update ".$table." set sort_id='".$ssi."' where code='".$ccode."'"; mysql_query($qry); } return true; } function find_sort_id($tb,$id) { $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['code']; } } 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_gernals($pcode) { $sql = "SELECT count(*) as c FROM gernal_value WHERE client_id = '".$_SESSION['client_id']."' style_code='".$pcode."' "; $res = mysql_query($sql); $rows = mysql_fetch_assoc($res); return (int)$rows['c']; } // print_r($_REQUEST); switch($_REQUEST['task']) { case'GernalDetails': { //var_dump($_REQUEST); //echo $_REQUEST['page']; $searchtext = mysql_real_escape_string($_REQUEST['searchtext']); //$prtstatus = $_REQUEST['status']; //$prtcat = $_REQUEST['instructions']; $searchtext = trim($searchtext); $where = ''; $fields = array('name','details'); if(!empty($searchtext)) { foreach($fields as $field) { if($where=="") $where = ' AND ( '; else $where .= ' OR '; $where .= $field." LIKE '%".$searchtext."%' "; } $where .=')'; } $q = "SELECT * FROM sale_employee_brm WHERE is_deleted =0 $where ORDER BY sort_id "; if($_REQUEST['page']>=1) $_SESSION['page'] = $_REQUEST['page']; if($_REQUEST['page']=='undefined') $_SESSION['page'] = 1; //Paging New Script // $p = paging_prepare($q,$_SESSION['page']); $p['task'] = 'GernalDetails'; $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 Branch
Name Address Status Action
0 ? 'Active' : 'Inactive'); ?> Edit   |  
add_edit(fetch_details('sale_employee_brm','code',$_REQUEST['id'])); } break; case 'save_key': { $data = $_POST; if(check_duplicate_where('sale_employee_brm','name',trim($data['name']),$_REQUEST['id'],'code'," and is_deleted=0 ")) { $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]<>"task_n" AND $key[$i]<>"task" AND $key[$i]<>"picture" AND $key[$i]<>"" AND $key[$i]<>"code" AND $key[$i]<>"group") { 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.",admin_id = '".$_SESSION['admin_code']."' "; $s = $s.",client_id = '".(!empty($_SESSION['client_id']) ? $_SESSION['client_id'] : $_SESSION['admin_code'])."' "; if($data['task2']=="Add") { $s = $s.",sort_id = '".(find_sort_id_max_gn("sale_employee_brm")+1)."' "; $s = "INSERT INTO sale_employee_brm ".$s; }else{ $s = "UPDATE sale_employee_brm ".$s; $s = $s." WHERE code='".$data['id']."'"; } //print_r($_REQUEST); //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 'Error : Duplicate Data!!'; } } break; case 'delete_row': { if($_REQUEST['id']>0) { $sql = "update sale_employee_brm SET is_deleted=1 WHERE code='".$_REQUEST['id']."'"; if(mysql_query($sql)) { echo ''; return true; } else { echo 'Error : in deletion!!'; return true; } } echo 'Error : Can\'t Delete record!!'; } break; //Events case'Gernal_eventsDetails': { $_SESSION['pcode'] =$pcode=$_REQUEST["pcode"]; $s = "SELECT * FROM metal_type WHERE code='".$pcode."'"; $r = mysql_query($s); $prod = mysql_fetch_assoc($r); $q = "SELECT * FROM gernal_value WHERE style_code='".$pcode."' ORDER BY title "; $qr = mysql_query($q) or die('Error: '.mysql_error()); ?>
Gernal
>
(+) Add New Branch
Branch Name
Edit   |  
Pagination Finish } break; case 'add_edit2': { require_once("index.class.php"); $objpl=new Gernal(); $objpl->add_edit2(fetch_details('gernal_value','code',$_REQUEST['id'])); } break; case 'save_key2': { $data = $_POST; //print_r($data); if(check_duplicate_where('gernal','title',trim($data['title']),$_REQUEST['id'],'code'," and style_code='".$data['style_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.",style_code = '".$data['style_code']."' "; if($data['task2']=="Add") { //$s = $s.",sort_id = '".(find_sort_id_max_gn("gernal_value")+10)."' "; $s = "INSERT INTO gernal_value ".$s; } else { $s = "UPDATE gernal_value ".$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 Gernal Value!!'; } break; case 'delete_row2': { if($_REQUEST['id']>0) { $sql = "delete from gernal_value WHERE code='".$_REQUEST['id']."'"; if(mysql_query($sql)) { echo ''; return true; } else { echo 'Error : in deletion !!'; return true; } } echo 'Error : Can\'t Delete record!!'; } break; }; } ?>