<TABLE border="1" cellpadding="0" cellspacing="0"> <? $sensors = $driver->listSensors(); $counter = 0; $colNames = array('SerialNumber', 'name','description','color','Range Alarm','Min','Max','Max Change Alarm','Max Change Amount','Max Change Inteval (seconds)','Delete Metadata'); echo makeTableHeader($colNames); while(list($sensor, $data) = each($sensors)) { //echo "$sensor"; echo "<TR>"; echo "<TD bgcolor='#EEEEEE'>$sensor</TD>"; echo makeHiddenField("SerialNumber$counter", $sensor); echo '<TD>'.makeInputField("name$counter", $data['name']).'</TD>'; //echo '<TD>'.makeInputField("description$counter", $data['description'], 40).'</TD>'; echo '<TD>'.makeTextArea("description$counter", $data['description']).'</TD>'; echo '<TD bgcolor='.$data['color'].'>*'.makeInputField("color$counter", $data['color']).'</TD>'; echo '<TD>'.makeCheckBox("alarm$counter", $data['alarm']).'</TD>'; echo '<TD>'.makeInputField("min$counter", $data['min'],5).'</TD>'; echo '<TD>'.makeInputField("max$counter", $data['max'],5).'</TD>'; echo '<TD>'.makeCheckBox("maxchange_alarm$counter", $data['maxchange_alarm']).'</TD>'; echo '<TD>'.makeInputField("maxchange$counter", $data['maxchange'], 5).'</TD>'; echo '<TD>'.makeInputField("maxchange_interval$counter", $data['maxchange_interval'], 6).'</TD>'; echo '<TD>'.makeDelete($sensor).'</TD>'; echo '</TR>'; $counter++; }
<?php echo "<td><a href='list_personal.php'>show List</a></td>"; ?> </tr> <tr> <td><hr color='black'></td> </tr> <?php endPrettyTable(); ?> </td> <td valign=top align=center width='65%'> <?php openForm("enter Personal", $PHP_SELF); beginPrettyTable("2", "enter Personal"); makeHiddenField("emp_id3", $edit["EMP_ID3"]); makeTextField("emp_name", $edit["EMP_NAME"], "Employer Name"); makeDropBox("desig_id", $desig_array, "Designation", $edit["DESIG_ID"]); makeDropBox("status", array("Y" => "Y", "N" => "N", "UNKNOWN" => ""), "Status", $edit["STATUS"]); makeTextField("ac_no", $edit["AC_NO"], "Account Number"); makeTextField("conf_dt", $edit["CONF_DT"], "Conf_Date"); makeTextField("join_dt", $edit["JOIN_DT"], "Join Date"); makeSubmitter(); endPrettyTable(); closeForm(); ?> </td> </table> <?php } endDocument();
} $amount = $_POST[$field_name]; $vr_no = get_new_vrno(); # insert voucher $query = $query_part1 . "('{$vr_no}','{$today}','CR','{$ac1}', '{$ac2}','{$ac3}','{$ac4}','{$ac5}','D','','{$amount}','','opening Balance','{$today}','')"; $result = mysql_query($query, $db); checkMySQLError(); # insert counterbooking $query = $query_part1 . "('{$vr_no}','{$today}','CR','0', '5','0','0','0','C','','{$amount}','','opening Balance','{$today}','')"; $result = mysql_query($query, $db); checkMySQLError(); } report(1, "Everything seems to be fine. Check via Bank and Cash Report!"); } else { $db = getDBConnection(); $result = mysql_query("Select * FROM TRANS"); if (mysql_num_rows($result) != 0) { report(0, "Sorry, opening balance can only be performed when you have no Vouchers entered"); } $accounts_array = get_ac5_sc_array("5(1)", "B"); beginPrettyTable("2", "enter opening balances"); openForm("openingbalance", $PHP_SELF); makeHiddenField("submitnow", 0); foreach ($accounts_array as $ac5 => $desc) { makeTextField("account_field_" . $ac5, "", $desc); } makeSpecialSubmitter("submit", "onClick='this.form.submitnow.value=\"1\"'"); closeForm(); endPrettyTable(); } endDocument();
$dept_array = get_dept_array(); if (!isset($ac_count)) { $ac_count = 3; } $today = get_today_hrd_string(); ?> <table cellpadding=5 cellspacing=0 border=0 width='100%'> <tr> <td valign=top align=center width='65%'> <?php openForm("transaction", $PHP_SELF, "onSubmit='return checkBeforeSubmit()'"); beginPrettyTable("2", "enter {$type_of_voucher} Voucher"); makeHiddenField("ac_count", "{$ac_count}"); makeHiddenField("submitnow", ""); makeHiddenField("vr_tp", $vr_tp); makePlainDropBox("ac_name", $ac_array, "Ac_Name"); makePlainStaticField("t_dt", $today, " ", 10); startRow(); makePlainStaticField("dr_cr", $dr_cr, "DR./CR", 2); makePlainTextField("amount", "", "Amount:", 8); endRow(); startRow(); makePlainStaticField("vr_no", "", "Vr.No.:", 10); makePlainTextField("vr_dt", $today, "Vr.-Date:", 10); endRow(); makePlainTextField("party", "", $dr_cr == "C" ? "Paid To" : "Rcvd. from"); if ($vr_tp != "JV") { makePlainTextField("chq_no", "", "Chq-No.:", 10); } makeTextField("remarks", "", "Narration:");
</tr> <tr> <td><hr color='black'></td> </tr> <?php endPrettyTable(); # it just print out some HTML ?> </td> <td valign=top align=center width='65%'> <?php $db = getDBConnection(); $employer_array = get_personal_array(); openForm("loan_form", $PHP_SELF, "onSubmit=\"return confirmSubmit()\""); beginPrettyTable("2", "enter {$loan_type} entry"); makeHiddenField("type", $type); makeDropBox("emp_id3", $employer_array, "Employers Name"); startRow(); makePlainTextField("loan_dt", "", "Loan Santion Dt.", 10); makePlainTextField("loan_start", "", "Deduction Start Dt.", 10, "onChange=\"checkdate(this.value) && updateFields()\""); endRow(); startRow(); makePlainTextField("inst_no", "", "Instalment No", 6, "onChange=\"updateFields()\""); makePlainStaticField("loan_end", "", "Loan End Dt.", 10); endRow(); makeStaticField("interest_rate", "{$interest_rate}" . "%", "Interest Rate", 6); startRow(); makePlainTextField("loan_amt", "", "Loan Amount", 10, "onChange=\"updateFields()\""); makePlainStaticField("int_amt", "", "Total Interest", 10); endRow(); startRow();
} else { if ($row["VR_TP"] == "CR") { die("Requested Voucher is a Credit-Voucher. Credit-Vouchers can't get deleted. Instead, make a Debit-Voucher and correct the mistake!"); } else { if (mysql_fetch_array($result, MYSQL_ASSOC)) { die("more than one Voucher found! Database-integrity is in Danger! Call your System-maintainer!"); } } } beginPrettyTable("1", "Do you want to Remove this Voucher ?"); printRow(array("AC_Codes", "VR_TP", "Vr_No", "VR_DT", "PARTY", "NARRATION", "AMOUNT"), "", "1,5"); $row["VR_DT"] = conv_to_hrd($row["VR_DT"]); printRow($row, "something"); openForm("removevoucher_confirm_form", $PHP_SELF); makeHiddenField("remove_confirm", 0); makeHiddenField("vr_no", $vr_no); makeSpecialSubmitter("yes, remove it!", "this.form.remove_confirm.value=1", 6); endPrettyTable(); mysql_close($db); } else { ?> <table cellpadding=5 cellspacing=0 border=0 width='100%'> <tr> <td valign=top width='15%'> <?php beginPrettyTable("1"); ?> <tr> <?php
<?php beginPrettyTable("1"); ?> <tr> <?php echo "<td><a href='list_acs.php?showac={$ac}'>show List</a></td>"; ?> </tr> <tr> <td><hr color='black'></td> </tr> <?php endPrettyTable(); ?> </td> <td valign=top align=center width='65%'> <?php openForm("enterAC_CODE{$ac}", $PHP_SELF); beginPrettyTable("2", "enter AC_CODE{$ac}"); makeHiddenField("ac", $ac); makeTextField("ac_desc", "", "AC_CODE{$ac}"); makeSubmitter(); endPrettyTable(); closeForm(); ?> </td> </table> <?php } endDocument();
$ac_array = get_ac5_sc_array("5(1)", "B"); $dept_array = get_dept_array(); if (!isset($ac_count)) { $ac_count = 3; } $today = get_today_hrd_string(); ?> <table cellpadding=5 cellspacing=0 border=0 width='100%'> <tr> <td valign=top align=center width='65%'> <?php openForm("transaction", $PHP_SELF, "onSubmit='return checkBeforeSubmit()'"); beginPrettyTable("2", "enter {$type_of_voucher} Voucher"); makeHiddenField("ac_count", "{$ac_count}"); makeHiddenField("submitnow", ""); makePlainStaticField("vr_no", "", "Vr.No.:", 10); makePlainStaticField("t_dt", $today, "Transaction Date:", 10); makePlainTextField("vr_dt", $today, "Vr.-Date:", 10); makeTextField("remarks", "", "Narration:", 30, "onChange=\"copyNarrationField()\""); endPrettyTable(); # Start now with that second part of the story $ac_array = get_ac5_sc_array("5(1/2)", ""); beginPrettyTable("1", "I call it \"Counterbooking\""); ?> <tr><td>AccountName</td><td>Narration</td><td>Dept</td><td>DR_CR</td><td>Amount</td></tr><?php for ($i = 0; $i < $ac_count; $i++) { startRow(); makePlainDropBox("ac_name_{$i}", $ac_array); makePlainTextField("remarks_{$i}", "", "", 20); makePlainDropBox("dept_{$i}", $dept_array);
deldir("/tmp/ac4ngosdata/"); # 0333 does not work properly :-( so chmod ... $filename = $_FILES['dbdumpfile']['tmp_name']; move_uploaded_file($filename, "/tmp/ac4ngosimport.tar.gz") || die("Something wrong with the uploaded file ..."); exec("cd /tmp; tar -xzf ac4ngosimport.tar.gz;chmod -R o+r ac4ngosdata"); $result = mysql_query("SHOW TABLES FROM {$DBNAME}"); checkMySQLError(); while ($row = mysql_fetch_array($result, $db)) { $tablename = $row["Tables_in_{$DBNAME}"]; $query = "DELETE FROM {$tablename}"; $result2 = mysql_query($query, $db); checkMySQLError($query); $filename = "/tmp/accrpdata/" . $tablename . ".txt"; if (file_exists($filename)) { $query = "LOAD DATA INFILE '{$filename}' INTO TABLE `{$tablename}`"; $result2 = mysql_query($query, $db); checkMySQLError($query); } } deldir("/tmp/ac4ngosdata/"); die("finished"); } else { beginPrettyTable(2, "Restore Backup"); openForm("uploadfile", "{$PHP_SELF}", "form enctype=\"multipart/form-data\" accept\"application/x-tgz\""); makeHiddenField("MAX_FILE_SIZE", "30000"); echo "Send this file: <input name=\"dbdumpfile\" type=\"file\">"; makePlainSpecialSubmitter("Send File"); closeForm(); endPrettyTable(); } endDocument();