<?php include('techsyn_header.php');?>
<?php include('techsyn_sidebar.php');?>
<!--breadcrumb-->
<div class="sidebar-toggle sidebar-collapse" id="sidebar-collapse">
<i id="sidebar-toggle-icon" class="ace-icon fa fa-angle-double-left ace-save-state" data-icon1="ace-icon fa fa-angle-double-left" data-icon2="ace-icon fa fa-angle-double-right"></i>
</div>
</div>
<div class="main-content">
<div class="main-content-inner">
<!--do not modify anything above-->
<div class="breadcrumbs ace-save-state" id="breadcrumbs">
<ul class="breadcrumb">
<li>
<i class="ace-icon fa fa-home home-icon"></i>
<a href="#">Home</a>
</li>
<li class="#">Masters</li><li class="#">Items</li><li class="active">Item Units</li>
</ul>
</div>
<!-- End of breadcrumb -->
<?php
//include('top.php');
//include_once("includes/css-js/dynamic_add.js");
$TABLENAME='tbl_items';
$TABLENAME2='tbl_categories';
$this_script='manage_items.php';
?>
<!--<link href="includes/css-js/admin.css" rel="stylesheet" type="text/css" />-->
<tr>
<td height="350" valign="top" style="padding:10px;"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><fieldset class="bdr1" >
<legend class="heading1"> Item Management</legend> <center>
<?php
if(isset($acn) && $acn=='delete')
{
if($item_id)
mysqli_query($conn,"DELETE FROM $TABLENAME WHERE item_id='".$item_id."'");
}
if(isset($hid) && $hid=='1')
{
if($frmacn=="Update" && ($item_name!=$item_name_old))
{
mysqli_query($conn,"update tbl_items set item_name='".$item_name."', item_desc=concat('".$item_name."','-',cat,'-',subcat,'-',item_spec) where item_name='".$item_name_old."'") ;
}
if(isset($count_material)){
for($i=0;$i<$count_material;$i++){
if(${"cat".$i}){
if(isset(${"count_submaterial".$i})){
$count_sub=${"count_submaterial".$i};
//echo "sub:".$count_sub;
for($j=0;$j<$count_sub;$j++){
//echo "subcat:".${"subcat".$i.$j};
//if(${"subcat".$i.$j}){
//echo "subcat if passed".$i.$j.":bbbb";
if(isset(${"count_spec".$i.$j})){
$count_spec=${"count_spec".$i.$j};
//echo "spec".$count_spec;
for($k=0;$k<$count_spec;$k++){
if(${"item_specification".$i.$j.$k}){
$item_spec = stripslashes(${"item_specification".$i.$j.$k});
$query_main=" SET item_name='".$item_name."',cat='".${"cat".$i}."',".
"subcat='".${"subcat".$i.$j}."',pl_no='".${"pl_no".$i.$j.$k}."',item_desc='".$item_name."-".${"cat".$i}."-".${"subcat".$i.$j}."-".$item_spec."',remarks='".${"remarks".$i.$j.$k}."', item_spec='".$item_spec."', modified_by='".$_SESSION['user_id']."'";
$query_prefix='';
$query_suffix="";
$query_additional="";
if($frmacn=="Update")
{
$query_prefix='UPDATE ';
$query_suffix=" WHERE item_id='".$item_id."'";
$query_additional="";
$msg=" Item Updated Successfully";
}
elseif($frmacn=="Add")
{
$query_prefix='INSERT INTO ';
$query_suffix="";
$query_additional="";
$msg=" Item Added Successfully";
}
$sql=$query_prefix.$TABLENAME.$query_main.$query_additional.$query_suffix;
//echo $sql;
$res=@mysqli_query($conn,$sql);
if(!$res){
$msg='Error adding/updating the Item Information. Please make sure the item does not already exist'; }
}//end of spec if
}//end of spec for
}
// }//end of sub if
}//end of sub for
}//endof sub material if
}//end of material if
}//end of material for
}//end of second if
echo "<script>location.replace('$this_script?msg=$msg')</script>";
}//end of outer if
?>
<?php if($acn=='add' || $acn=='update' || $acn=='view') { ?>
<?php
if($acn=='update' || $acn=='view')
{
$sql=@mysqli_query($conn,"SELECT * FROM $TABLENAME WHERE item_id='".$item_id."'");
$row=@mysqli_fetch_array($sql);
extract($row);
$item_spec = htmlentities($item_spec);
}
?>
<form name="f1" method="post" action="<?php echo $this_script?>" onsubmit="return validateForm();">
<table class="table table-bordered">
<tr>
<td colspan="2" align="center" class="">
<span class="txt">
<?php
if($msg)
echo $msg;
?>
</span></td>
</tr>
<tr>
<td align="right" class="VerdanaMediumBlack">Item Name:</td>
<td align="left" class="bdr_td"><input name="item_name" type="text" class="textbox2" value="<?php echo htmlentities($item_name)?>" size="20" />
<input name="item_name_old" type="hidden" class="textbox2" value="<?php echo stripslashes($item_name)?>" size="20" /></td>
</tr>
<!-- Start of Material Section-->
<tr>
<td class="bdr_td"> </td>
<td class="bdr_td">
<table id="Material" class="bdr_table" width="100%">
<tr>
<td><table class="bdr_table">
<tr>
<td align="right" class="VerdanaMediumBlack"><input type="checkbox" name="chk_material" value="Y" />Select Material:</td>
<td align="left" class="bdr_td">
<select class="selectbox" name="cat0" onchange="getSubcats(this.value,'subcatlist0',document.forms[0].count_submaterial0.value,0)"/>
<option value="">Select One</option>
<?php
$sql="SELECT cat_id, cat_name FROM $TABLENAME2 where parent_id='0'";
generate_options($sql,$cat,'cat_id','cat_name');
?>
</select> </td>
</tr>
<!--Start of Submaterial section tr-->
<tr>
<td class="bdr_td"> </td>
<td class="bdr_td">
<!--Start of Submaterial section table-->
<table id="submaterial0" width="100%" class="bdr_table">
<tr><td><table class="bdr_table">
<tr>
<td align="right" class="VerdanaMediumBlack">
<input type="checkbox" name="chk_submaterial0" value="Y" />Select Sub-Material:</td>
<td align="left" class="bdr_td">
<div id="subcatlist00">
<select class="selectbox" name="subcat00" />
<?php
$sql="SELECT cat_id, cat_name FROM $TABLENAME2 where parent_id<>'0' AND parent_id='".$cat."'";
generate_options($sql,$subcat,'cat_id','cat_name');
?>
</select>
</div>
</td>
</tr>
<!--Start of spec section tr-->
<tr>
<td> </td>
<td>
<table width="100%" id="spec00" class="bdr_table">
<tr><td><table class="bdr_table">
<tr>
<td align="right" class="VerdanaMediumBlack"><input type="checkbox" name="chk_spec00" value="Y" />Specification Variants</td>
<td align="left" class="bdr_td">
<input type="text" class="textbox2" name="item_specification000" value="<?php echo $item_spec?>" id="item_specification000" /> </td>
</tr>
<tr>
<td align="right" class="VerdanaMediumBlack"></td>
<td align="left" class="bdr_td">
<input type="hidden" class="textbox2" name="pl_no000" value="<?php echo $pl_no?>"/> </td> </tr>
<tr>
<td align="right" class="VerdanaMediumBlack">Remarks:</td>
<td align="left" class="bdr_td">
<textarea name="remarks000" cols="30" rows="6"><?php echo stripslashes($remarks)?></textarea> </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!--end of spec table--> </td>
</tr>
<!--end of spec section tr-->
<tr>
<td colspan="2" align="right" class="bdr_td">
<?php if($acn=='add') { ?>
<input type="button" value="Add Spec" onClick="addSpec(0,0)"/>
<input type="button" value="Remove" onclick="removeSpec(0,0)" />
<?php } ?>
<input type="hidden" name="count_spec00" value="1">
</td>
</tr>
</table>
<!--end of Submaterial section table--> </td>
</tr>
<!--end of Submaterial section tr-->
<tr>
<td colspan="2" align="right"><?php if($acn=='add') { ?>
<input type="button" value="Add Sub Material" onClick="addSubMaterial(0)"/><input type="button" onClick="removeSubMaterial(0,0)" value="Remove" /> <?php } ?> <input type="hidden" name="count_submaterial0" value="1"> <input type="hidden" name="submaterial_values0" > </td>
</tr>
</table>
</td>
</tr>
</table>
<!--end of Material section table--> </td>
</tr>
<!--end of Material section tr-->
<tr>
<td colspan="2" align="right"><?php if($acn=='add') { ?>
<input type="button" value="Add Material" onclick="addMaterial()"/><input type="button" value="Remove" onclick="removeMaterial()" /><?php } ?> </td>
</tr>
<tr>
<td colspan="2" align="center" class="bg3">
<input type="hidden" name="item_id" value="<?php echo $item_id?>">
<input type="hidden" name="hid" value="1">
<input type="hidden" name="count_material" value="1">
<?php if($acn=='update') { ?>
<input type="submit" name="frmacn" value="Update">
<?php } else if($acn=='add') { ?>
<input type="submit" name="frmacn" value="Add">
<?php } ?>
<input type="button" value="Back" onclick="history.back();"> </td>
</tr>
</table>
</form>
<?php } else { ?>
<form name="f1" method="post" action="<?php echo $this_script?>">
<table width="100%" border="0" cellspacing="0" cellpadding="4" class="bdr_table">
<tr class="bg2">
<td colspan="3" align="center"><font color="maroon"> <?php echo $msg?></font></td>
</tr>
<tr class="bg2">
<td align="left" width="4%" ><strong>S.No.</strong></td>
<td align="left" width="16%"><strong>Item Name</strong></td>
<td align="left" width="80%" ><strong>Description</strong></td>
</tr>
<?php
$cont=1;
$sq="SELECT DISTINCT(item_name) FROM $TABLENAME";
$resul = mysqli_query($conn,$sq);
while($rw=@mysqli_fetch_array($resul))
{
extract($rw);
?>
<tr class="bdr_td">
<td align="left" class="bdr_td"> <?php echo $cont?></td>
<td align="center" class="jsptextoutput"><a href="javascript:void(0);" onclick="toggleDiv(<?php echo $cont?>)"><?php echo stripslashes($item_name)?></td>
<td class="jsptextoutput">
<table id="tbl<?php echo $cont?>" width="100%" border="0" cellspacing="0" cellpadding="4" class="bdr_table" style="display:none;">
<tr class="bg2">
<td width="5%" align="left" ><strong>S.No.</strong></td>
<td width="15%" align="center"><strong>Material</strong></td>
<td width="15%" align="center"><strong>Sub-Material</strong></td>
<td width="30%" align="center"><strong>Specification</strong></td>
<td width="20%" align="center"><strong>Remarks</strong></td>
<td width="5%" align="center"><strong>View</strong></td>
<td width="5%" align="center"><strong>Edit</strong></td>
<td width="5%" align="center"><strong>Delete</strong></td>
</tr>
<?php
$count=1;
$sql="SELECT a.*, b.cat_name as cat,c.cat_name as subcat,item_spec FROM tbl_items a LEFT JOIN tbl_categories b ON a.cat=b.cat_id LEFT JOIN tbl_categories c on a.subcat=c.cat_id where item_name = '".$item_name."' order by a.item_id";
$result = mysqli_query($conn,$sql);
while($row=@mysqli_fetch_array($result))
{
extract($row);
?>
<tr class="bdr_td">
<td align="left" class="bdr_td"> <?php echo $count?></td>
<td align="center" class="jsptextoutput"> <?php echo stripslashes($cat)?></td>
<td align="center" class="jsptextoutput"> <?php echo stripslashes($subcat)?></td>
<td align="center" class="jsptextoutput"> <?php echo $item_spec?></td>
<td align="center" class="jsptextoutput"> <?php echo stripslashes($remarks)?></td>
<td align="center" class="bdr_td"> <a href="javascript:void(0);" onclick="javascript:sendpage('<?php echo $this_script?>?acn=view&item_id=<?php echo $item_id?>');"><img src='images/view.jpg' border="0" /></a></td>
<?php
$sql_check_child="SELECT item_id FROM tbl_items WHERE item_id NOT IN (SELECT item_id FROM tbl_tender_items where item_id='".$item_id."' union SELECT item_id FROM purchase_order_details where item_id='".$item_id."' union SELECT item_id FROM purchase_order_details_amendment where item_id='".$item_id."' ) AND item_id = '".$item_id."'";
$res_check_child=@mysqli_query($conn,$sql_check_child);
$num=@mysqli_num_rows($res_check_child);
?>
<td align="center" class="bdr_td"> <a href="javascript:void(0);" onclick="javascript:sendpage('<?php echo $this_script?>?acn=update&item_id=<?php echo $item_id?>');"><img src='images/edit.png' border="0" /></a></td>
<td align="center" class="bdr_td"> <?php if($num>0){ ?> <a href="javascript:void(0);" onclick="javascript:deleterecord('<?php echo $this_script?>?acn=delete&item_id=<?php echo $item_id?>');"><img src='images/drop.png' border="0" /></a><?php } ?></td>
</tr>
<?php
$count++;
} ?>
</table>
</td>
</tr>
<?php
$cont++;
} ?>
<tr>
<td colspan="10" align="right">
<span>
<a href="pdf_items.php" target="_blank">Print</a>
</span>
<input type="button" onclick="window.location.href='manage_items.php?acn=add'" value="Add New">
</td>
</tr>
</table>
</form>
<?php } ?>
</center>
</fieldset>
</td>
</tr>
</table></td>
</tr>
<?php include('footer.php'); ?>
<script>
var fieldArray = new Array(
new Array('item_name'), new Array('Please enter Item Name.'));
function validateForm(){
return checkform('f1',fieldArray);
}
function addMaterial(){
var count=document.forms[0].count_material.value;
var tbl=document.getElementById('Material');
var lastRow = tbl.rows.length;
var newRow = tbl.insertRow(lastRow);
var divContent ="<td><table class=\"bdr_table\"><tr> <td align=\"right\" class=\"VerdanaMediumBlack\"><input type=\"checkbox\" name=\"chk_material\" value=\"Y\" />Select Material:</td>"+
" <td align=\"left\" class=\"bdr_td\">"+
" <select class=\"selectbox\" name=\"cat"+count+"\" onchange=\"getSubcats(this.value,'subcatlist"+count+"',document.forms[0].count_submaterial"+count+".value,"+count+")\"/>"+
" <option value=\"\">Select One</option>"+
"<?php
$sql="SELECT cat_id, cat_name FROM $TABLENAME2 where parent_id='0'";
generate_options($sql,$cat,'cat_id','cat_name');
?>"+
"</select> </td>"+
"</tr>"+
"<tr>"+
"<td class=\"bdr_td\"> </td>"+
" <td class=\"bdr_td\">"+
" <table id=\"submaterial"+count+"\" width=\"100%\" class=\"bdr_table\">"+
" <tr><td><table class=\"bdr_table\"><tr>"+
" <td align=\"right\" class=\"VerdanaMediumBlack\">"+
" <input type=\"checkbox\" name=\"chk_submaterial"+count+"\" value=\"Y\" />Select Sub-Material:</td>"+
" <td align=\"left\" class=\"bdr_td\">"+
" <div id=\"subcatlist"+count+"0\">"+
" <select class=\"selectbox\" name=\"subcat"+count+"0\" />"+
" <?php
$sql="SELECT cat_id, cat_name FROM $TABLENAME2 where parent_id<>'0' AND parent_id='".$cat."'";
generate_options($sql,$subcat,'cat_id','cat_name');
?>"+
"</select>"+
" </div>"+
" </td>"+
" </tr>"+
" <tr>"+
" <td> </td>"+
" <td>"+
" <table width=\"100%\" id=\"spec"+count+"0\" class=\"bdr_table\">"+
" <tr><td><table class=\"bdr_table\"><tr>"+
" <td align=\"right\" class=\"VerdanaMediumBlack\"><input type=\"checkbox\" name=\"chk_spec"+count+"0\" value=\"Y\" />Specification Variants</td>"+
" <td align=\"left\" class=\"bdr_td\">"+
" <input type=\"text\" class=\"textbox2\" name=\"item_specification"+count+"00\" id=\"item_specification"+count+"00\" /> </td>"+
" </tr>"+
" <tr>"+
"<td align=\"right\" class=\"VerdanaMediumBlack\"></td>"+
" <td align=\"left\" class=\"bdr_td\">"+
" <input type=\"hidden\" class=\"textbox2\" name=\"pl_no"+count+"00\" value=\"\"/> </td>"+
" </tr>"+
" <tr>"+
" <td align=\"right\" class=\"VerdanaMediumBlack\">Remarks:</td>"+
" <td align=\"left\" class=\"bdr_td\">"+
" <textarea name=\"remarks"+count+"00\" cols=\"30\" rows=\"6\"></textarea> </td>"+
" </tr></table></td></tr>"+
" </table>"+
" </td>"+
" </tr> "+
" <tr>"+
" <td colspan=\"2\" align=\"right\" class=\"bdr_td\"><input type=\"button\" value=\"Add Spec\" onClick=\"addSpec("+count+",0)\"/><input type=\"button\" value=\"Remove\" onClick=\"removeSpec("+count+",0)\"/> <input type=\"hidden\" value=\"1\" name=\"count_spec"+count+"0\"> </td>"+
" </tr>"+
" </table>"+
"</td>"+
"</tr> </table></td></tr>"+
"<tr>"+
" <td colspan=\"2\" align=\"right\">"+
" <input type=\"button\" value=\"Add Sub Material\" onClick=\"addSubMaterial("+count+")\"/><input type=\"button\" value=\"Remove\" onClick=\"removeSubMaterial("+count+")\" /> <input type=\"hidden\" name=\"count_submaterial"+count+"\" value=\"1\"> <input type=\"hidden\" name=\"submaterial_values"+count+"\" value=\"1\"> </td></tr></table></td>";
newRow.innerHTML=divContent;
//alert(document.getElementById('Material'));
eval('document.forms[0].count_material.value='+parseInt(++count)+'');
applycss();
}
function addSubMaterial(mindex){
var count=parseInt(eval('document.forms[0].count_submaterial'+mindex+'.value'));
var tbl=eval("document.getElementById('submaterial"+mindex+"')");
var lastRow = tbl.rows.length;
var newRow = tbl.insertRow(lastRow);
var divContent="";
divContent= "<td><table class=\"bdr_table\"><tr><td align=\"right\" class=\"VerdanaMediumBlack\">"+
" <input type=\"checkbox\" name=\"chk_submaterial"+mindex+"\" value=\"Y\" />Select Sub-Material:</td>"+
" <td align=\"left\" class=\"bdr_td\">"+
"<div id=\"subcatlist"+mindex+count+"\">"+
"<select class=\"selectbox\" name=\"subcat"+mindex+count+"\" />"+
eval("document.forms[0].submaterial_values"+mindex+".value")+
" </select>"+
"</div>"+
"</td>"+
"</tr>"+
"<tr>"+
"<td> </td>"+
"<td>"+
"<table width=\"100%\" id=\"spec"+mindex+count+"\" class=\"bdr_table\">"+
"<tr><td><table class=\"bdr_table\"><tr>"+
"<td align=\"right\" class=\"VerdanaMediumBlack\"><input type=\"checkbox\" name=\"chk_spec"+mindex+count+"\" value=\"Y\" />Specification Variants</td>"+
" <td align=\"left\" class=\"bdr_td\">"+
" <input type=\"text\" class=\"textbox2\" name=\"item_specification"+mindex+count+"0\" id=\"item_specification0\" /> </td>"+
" </tr>"+
" <tr>"+
" <td align=\"right\" class=\"VerdanaMediumBlack\"></td>"+
" <td align=\"left\" class=\"bdr_td\">"+
" <input type=\"hidden\" class=\"textbox2\" name=\"pl_no"+mindex+count+"0\" value=\"\"/> </td>"+
" </tr>"+
" <tr>"+
" <td align=\"right\" class=\"VerdanaMediumBlack\">Remarks:</td>"+
" <td align=\"left\" class=\"bdr_td\">"+
" <textarea name=\"remarks"+mindex+count+"0\" cols=\"30\" rows=\"6\"></textarea> </td>"+
" </tr></table></td></tr>"+
" </table>"+
"</td>"+
"</tr> "+
"<tr>"+
" <td colspan=\"2\" align=\"right\" class=\"bdr_td\"><input type=\"button\" value=\"Add Spec\" onClick=\"addSpec("+mindex+","+count+")\"/><input type=\"button\" value=\"Remove\" onClick=\"removeSpec("+mindex+","+count+")\"/> <input type=\"hidden\" name=\"count_spec"+mindex+count+"\" value=\"1\"></td></tr></table></td>";
newRow.innerHTML=divContent;
eval('document.forms[0].count_submaterial'+mindex+'.value='+parseInt(count+1)+'');
applycss();
}
function addSpec(mindex, smindex){
var count=eval('document.forms[0].count_spec'+mindex+smindex+'.value');
var tbl=eval("document.getElementById('spec"+mindex+smindex+"')");
var lastRow = tbl.rows.length;
var newRow = tbl.insertRow(lastRow);
var divContent ="<td><table class=\"bdr_table\"><tr><td align=\"right\" class=\"VerdanaMediumBlack\"><input type=\"checkbox\" name=\"chk_spec"+mindex+""+smindex+"\" value=\"Y\" />Specification Variants</td>"+
"<td align=\"left\" class=\"bdr_td\">"+
"<input type=\"text\" class=\"textbox2\" name=\"item_specification"+mindex+""+smindex+""+count+"\" id=\"item_specification"+mindex+""+smindex+""+count+"\" /> </td>"+
"</tr>"+
"<tr>"+
"<td align=\"right\" class=\"VerdanaMediumBlack\"></td>"+
"<td align=\"left\" class=\"bdr_td\">"+
"<input type=\"hidden\" class=\"textbox2\" name=\"pl_no"+mindex+""+smindex+""+count+"\" value=\"\"/></td>"+
"</tr>"+
"<tr>"+
"<td align=\"right\" class=\"VerdanaMediumBlack\">Remarks:</td>"+
"<td align=\"left\" class=\"bdr_td\">"+
"<textarea name=\"remarks"+mindex+""+smindex+""+count+"\" cols=\"30\" rows=\"6\"></textarea></td></tr></table></td>";
newRow.innerHTML=divContent;
// tbl.appendChild(newRow);
//document.getElementById('spec'+mindex+smindex).innerHTML=divContent;
eval('document.forms[0].count_spec'+mindex+''+smindex+'.value='+parseInt(count+1)+'');
applycss();
}
function removeMaterial(){
var howmany = document.forms[0].chk_material.length;
alert(howmany);
for( var count = 0; count < howmany; count++)
{
if(document.forms[0].chk_material[count] && document.forms[0].chk_material[count].checked==true)
{
document.getElementById("Material").deleteRow(count);
}
}
}
function removeSubMaterial(mindex){
var howmany = eval("document.forms[0].chk_submaterial"+mindex+".length");
for( var count = 0; count < howmany; count++)
{
if(eval("document.forms[0].chk_submaterial"+mindex+"["+count+"]") && eval("document.forms[0].chk_submaterial"+mindex+"["+count+"].checked==true"))
{
document.getElementById("chk_submaterial"+mindex).deleteRow(count);
}
}
}
function removeSpec(mindex,smindex){
var howmany = document.forms[0].chk_spec.length;
for( var count = 0; count < howmany; count++)
{
if(document.forms[0].chk_spec[count] && document.forms[0].chk_spec[count].checked==true)
{
document.getElementById("chk_spec"+mindex+smindex).deleteRow(count);
}
}
}
function disablerow(){
var ini_element_name;
var ini_element_type;
for (f=0;f<document.forms.length;f++)
{
for (e=0;e<document.forms[f].elements.length;e++)
{
if(document.forms[f].elements[e].type.toUpperCase()=='BUTTON')
{
if(document.forms[f].elements[e].value.trim().toUpperCase()=='BACK') ;
else
{
document.forms[f].elements[e].disabled=true;
}
}
}
}
}//end of function
</script>
<?php
if(isset($acn) && $acn=='update' )
{
?>
<script>disablerow();</script>
<?php }
?>
<script type="text/javascript">
function toggleDiv(chk)
{
if (document.getElementById("tbl"+chk).style.display == "block")
{
document.getElementById("tbl"+chk).style.display = "none";
}
else
{
document.getElementById("tbl"+chk).style.display = "block";
}
}
</script>
<!--do not modify anything below-->
</div><!-- /.page-content -->
</div>
</div><!-- /.main-content -->
<?php include('techsyn_footer.php');?>