<?php if (isset($_COOKIE["ValidUserAdmin"])) { require "config1.php"; require "config.php"; include "header_vendor.php"; $auth = ($_COOKIE["ValidUserAdmin"]); $sys_date= date("m/d/YY"); $sys_date1= date("Y/m/d"); ?> <html> <head> </head> <body> <table id="page"> <tr><td> <br> <form id="form1" name="form1" method="POST" > <TABLE class="tbl" width="100%" ALIGN="CENTER" CELLPADDING="0" CELLSPACING="1" BGCOLOR="#E4EEE3"> <TR> <TD colspan="4"><strong>Add New vendor </strong></a></TD> </TR> <TR> <TD BGCOLOR="#FFFFFF">Vendor Name <span style="color:#FF0000"> * </span></TD> <TD BGCOLOR="#FFFFFF"> <input type="text" name="ven_name" value="ven_name" size="40" ></TD> <TD BGCOLOR="#FFFFFF">Category <span style="color:#FF0000"> * </span></TD> <TD BGCOLOR="#FFFFFF"> <? $query1 = "SELECT distinct Vendor_category from aa_customize where Vendor_category != ''"; $result1 = mysql_query($query1); if(!$result1) { echo "The query failed " . mysql_error(); } else { echo "<select name='category' >"; ?> <option value=""> Select One </option> <? while($row = mysql_fetch_array($result1, MYSQL_ASSOC)) { $select= $row['Vendor_category']; echo"<option value='". $row['Vendor_category']."'>" .$row['Vendor_category'] . "</option>"; } echo"</select>"; } ?></TD> </TR> <TR><TD colspan="4"><strong>Contact Details </strong></TD></TR> <tr> <TD BGCOLOR="#FFFFFF">Contact Landline No. <span style="color:#FF0000"> * </span></TD> <TD BGCOLOR="#FFFFFF"> <input type="TEXT" name="landline" value="" size="15"> </TD> <TD BGCOLOR="#FFFFFF">Contact Mobile <span style="color:#FF0000"> * </span></TD> <TD BGCOLOR="#FFFFFF"> <INPUT id="mobile" NAME="mobile" TYPE="text" value="" size="15" /></TD> </TR> <TR> <TD BGCOLOR="#FFFFFF">Contact Email <span style="color:#FF0000"> * </span></TD> <TD BGCOLOR="#FFFFFF"> <input type="TEXT" name="email" size="35" value=""> </TD> <td bgcolor="#FFFFFF">Website</td> <td bgcolor="#FFFFFF"> <input type="text" name="website"></td> </TR> <TR> <TD BGCOLOR="#FFFFFF">Address<span style="color:#FF0000"> * </span></TD> <TD BGCOLOR="#FFFFFF" colspan="3"><p> <textarea white-space:nowrap;overflow:auto; rows="3" cols="35" type="TEXT" name="address"><? echo $address ; ?></textarea></p> </TD> </TR> <TR> <TD BGCOLOR="#FFFFFF">State<span style="color:#FF0000"> * </span></TD> <TD BGCOLOR="#FFFFFF"> <? $query1 = "SELECT distinct state from subcategory order by cat_id"; $result1 = mysql_query($query1); if(!$result1) { echo "The query failed " . mysql_error(); } else { echo "<select name='state' onChange='AjaxFunction(document.form1.state.options[document.form1.state.selectedIndex].text);'>"; ?> <option value=""> Select One </option> <? while($row = mysql_fetch_array($result1, MYSQL_ASSOC)) { $select= $row['state']; echo"<option value='". $row['state']."'>" .$row['state'] . "</option>"; } echo"</select>"; } ?> <TD BGCOLOR="#FFFFFF">City <span style="color:#FF0000"> * </span></TD> <TD BGCOLOR="#FFFFFF"> <select name="city"> </select> </TR> <TR> <TD BGCOLOR="#FFFFFF">Country <span style="color:#FF0000"> * </span></TD> <TD BGCOLOR="#FFFFFF"> <select name="country"> <option value="India" selected="selected">India</option> <option value="United States">United States</option> <option value="United Kingdom">United Kingdom</option> </select> <TD BGCOLOR="#FFFFFF">Pincode<span style="color:#FF0000"> * </span></TD> <TD BGCOLOR="#FFFFFF"> <input type="TEXT" name="pin" size="8" value="" ></TD> </TR> <tr><td colspan="4"><strong>Mode Of Transaction</strong></td> </tr> <tr><td bgcolor="#FFFFFF" ><label> <input type="checkbox" id="check1" name="cheque" value="Cheque" onClick="showMe('chq_div','pay_chq', this)" /> Cheque/AtparCheque</label></td> <td colspan="3" bgcolor="#FFFFFF"><div id="chq_div" style="display:none"> In Favour Of <input id="pay_chq" type="TEXT" name="payment_to_chq" size="30" ></div> </td></tr> <tr><td bgcolor="#FFFFFF"><label> <input type="checkbox" id="check2" name="dd" value="DD" onClick="showMe1('dd_div','pay_dd','pay_at',this)"/> Demand Draft</label></td> <td colspan="3" bgcolor="#FFFFFF"><div id="dd_div" style="display:none"> In Favour Of <input id="pay_dd" type="TEXT" name="payment_to_dd" size="30" > Payable At <input id="pay_at" type="TEXT" name="payable_at" size="30" > </div></td> </tr> <tr><td bgcolor="#FFFFFF"><label> <input type="checkbox" id="bktransfer" name="banktransfer" value="Bank Transfer" onClick="showMe2('addBank', this)"/> Bank Transfer</label></td> <td colspan="3" bgcolor="#FFFFFF"> <table id="addBank" style="display:none"> <tr><td BGCOLOR="#E4EEE3" align="center">Account Name</td><td BGCOLOR="#E4EEE3" align="center">Account No.</td><td BGCOLOR="#E4EEE3" align="center">Bank Name</td><td BGCOLOR="#E4EEE3" align="center">Branch Name</td><td BGCOLOR="#E4EEE3"><input type="button" name="add" value="Add Bank" onClick="addRow('addBank')"></td></tr> </table> </td></tr> <tr><td bgcolor="#FFFFFF"><label> <input type="checkbox" id="cash" name="cash" value="Cash" /> Cash</label></td> <td colspan="3" bgcolor="#FFFFFF"> </td></tr> <!-- flooble Expandable Content box start --> <tr><td align="left" colspan="4">[<a title="show/hide" id="exp1254911560_link" href="javascript: void(0);" onClick="toggle(this, 'exp1254911560');"> - </a>] <b>Add Contanct Persons</b></td> </tr> <tr><td bgcolor="#FFFFFF" colspan="4"> <table id="exp1254911560"> <tr><td align="center">Name</td><td align="center">Contact No</td><td align="center">Email Id</td><td align="center">Designation</td><td align="center">Department</td><td><input type="button" name="add" value="Add contanct" onClick="addRow1('exp1254911560')"></td></tr> </table> </td> </tr> <script language="javascript">toggle(getObject('exp1254911560_link'), 'exp1254911560');</script> <!-- flooble Expandable Content box end --> <TR> <TD colspan="4" align="center" bgcolor="E4EEE3" > <input name="submit" type="SUBMIT" value="Add" align="middle" size="30" onClick="return validate();"></TD> </TR> </TABLE> </form> <script language="JavaScript" type="text/javascript"> function validate(){ var rgxa = /^-?\d+(\.\d+)?$/; dml=document.forms['form1']; // get the number of elements from the document len = dml.elements.length; for( i=0 ; i<len ; i++) { //check the textbox with the elements name if (dml.elements[i].name=='bank[]') { // if exists do the validation and set the focus to the textbox if (dml.elements[i].value=="") { alert("Enter the Bank Name "); dml.elements[i].focus(); return false; } } if (dml.elements[i].name=='branch[]') { // if exists do the validation and set the focus to the textbox if (dml.elements[i].value=="") { alert("Enter the Branch Name "); dml.elements[i].focus(); return false; } }if (dml.elements[i].name=='account[]') { // if exists do the validation and set the focus to the textbox if (dml.elements[i].value=="") { alert("Enter the Account No "); dml.elements[i].focus(); return false; } if(!rgxa.test(dml.elements[i].value)) { alert("Not a Valid Account no, Enter in Numerics!!"); dml.elements[i].value=""; dml.elements[i].focus(); return false; } } if (dml.elements[i].name=='account_name[]') { // if exists do the validation and set the focus to the textbox if (dml.elements[i].value=="") { alert("Enter the Account Name "); dml.elements[i].focus(); return false; } } if (dml.elements[i].name=='user[]') { // if exists do the validation and set the focus to the textbox if (dml.elements[i].value=="") { alert("Enter the User Name "); dml.elements[i].focus(); return false; } } if (dml.elements[i].name=='contact[]') { // if exists do the validation and set the focus to the textbox if (dml.elements[i].value=="") { alert("Enter the Contact No "); dml.elements[i].focus(); return false; } if(!rgxa.test(dml.elements[i].value)) { alert("Not a Valid Contact no, Enter in Numerics!!"); dml.elements[i].value=""; dml.elements[i].focus(); return false; } } if (dml.elements[i].name=='emailid[]') { // if exists do the validation and set the focus to the textbox if (dml.elements[i].value=="") { alert("Enter the Email Id "); dml.elements[i].focus(); return false; } } } var frmvalidator = new Validator("form1"); var chq_select = document.getElementById("check1") var chq_fvr = document.getElementById("pay_chq") var dd_select = document.getElementById("check2") var dd_fvr = document.getElementById("pay_dd") var dd_at = document.getElementById("pay_at") var bank_select = document.getElementById("bktransfer") var cash_select = document.getElementById("cash") frmvalidator.addValidation("ven_name","req","Please Enter Vendor Name"); frmvalidator.addValidation("ven_name","maxlen=200"); frmvalidator.addValidation("category","req","Please Select category for Vendor"); frmvalidator.addValidation("landline","req","Please enter your Landline no."); frmvalidator.addValidation("landline","maxlen=15","Landline no. exceeds its maximum length"); frmvalidator.addValidation("landline","numeric","Only digits are allowed in landline no"); frmvalidator.addValidation("mobile","req","Please enter your Mobile no."); frmvalidator.addValidation("mobile","maxlen=13","Mobile no. exceeds its maximum length"); frmvalidator.addValidation("mobile","numeric","Only digits are allowed in Mobile no"); frmvalidator.addValidation("email","email","please Enter Valid Email-Id"); frmvalidator.addValidation("email","maxlen=100"); frmvalidator.addValidation("email","req","Please Enter your Email-Id"); frmvalidator.addValidation("address","req","Please Enter your Address"); frmvalidator.addValidation("address","maxlen=800","Address Field exceeds its maximum length"); frmvalidator.addValidation("city","req","Please select your city"); frmvalidator.addValidation("city","maxlen=100","maximum length allowed for city is 100 alphabets"); frmvalidator.addValidation("state","req","Please select your State"); frmvalidator.addValidation("state","maxlen=100","maximum length allowed for State is 150 alphabets"); frmvalidator.addValidation("country","req","Please select your Country"); frmvalidator.addValidation("country","maxlen=100","maximum length allowed for Country is 150 alphabets"); frmvalidator.addValidation("pin","req","Please enter Your Pin code"); frmvalidator.addValidation("pin","maxlen=6","Pin code must be of 6 digits"); frmvalidator.addValidation("pin","minlen=6","Pin code must be of 6 digits"); frmvalidator.addValidation("pin","numeric","Pin code must be digit"); if(chq_select.checked == false && dd_select.checked== false && bank_select.checked== false && cash_select.checked==false) { alert("Select One mode of Payment"); return false; } if(chq_select.checked == true && chq_fvr.value=="") { chq_fvr.focus(); alert("Enter Cheque In Favour Of"); return false; } if(dd_select.checked == true && dd_fvr.value=="") { dd_fvr.focus(); alert("Enter DD In Favour Of"); return false; } if(dd_select.checked == true && dd_at.value=="") { dd_at.focus(); alert("Enter DD Payable at "); return false; } } </script> <BR> <? $ban = $_POST['bank']; $branch = $_POST['bank']; $v_name=$_POST['ven_name']; if(isset($_POST['submit']) && isset($_POST['banktransfer']) ) { $str="INSERT INTO aa_vendor1(id,ven_name,category,landline,mobile,email,address,city,state,country,pin,cheque,cash,dd,banktransfer,chq_favr,dd_favr,dd_pay,website) VALUES ('','".$_POST['ven_name']."','".$_POST['category']."','".$_POST['landline']."','".$_POST['mobile']."','".$_POST['email']."','".$_POST['address']."','".$_POST['city']."','".$_POST['state']."','".$_POST['country']."','".$_POST['pin']."','".$_POST['cheque']."','".$_POST['cash']."','".$_POST['dd']."','".$_POST['banktransfer']."','".$_POST['payment_to_chq']."','".$_POST['payment_to_dd']."','".$_POST['payable_at']."','".$_POST['website']."')"; mysql_query($str); echo mysql_error(); $bak = $_POST['bank']; $brnch = $_POST['branch']; $acc_name = $_POST['account_name']; $acc_no = $_POST['account']; $count = count($bak); for($i=0 ; $i < count($ban); $i++) { $qry = "INSERT INTO aa_bank (`id`,`acc_name`,`acc_no`,`bank`,`ven_name`,`branch_name`) VALUES ('','".$acc_name[$i]."','".$acc_no[$i]."','".$bak[$i]."','".$_POST['ven_name']."', '".$brnch[$i]."')"; mysql_query($qry); echo mysql_error(); } $desg = $_POST['desg']; $user = $_POST['user']; $contact = $_POST['contact']; $emailid = $_POST['emailid']; $dept = $_POST['dept']; $count11 = count($desg); for($i=0 ; $i < count($desg); $i++) { $qry = "INSERT INTO contacts (`id`,`ven_name`,`desg`,`namee`,`contact`,`emailid`,dept) VALUES ('','".$_POST['ven_name']."','".$desg[$i]."','".$user[$i]."','".$contact[$i]."', '".$emailid[$i]."','".$dept[$i]."')"; mysql_query($qry); echo mysql_error(); } ?> <META HTTP-EQUIV="refresh" content="0;URL=vendor_add_product.php?ven_name=<? echo $v_name; ?>"> <? } else { if(isset($_POST['submit'])) { $str="INSERT INTO aa_vendor1(id,ven_name,category,landline,mobile,email,address,city,state,country,pin,cheque,cash,dd,banktransfer,chq_favr,dd_favr,dd_pay,website) VALUES ('','".$_POST['ven_name']."','".$_POST['category']."','".$_POST['landline']."','".$_POST['mobile']."','".$_POST['email']."','".$_POST['address']."','".$_POST['city']."','".$_POST['state']."','".$_POST['country']."','".$_POST['pin']."','".$_POST['cheque']."','".$_POST['cash']."','".$_POST['dd']."','".$_POST['banktransfer']."','".$_POST['payment_to_chq']."','".$_POST['payment_to_dd']."','".$_POST['payable_at']."','".$_POST['website']."')"; mysql_query($str); echo mysql_error(); $desg = $_POST['desg']; $user = $_POST['user']; $contact = $_POST['contact']; $emailid = $_POST['emailid']; $dept = $_POST['dept']; $count11 = count($desg); for($i=0 ; $i < count($desg); $i++) { $qry = "INSERT INTO contacts (`id`,`ven_name`,`desg`,`namee`,`contact`,`emailid`,dept) VALUES ('','".$_POST['ven_name']."','".$desg[$i]."','".$user[$i]."','".$contact[$i]."', '".$emailid[$i]."','".$dept[$i]."')"; mysql_query($qry); echo mysql_error(); } ?> <META HTTP-EQUIV="refresh" content="0;URL=vendor_add_product.php?ven_name=<? echo $v_name; ?>"> <? } } ?> </td> </tr> </table> <? } else { print "<p>Unauthorised Admin access - <a href=\"http://expense.webhop.org\">Click Here to Login</></p>"; } ?> </td> </tr> </table> <TABLE WIDTH="100%" CELLPADDING="0" CELLSPACING="1" BGCOLOR="<?php print "$HRColour"; ?>"> <TR> <TD></TD> </TR> </TABLE> <P ALIGN="CENTER" CLASS="copyright"><?php print "$Copyright"; ?></P> </body> </html> [/code Code (markup):
<? if (isset($_COOKIE["ValidUserAdmin"])) { require "config1.php"; require "config.php"; include "header_vendor.php"; $auth = ($_COOKIE["ValidUserAdmin"]); $sys_date= date("m/d/YY"); $sys_date1= date("Y/m/d"); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> </head> <body> <table id="page" > <tr> <td> <br><br> <TABLE class="tbl" width="100%" ALIGN="CENTER" BGCOLOR="#E4EEE3"> <th >id</th><th >Name</th><th >Address</th> <th >Mobile</th><th >Landline</th> <th >Email</th><th>Add Products</th> <? while($nt=mysql_fetch_array($q)){ $name = $nt['ven_name'] ; $product= $nt['prod_name']; ?> <tr> <td align="right" bgcolor="#FFFFFF"><? echo $nt[id] ;?></td> <td bgcolor="#FFFFFF" width="300" ><a href="<? echo "vendor_update.php?id=".$nt['id']." "; ?>"> <? echo $name ;?> </a></td> <td bgcolor="#FFFFFF"><? echo $nt[address] ;?></td> <td bgcolor="#FFFFFF" align="right"><? echo $nt[mobile] ;?></td> <td bgcolor="#FFFFFF" align="right"><? echo $nt[landline] ;?></td> <td bgcolor="#FFFFFF" align="left"><? echo $nt[email] ;?></td> <td bgcolor="#FFFFFF" align="center"><a href="<? echo "vendor_product.php?id=".$nt['id']." "; ?>"> Add</a></td> <td bgcolor="#FFFFFF" align="center"><input type="button" name="remv" value="Delete" onClick="removeRowFromData(' <? echo $nt['id']; ?> ')"></td> </tr> <? } ?> </table> <?=$pagination?> <? } else { print "<p>Unauthorised Admin access - <a href=\"http://expense.webhop.org\">Click Here to Login</></p>"; } ?> </td> </tr> </table> <br><br> <TABLE WIDTH="100%" CELLPADDING="1" CELLSPACING="1" BGCOLOR="<?php print "$HRColour"; ?>"> <TR> <TD></TD> </TR> </TABLE> <P ALIGN="CENTER" CLASS="copyright"><?php print "$Copyright"; ?></P> </body> </html> Code (markup):