<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();
