function printDerangement($derangement, $settings)
{
foreach ($settings->derangements as $m) {
if ($derangement->id == $m->id) {
printRow($derangement, $m);
}
}
}
function printBalanceStatements($net)
{
$receipts = sprintf("%.2f", runQuery("Select SUM(r_amount) as amt from f_receivables where r_date like '%2015%'", 'amt'));
$payables = sprintf("%.2f", runQuery("Select SUM(p_amount) as amt from f_payables where p_date like '%2015%'", 'amt'));
$gross = $net + $receipts - $payables;
echo "<table class=ptables>\n";
printRow("Mini Balance Sheet", '', '', 'H');
printRow("Cash and Equivalents", '', $net);
printRow("Accounts Receivables", '', $receipts);
printRow("Accounts Payables", $payables, '');
printRow("Net Assets", '', $gross, 'H');
echo "</table>";
}
function echoInitialVersionRows($version)
{
if ($version < 1) {
printRow('Pre-v1.4.0');
}
if ($version < 140) {
printRow('v1.4.0');
}
if ($version < 141) {
printRow('v1.4.1');
}
if ($version < 150) {
printRow('v1.5.0');
}
if ($version < 160) {
printRow('v1.6.0');
}
if ($version < 161) {
printRow('v1.6.1');
}
if ($version < 170) {
printRow('v1.7.0');
}
if ($version < 200) {
printRow('v2.0.0');
}
if ($version < 201) {
printRow('v2.0.1');
}
if ($version < 210) {
printRow('v2.1.0');
}
if ($version < 211) {
printRow('v2.1.1');
}
if ($version < 220) {
printRow('v2.2.0');
}
if ($version < 221) {
printRow('v2.2.1');
}
if ($version < 230) {
printRow('v2.3.0');
}
if ($version < 231) {
printRow('v2.3.1');
}
if ($version < 232) {
printRow('v2.3.2');
}
}
printRow($e_vals['HUMIDIFIER:ELECTRICITY']);
?>
</tr>
<tr class="table-row-even">
<th> Regrigeration
</th>
<?php
printRow($e_vals['HEATRECOVERY:ELECTRICITY']);
?>
</tr>
<tr class="table-row-even">
<th> Generation
</th>
<?php
printRow($e_vals['HEATRECOVERY:ELECTRICITY']);
?>
</tr>
</table>
</div> <!-- /container -->
<!-- Le javascript
================================================== -->
<!-- load highchart libs -->
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.9.0/jquery.min.js"></script>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script>
<script src="js/Highcharts-3.0.4/js/highcharts.js"></script>
<script src="js/Highcharts-3.0.4/js/modules/exporting.js"></script>
<!-- Placed at the end of the document so the pages load faster -->
<script type="text/javascript" src="js/bootstrap.min.js"></script>
<?php printRowHeader(); ?> <?php printRow($bees, 'workers'); ?> </table> </div> <div class="col-md-4"> <h2>Drones</h2> <table class="table table-bordered table-responsive" width="100%"> <?php printRowHeader(); ?> <?php printRow($bees, 'drone'); ?> </table> </div> </div> <div class="text-center"> <form action="javascript:void(0)" method="post" role="form"> <button type="button" id="hit-button" class="btn btn-primary">Hit!</button> <button type="button" id="reset-button" class="btn btn-danger">Reset</button> </form> </div> <br> <div id="result"></div>
function htmlPrinter($endpoints)
{
global $options;
$a = '<html>
<head>
<title>Bio2RDF Release ' . $options['r'] . '</title>
<link rel="stylesheet" type="text/css" href="http://134.117.53.12/lib/datatables/css/jquery.dataTables.css"/>
<link rel="stylesheet" type="text/css" href="http://134.117.53.12/lib/datatables/css/code.css"/>
<script type="text/javascript" src="http://code.jquery.com/jquery-latest.js"></script>
<script type="text/javascript" src="http://134.117.53.12/lib/datatables/js/jquery.dataTables.js"></script>
<script type="text/javascript" charset="utf-8">
$(document).ready(function(){
$("table").dataTable({
"bInfo":false,
"bPaginate":false,
"aaSorting":[[0,"asc"]]
});
});
</script>
<style type="text/css">
#logo{
display:block;
margin-left:auto;
margin-right:auto;
}
#release{
margin-left:20%;
margin-right:20%;
font-size: 120%;
color:#039;
font-weight:bold;
}
body {
font-family: "Lucida Sans Unicode", "Lucida Grande", Sans-Serif;
font-size: 10px;
color:#174e74;
}
#links{
background: #fff;
margin-left:auto;
margin-right:auto;
text-align: center;
}
#tableContainer {
margin:0 auto;
padding-bottom: 20px;
padding-top: 50px;
width: 80%;
}
</style>
</head>
<body>
<a href="http://bio2rdf.org"><img alt="Bio2RDF Homepage" id="logo" src="https://googledrive.com/host/0B3GgKfZdJasrRnB0NDNNMFZqMUk/bio2rdf_logo.png" height="80px"/></a>
<div id="links">
<h3>Linked Data for the Life Sciences</h3>
<h2>-Release ' . $options['r'] . '-</h2>
<h2>[<a href="http://bio2rdf.org" target="_blank">website</a>]
[<a href="http://download.bio2rdf.org/release/' . $options['r'] . '/release.html" target="_blank">datasets</a>]
[<a href="http://github.com/bio2rdf/bio2rdf-scripts/wiki" target="_blank">documentation</a>]
</h2>
</div>
<div id="tableContainer">
<table class=\\"hor-minimalist-a\\">
<thead>
<tr>
<th width=\\"40\\"></th>
<th width=\\"300\\">Dataset</th>
<th width=\\"100\\">Date generated</th>
<th width=\\"100\\"># of triples</th>
<th width=\\"100\\"># of unique entities</th>
<th width=\\"100\\"># of unique subjects</th>
</tr>
</thead>
';
$i = 0;
// initialize totals
$options['totals']['triples'] = 0;
$options['totals']['entities'] = 0;
$options['totals']['subjects'] = 0;
ksort($endpoints);
foreach ($endpoints as $e => $endpoint_details) {
if ($options['endpoint'] && $options['endpoint'] != $e) {
continue;
}
$i++;
$a .= printRow($endpoint_details, $i);
}
$a .= "\n <tr class=\"total\">\n\t<td></td>\n\t<td></td>\t\n\t<td></td>\n\t<td>" . $options['totals']['triples'] . "</td>\n\t<td>" . $options['totals']['entities'] . "</td>\n\t<td>" . $options['totals']['subjects'] . "</td>\n </tr>";
$a .= "\n</table>\n<br>last updated on " . date("d-m-Y", mktime()) . "\n</body>\n</html>";
return $a;
}
<?php
printRow($gas_tariff['Adjustment (~~$~~)']);
?>
</tr>
<tr class="table-row-odd">
<th> Taxes ($)
</th>
<?php
printRow($gas_tariff['Taxes (~~$~~)']);
?>
</tr>
<tr class="table-row-odd">
<th> Total ($)
</th>
<?php
printRow($gas_tariff['Total (~~$~~)']);
?>
</tr>
</table>
</div>
</div> <!-- /container -->
<!-- Le javascript
================================================== -->
<!-- load highchart libs -->
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.9.0/jquery.min.js"></script>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script>
<script src="js/Highcharts-3.0.4/js/highcharts.js"></script>
function addColumn($table, $column_name, $column_info = '', $after = '')
{
global $mainframe;
$database =& JFactory::getDBO();
$db_prefix = $mainframe->getCfg('dbprefix');
$database->setQuery('SHOW COLUMNS FROM #__mt_' . $table . ' LIKE "' . $column_name . '"');
$tmp = $database->loadResult();
if ($tmp == $column_name) {
printRow('Skipped column:' . $column_name . ' already exists.', 0);
return false;
} else {
$sql = 'ALTER TABLE #__mt_' . $table . ' ADD `' . $column_name . '` ' . $column_info;
if (!empty($after)) {
$sql .= ' AFTER `' . $after . '`';
}
$database->setQuery($sql);
if ($database->query()) {
printRow('Added column:' . $column_name . ' to table: ' . $db_prefix . 'mt_' . $table);
return true;
} else {
printRow($database->getErrorMsg() . -1);
return false;
}
}
}
<?php
# This form allows to enter a date. After submitting, all Bank and Cash Account-balances get
# printed seperated by Projects.
session_start();
require "accrp.php";
require "security/secure.php";
beginDocument("list Cash and Bank", $sess_user);
if ($date) {
$ac1 = get_ac_array(1);
foreach ($ac1 as $key => $prj_desc) {
$accounts = new BankAndCashAccounts_byProject($key, $date, "c");
beginPrettyTable(4, "{$prj_desc}");
printRow(array("Account", "Balance"));
while ($row = $accounts->getNext()) {
printRow(array($row["AC5_DESC"], $accounts->getActualBalance() . " "), "irgendwas");
}
printRow(array("Sum", $accounts->getSum()));
endPrettyTable();
}
} else {
openForm("enter Date", $PHP_SELF);
beginPrettyTable("2", "list bank and cash");
makeTextField("date", get_today_hrd_string(), "Date:");
makeSubmitter();
endPrettyTable();
closeForm();
}
endDocument();
echo " {$v->value};\n";
}
try {
$client->get($t, $row, "entry:foo");
throw new Exception("shouldn't get here! ");
} catch (NotFound $nf) {
# blank
}
}
$columns = array();
foreach ($client->getColumnDescriptors($t) as $col => $desc) {
echo "column with name: {$desc->name}\n";
$columns[] = $desc->name . ":";
}
echo "Starting scanner...\n";
$scanner = $client->scannerOpenWithStop($t, "00020", "00040", $columns);
try {
while (true) {
printRow($client->scannerGet($scanner));
}
} catch (NotFound $nf) {
$client->scannerClose($scanner);
echo "Scanner finished\n";
}
$transport->close();
?>
</pre>
</body>
</html>
echo get_month_name($ref_date) . " " . get_year($ref_date) . "</div>";
if ($type == "PF") {
$loan_table = "PF_LOAN";
} else {
if ($type == "CUF") {
$loan_table = "CUF_LOAN";
} else {
die("Loantype unspecified !");
}
}
$result = mysql_query("select * from {$loan_table}", $db);
checkMySQLError();
beginPrettyTable("4", "{$loan_table}");
printRow(array("Emp_ID3", "Emp. Name", "LoanStart", "LoanEnd", "Loan-Amt", "Instalment", "Tot_Amt", "Due", "Balance"));
while ($row = mysql_fetch_array($result)) {
$name = $personal_array[$row["EMP_ID3"]];
$rest_inst_no = datediff("m", $ref_date, $row["LOAN_END"]);
$rest_amount = $rest_inst_no * $row["INT_RATE"];
if ($rest_inst_no < 0) {
continue;
}
$inst_sum += $rest_inst_no;
$rest_amount_sum += $rest_amount;
$loan_amount_sum += $row["LOAN_AMT"];
printRow(array($row["EMP_ID3"], $name, conv_to_hrd($row["LOAN_START"]), conv_to_hrd($row["LOAN_END"]), $row["LOAN_AMT"], $row["INT_RATE"], $row["TOT_AMT"], $rest_inst_no, $rest_amount), "fluct");
}
printRow(array("", "", "Loan-Amt-Sum: ", $loan_amount_sum), "", "3,2");
printRow(array("", "", "Inst-Sum: ", "", $inst_sum), "", "3,2");
printRow(array("", "", "Balance-Sum: ", "", "", "", "", $rest_amount_sum), "", "3,2");
endPrettyTable();
endDocument();
$orderby = "EMP_ID3";
}
# calculate received money by Employees
$result = mysql_query("select SUM(AMOUNT),AC_ID5 from TRANS WHERE AC_ID3=30 AND DR_CR='C' GROUP BY AC_ID5 order by PARTY", $db);
checkMySQLError();
while ($row = mysql_fetch_array($result)) {
$receive_array[$row["AC_ID5"]] = $row["SUM(AMOUNT)"];
}
# calculate paid_back money
$result = mysql_query("select SUM(AMOUNT),PARTY, AC_ID5 from TRANS WHERE AC_ID3=30 AND DR_CR='D' GROUP BY PARTY order by PARTY", $db);
checkMySQLError();
while ($row = mysql_fetch_array($result)) {
if (array_key_exists($row["AC_ID5"], $receive_array)) {
$receive_array[$row["AC_ID5"]] -= $row["SUM(AMOUNT)"];
}
}
beginPrettyTable("1", "Schedule of Advance as on " . get_today_hrd_string());
if (isset($receive_array)) {
printRow(array("Code", "Employer's name", "Amount"));
foreach ($receive_array as $key => $value) {
if ($value != 0) {
printRow(array("{$key}", get_ac5_desc_of($key), 0 - $value), "something");
}
$sum += 0 - $value;
}
printRow(array("", "Sum", $sum));
} else {
printRow(array("No Advance-money at anybody!"), "");
}
endPrettyTable();
endDocument();
++$j;
}
if (STATUS_INV != $recv_status) {
++$j;
}
++$i;
printf($template, $i, $a, $b, $c, $d, $e, $send_color, $send_status, $recv_color, $recv_status, $comment);
}
/* ---------------------------------------------------------------------- */
}
/* main --------------------------------------------------------------------- */
$i = 0;
$stats = array();
foreach ($openpgp as $a) {
foreach ($smime as $b) {
foreach ($message as $c) {
foreach ($attachment as $d) {
foreach ($receiver as $e) {
printRow($a, $b, $c, $d, $e, &$i, &$stats, &$result);
}
}
}
}
}
/* -------------------------------------------------------------------------- */
echo "\n";
echo " * Seems to work (<font color='" . COLOR_OK . "'>" . STATUS_OK . "</font>): " . $stats[STATUS_OK] . "\n";
echo " * To be tested (<font color='" . COLOR_TBT . "'>" . STATUS_TBT . "</font>): " . $stats[STATUS_TBT] . "\n";
echo " * Has issues (<font color='" . COLOR_ISSUE . "'>" . STATUS_ISSUE . "</font>): " . $stats[STATUS_ISSUE] . "\n";
//echo " * Not yet implemented (<font color='". COLOR_NYI ."'>" . STATUS_NYI ."</font>): ". $stats[STATUS_NYI] ."\n";
echo " * Combination not possible, out of scope or no testing needed (<font color='" . COLOR_INV . "'>" . STATUS_INV . "</font>): " . $stats[STATUS_INV] . "\n";
<?php
$userInfo = array('Име' => 'Николай Иванов', 'Потребителско Име' => 'mraiur', 'Email' => '*****@*****.**', 'ID' => '123');
echo "<table border=\"1\">";
foreach ($userInfo as $key => $value) {
printRow($key, $value);
}
echo "</table>";
function printRow($key, $value)
{
echo "<tr>";
echo "<td>" . $key . "</td>";
echo "<td>" . $value . "</td>";
echo "</tr>";
}
printRow(array("<hr>"), "", "1,6");
printRow(array("VR No", "VR Date", "Vr Type", "Particulars", "Debit", "Credit"));
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$row["VR_DT"] = conv_to_hrd($row["VR_DT"]);
if ($row["DR_CR"] == "D") {
$row["DR_CR"] = $row["AMOUNT"];
$row["AMOUNT"] = " ";
} else {
$row["DR_CR"] = " ";
}
printRow($row, "fluct");
}
printRow(array("", "", "DebitSum:", get_debit_sum("AC_ID5={$ac_name}", $enddate_srd, $startdate_srd)), "", "1,2");
printRow(array("", "", "CreditSum:", get_credit_sum("AC_ID5={$ac_name}", $enddate_srd, $startdate_srd)), "", "1,3");
printRow(array("<hr>"), "", "1,6");
printRow(array("closing Balance: " . get_closing_balance("AC_ID5={$ac_name}", $enddate_srd)), "", "1,3");
endPrettyTable();
mysql_close($db);
} else {
$ac_array = get_ac5_sc_array("5(1/2)");
?>
<table cellpadding=5 cellspacing=0 border=0 width='100%'>
<tr>
<td valign=top width='15%'>
<?php
beginPrettyTable("1");
?>
<tr>
<?php
break;
case 'QUESTION_NAME':
if (isContainsString($row[question_name], $searchQuery)) {
$isPrintRow = true;
}
break;
case 'RECOMMENDED':
if ($row[recommend]) {
$isPrintRow = true;
}
break;
default:
break;
}
if ($isPrintRow) {
printRow($row);
$isFoundSearchResults = true;
}
}
printQuestionsTableFooter();
//</printQuestions>
if (!$isFoundSearchResults) {
echo MESSAGE_NO_SEARCH_RESULTS;
}
} else {
echo MESSAGE_NO_DATA_SUBMITTED;
}
?>
<p><a href="index.php"><?php
echo MESSAGE_RETURN_TO_HOMEPAGE;
<?php
include_once '../function_header.php';
include '../common_server_functions.php';
//print_r($_REQUEST);
$responseCode = 0;
$supplier = $_REQUEST['supplier'];
if ($supplier == '0' || $supplier == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Please select a supplier', ''));
}
$material = $_REQUEST['material'];
if ($material == '0' || $material == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Please select a material', ''));
}
$price = $_REQUEST['price'];
if ($price == '0' || $price == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Please select a price', ''));
}
$info = $_REQUEST['info'];
//die(wrapError(-2,'Feature not ready'));
saveSupplierMaterial($conexion, $supplier, $material, $price, $info);
$materialInfo = mysql_fetch_assoc(mysql_query("SELECT * FROM material WHERE materialId = '{$material}'", $conexion));
$delImg = createActionIcon(IMG_DELETE, 'delete' . $supplier . "-" . $material, 'Delete Price', '../submit/deleteSupplierMaterial.php', 'supplier=' . $supplier . '&material=' . $material, 'delete', " width='22' height='22'");
$newLine = printRow('', array($materialInfo['materialName'], decimalPad($price), date('m/d/Y'), $delImg));
$response['code'] = 0;
$response['created'] = "";
$response['newLine'] = $newLine;
echo json_encode($response);
}
printRow(array("", "<b>total Receipts<b>", "<b>" . $transactions->getTotalReceipts() . "</b>"));
endPrettyTable();
# Payments
# generate Transaction-object
if ($ac_id1 != 0) {
$transactions = new Transactions($ac_id1, $startdate, $enddate);
} else {
$transactions = new Transactions_byProject("1", $startdate, $enddate);
}
beginPrettyTable("4", "Payments");
printRow(array("Code Number", "Description", "Amount", "VR-Type"));
while ($row = $transactions->getNextPayment()) {
printRow($row, "fluct");
}
printRow(array("", "<b>total Payments</b>", "<b>" . $transactions->getTotalPayments() . "</b>"));
printRow(array("", "<b>closing Balance:</b> ", "<b>" . $transactions->getClosingBalance() . "</b>"));
endPrettyTable();
} else {
$ac_array = get_ac_array(1);
$ac_array[0] = "ALL PROJECTS";
openForm("enter Date", $PHP_SELF);
beginPrettyTable("2", "Project Transactions");
makeDropBox("ac_id1", $ac_array, "Project");
makeTextField("startdate", get_today_hrd_string(), "Start Date:");
makeTextField("enddate", get_today_hrd_string(), "End Date:");
makeSubmitter();
endPrettyTable();
closeForm();
}
endDocument();
<th>Amount to Pay</th>
<th>Date</th>
<th></th>
</tr>
<?php
$reportTotal = getInvoiceTotal($reportId, $conexion);
$paidTotal = getInvoicePaid($reportId, $conexion);
$balance = decimalPad($reportTotal - $paidTotal);
$invoiceInfo = getCustomerInvoiceInfo($conexion, $reportId);
//Truck
$flag = true;
$credits = mysql_query("SELECT * FROM customer_credit JOIN customer_super_check USING (customerSuperCheckId) WHERE\tcustomerId = '" . $invoiceInfo['customerId'] . "'", $conexion);
while ($credit = mysql_fetch_assoc($credits)) {
$creditValue = decimalPad($credit['customerCreditAmount']);
echo printRow(($flag ? "class='bg'" : "") . " rowId='F" . $reportId . "W" . $credit['customerSuperCheckId'] . "' ", array($credit['customerSuperCheckNumber'], $creditValue, createInputText("paymentF" . $reportId . "W" . $credit['customerSuperCheckId'], '', "size='10px'", decimalPad($creditValue > $balance ? $balance : $creditValue)), createInputText("dateF" . $reportId . "W" . $credit['customerSuperCheckId'], "", "size='10px'", to_MDY($credit['customerSuperCheckDate'])), createInputHidden("checkF" . $reportId . "W" . $credit['customerSuperCheckId'], "", "size='10px'", $credit['customerSuperCheckId']) . " " . createInputHidden("numberF" . $reportId . "W" . $credit['customerSuperCheckId'], "", "size='10px'", $credit['customerSuperCheckNumber']) . " " . printImgLink(IMG_PAY, "customerPayable", "Pay with check " . $credit['customerSuperCheckNumber'], ' width="22" height="22"')));
$flag = !$flag;
//createInputText($id, $name = '', $attributes = '', $startingValue ='')
}
echo printRow(($flag ? "class='bg'" : "") . " rowId='F" . $reportId . "W0' ", array("Cash", "N/A", createInputText("paymentF" . $reportId . "W0", '', "size='10px'", decimalPad($balance)), createInputText("dateF" . $reportId . "W0", "", "size='10px'", date('m/d/Y')), createInputHidden("checkF" . $reportId . "W0", '', "size='10px'", "0") . " " . createInputHidden("numberF" . $reportId . "W0", '', "size='10px'", "Cash") . " " . printImgLink(IMG_PAY, "customerPayable", "Pay with cash", ' width="22" height="22"')));
?>
</table>
<table>
<tr>
<td><?php
echo createSimpleButton('submitButton', 'Submit');
?>
</td>
</tr>
</table>
</div>
while (sizeof($printrow) <= 15) {
$printrow[] = "0";
}
printRow($printrow);
reset($sal_el_array);
unset($printrow);
$printrow[] = $row["EMP_ID3"];
$printrow[] = $row["EMP_NAME"];
}
## perhaps should be here ?
#if ($row["SAL_ID"]==NULL) {
# for ($i=0;$i<14;$i++) $printrow[]="0";
# continue;
#}
#printrow(array("name is:".$emp_name));
#printrow(array("key vom array is ".key($sal_el_array)."und row sal_id is".$row["SAL_ID"]));
while (!is_bool(next($sal_el_array)) && key($sal_el_array) < $row["SAL_ID"]) {
printRow(array("inside loop :{$current}<br>"));
$printrow[] = "0";
#if (!next($sal_el_array))
# break;
if (key($sal_el_array) == $row["SAL_ID"]) {
break;
}
}
#next($sal_el_array);
$printrow[] = $row["SAL_AMT"];
}
endPrettyTable();
endBorderedTable();
endDocument();
$result = mysql_query("SHOW TABLES FROM {$DBNAME}");
checkMySQLError();
while ($row = mysql_fetch_array($result, $db)) {
$tablename = $row["Tables_in_{$DBNAME}"];
$filename = "/tmp/ac4ngosdata/" . $tablename . ".txt";
$query = "SELECT * FROM {$tablename} INTO OUTFILE \"{$filename}\"";
$result2 = mysql_query($query, $db);
checkMySQLError($query);
}
$today = get_today_srd_string();
$backup_filename = "ac4ngos-datadump-{$today}.tar.gz";
exec("cd /tmp; tar -czf {$backup_filename} ac4ngos/*");
$doc_root = $_SERVER["DOCUMENT_ROOT"];
copy("/tmp/{$backup_filename}", "{$doc_root}/crp/backups/{$backup_filename}");
echo "<a href=\"backups/{$backup_filename}\"> click here to download datadump</a>";
endPrettyTable();
beginPrettyTable("2", "the following datadumps are available as well:");
$handle = opendir("{$doc_root}/crp/backups/");
while (false !== ($filename = readdir($handle))) {
if (is_file("{$doc_root}/crp/backups/{$filename}")) {
printRow(array("<a href=\"backups/{$filename}\">{$filename}</a>"), "fluct");
}
}
closedir($handle);
## This is easier but it works only for > PHP 4.3.0
#chdir("$doc_root/crp/backups/");
#foreach (glob("*") as $filename) {
# printRow(array("<a href=\"backups/$filename\">$filename</a>"),"fluct");
#}
endPrettyTable();
endDocument();
$row = mysql_fetch_array($result, MYSQL_ASSOC);
if (!$row) {
die("No Voucher with this Number found!");
} 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");
function printTable($data, $fields, $row_classes, $cat, $child = 0)
{
foreach ($data as $count => $row) {
?>
<tr
class="
ds-list-item-new level-<?php
print $child;
?>
<?php
/* print ($child == 0?'ds-list-item-new':''); */
?>
">
<?php
printRow($row, $fields, $cat, $child + 1);
if (!empty($row['child'])) {
?>
</tr>
<?php
printTable($row['child'], $fields, $row_classes, $cat, $child + 1);
} else {
?>
</tr>
<?php
}
}
}
function printDefaultLayout()
{
for ($class = 1; $class < 9; $class++) {
printRow($class, "", True, True, True, True, True);
}
}
<?php
# Show Profile shows all the Customer Info, Invoices, Payments, Tickets,
# and a balance.
session_start();
require "accrp.php";
require "security/secure.php";
beginDocument($lCustomerProfile, $sess_user);
$db = getDBConnection();
#$result = mysql_query("select * from SAL_ID", $db);
#checkMySQLError();
beginPrettyTable("4", "Salary Elements");
#printRow(array("SAL_ID","Description","Income/Expense"));
$result = mysql_query("DROP TABLE test");
checkMySQLError();
$result = mysql_query("CREATE TABLE test (dummy int) TYPE=HEAP SELECT PERSONAL.EMP_ID3, EMP_NAME, SAL_ID FROM PERSONAL, SAL_ID");
checkMySQLError();
$query = "select * from test LEFT OUTER JOIN EMP_SAL USING(EMP_ID3, SAL_ID) ORDER BY test.EMP_ID3, test.SAL_ID";
$result = mysql_query($query, $db);
checkMySQLError();
while ($row = mysql_fetch_array($result)) {
unset($printrow);
$printrow["Name"] = $row["EMP_NAME"];
for ($i = 0; $i < 14; $i++, $row = mysql_fetch_array($result)) {
$printrow[] = $row["SAL_AMT"];
}
printRow($printrow);
}
endPrettyTable();
endDocument();
makeStaticField("desig_desc", get_designation_of($emp_id3), "Designation");
# Income-Positions
printRow(array("<div align=\"center\"><h2>INCOME</h2></div>"), "", "1,2");
foreach ($income_salary_elements_array_desc as $key => $value) {
makeTextField("salary_field_" . $key, $edit_salary["{$key}"], "{$value}", 10, "onFocus=\"editIncomeField(this.value)\" onChange=\"changedIncomeField(this.value) \"");
$income_sum += $edit_salary["{$key}"];
}
makeStaticField("income_sum", $income_sum, "Income Sum:", "", 11);
# Expense-Positions
printRow(array("<div align=\"center\"><h2>EXPENSE</h2></div>"), "", "1,2");
foreach ($expense_salary_elements_array_desc as $key => $value) {
makeTextField("salary_field_" . $key, $edit_salary["{$key}"], "{$value}", 10, "onFocus=\"editExpenseField(this.value)\" onChange=\"changedExpenseField(this.value) \"");
$expense_sum += $edit_salary["{$key}"];
}
makeStaticField("expense_sum", $expense_sum, "Expense Sum:", "", 11);
printRow(array("<hr>"), "", "1,2");
makeStaticField("total_sum", $income_sum - $expense_sum, "Total Sum:", "", 14);
makeSpecialSubmitter("submit", "onClick='this.form.submitnow.value=\"1\"'");
endPrettyTable();
closeForm();
?>
</td>
</table>
<?php
} else {
$personal_array = get_personal_array();
openForm("selectemployee", $PHP_SELF);
beginPrettyTable("2", "select Employee");
makeDropBox("emp_id3", $personal_array, "Employer Name");
makeSubmitter();
endPrettyTable();
function move_attachments()
{
$db =& JFactory::getDBO();
$db->setQuery('SELECT * FROM #__mt_cfvalues_att WHERE raw_filename = \'\' LIMIT 0, 50');
$atts = $db->loadObjectList();
foreach ($atts as $att) {
$file_extension = strrchr($att->filename, '.');
if ($file_extension === false) {
$file_extension = '';
}
$filepath = JPATH_COMPONENT_SITE . DS . 'attachments' . DS . $att->att_id . $file_extension;
$handle = fopen($filepath, 'w');
if (fwrite($handle, $att->filedata, $att->filesize) === FALSE) {
printRow('Cannot write to file at ' . $filepath, 1);
} else {
printRow('Attachment saved to ' . $filepath);
$db->setQuery('UPDATE #__mt_cfvalues_att SET raw_filename = \'' . $att->att_id . $file_extension . '\' WHERE att_id = ' . $att->att_id . ' LIMIT 1');
$db->query();
}
}
}
function printTable($data, $fields, $row_classes, $cat, $child = 0)
{
foreach ($data as $count => $row) {
?>
<tr class="<?php
print implode(' ', $row_classes[$count]);
?>
ds-list-item-new level-<?php
print $child;
?>
" >
<?php
printRow($row, $fields, $cat, $child + 1);
?>
</tr>
<?php
if (!empty($row['child'])) {
printTable($row['child'], $fields, $row_classes, $cat, $child + 1);
}
}
}
break;
}
} catch(e) {
alert("Internal Error: Please contact the administrator.");
}
},
async: true
});
}
</script>
<div id='formDiv' class='table'>
<img src="/mfi/img/bg-th-left.gif" width="8" height="7" alt="" class="left" />
<img src="/mfi/img/bg-th-right.gif" width="7" height="7" alt="" class="right" />
<table class="listing form" cellpadding="0" cellspacing="0">
<tr>
<th colspan='4'>Supplier Information</th>
</tr>
<?php
$flag = true;
//$vendorLink = printImgLink(IMG_VIEW, NYRO_CLASS, TITLE_VIEW_VENDOR, createGenericNyroableAttributesSmall($supplierInfo['vendorId'],'vendor'));
$materials = mysql_query("SELECT * FROM suppliermaterial JOIN material USING (materialId) WHERE supplierId = '{$supplierId}'", $conexion);
while ($material = mysql_fetch_assoc($materials)) {
$delImg = createActionIcon(IMG_DELETE, 'delete' . $supplierId . "-" . $material['materialId'], 'Delete Price', '../submit/deleteSupplierMaterial.php', 'supplier=' . $supplierId . '&material=' . $material['materialId'], 'delete', " width='22' height='22'");
echo printRow($flag ? "" : "class='bg'", array($material['materialName'], decimalPad($material['supplierMaterialPrice']), to_MDY($material['supplierMaterialLastModified']), $delImg));
$flag = !$flag;
}
echo printRow(" id='newPriceListItem' " . ($flag ? "" : "class='bg'"), array(arrayToSelect(materialsArray($conexion), '0', 'newPriceListMaterial', 'Material'), createInputText('newPriceListPrice', '', ''), '', createSimpleButton('saveNewPriceList', 'Submit')));
?>
</table>
</div>
function wrsqz_testGetVars(){
$questionId=999999999;
$program = '<session lang=\"en\" version=\"2.0\"><library closed=\"false\"><mtext style=\"color:#ffc800\" xml:lang=\"es\">variables</mtext><group><command><input><math xmlns=\"http://www.w3.org/1998/Math/MathML\"><mi>a</mi><mo>=</mo><mn>1</mn></math></input></command><command><input><math xmlns=\"http://www.w3.org/1998/Math/MathML\"><mi>p</mi><mo>=</mo><mi>plot</mi><mo>(</mo><mi>sin</mi><mo>(</mo><mi>random</mi><mo>(</mo><mn>0</mn><mo>.</mo><mn>5</mn><mo>,</mo><mn>2</mn><mo>.</mo><mn>0</mn><mo>)</mo><mo>*</mo><mi>x</mi><mo>)</mo><mo>)</mo></math></input></command></group></library></session>';
$data = new StdClass();
$data->question = $questionId;
$data->program = $program;
$programId=insert_record('question_wshanprom',$data);
$ok=true;
if($programId===false){
$ok=false;
$message = 'Error accessing database.';
}
$wiris = new StdClass();
$wiris->question=$questionId;
$wiris->idcache=0;
$wiris->md5=md5($program);
$wiris->eqoption='';
$data=array(
'seed' => rand(),
'text' => ' #p ##Ta',
'wiris' => $wiris
);
$result=wrsqz_getInfo('shortanswer',$questionId,$data);
if($result['vars']['##Ta']!='1'){
$ok = false;
$message = 'Error with numeric variable';
}else if(substr($result['vars']['##Wp'],0,7)!='<image>'){
$ok=false;
$message = 'Error with image variable';
}
if($ok){
$message = wrsqz_assemble('Variables retrieved sucessfully. Look at the plot #p', $result['vars']);
}
delete_records('question_wshanprom', 'question', $questionId);
printRow('Variables',$ok,$message);
}
