$total_credit = 0;
$balance = 0;
foreach ($page_list as $row) {
#Get the account title
$account_info = get_db_object_details($this, 'accounts', $row['account']);
#total debit
if ($row['cr_dr'] == 'CR') {
$total_credit += $row['amount'];
}
#total credit
if ($row['cr_dr'] == 'DR') {
$total_debit += $row['amount'];
}
$balance = $total_credit - $total_debit;
#Show one row at a time
echo "<tr class='listrow' style='" . get_row_color($counter, 2) . "'>\r\r\n <td class='leftListCell rightListCell' valign='top' nowrap>";
#if(check_user_access($this,'delete_deal')){
echo "<a href='javascript:void(0)' onclick=\"confirmDeleteEntity('" . base_url() . "finances/delete_transaction/i/" . encryptValue($row['transid']) . "', 'Are you sure you want to remove this fee? \\nThis operation can not be undone. \\nClick OK to confirm, \\nCancel to cancel this operation and stay on this page.');\" title=\"Click to remove this fee.\"><img src='" . base_url() . "images/delete.png' border='0'/></a>";
#}
#if(check_user_access($this,'update_deals')){
echo " <a href='" . base_url() . "finances/load_transaction_form/i/" . encryptValue($row['transid']) . "' title=\"Click to edit this fee details.\"><img src='" . base_url() . "images/edit.png' border='0'/></a>";
#}
echo "</td>\t\t\r\r\n <td valign='top'>" . date("j M, Y", GetTimeStamp($row['dateadded'])) . "</td>\t\t\r\r\n <td valign='top'>" . $account_info['title'] . "</td>\r\r\n <td valign='top'>" . $row['particulars'] . "</td>\t\t\t\t\r\r\n <td valign='top' class='number_format' align='right' nowrap>" . ($row['cr_dr'] == 'DR' ? number_format($row['amount'], 0, '.', ',') : '') . "</td>\t\t\r\r\n <td valign='top' class='number_format' align='right' nowrap>" . ($row['cr_dr'] == 'CR' ? number_format($row['amount'], 0, '.', ',') : '') . "</td>\r\r\n <td class='rightListCell number_format' valign='top' align='right' nowrap>" . number_format($balance, 0, '.', ',') . "</td>\t\t\r\r\n </tr>";
$counter++;
}
echo "<tr>\r\r\n<td colspan='5' align='right' class='layer_table_pagination'>" . pagination($this->session->userdata('search_total_results'), $rows_per_page, $current_list_page, base_url() . "finances/manage_petty_cash_book/p/%d") . "</td>\r\r\n</tr>\r\r\n</table>";
} else {
echo "<div>No transactions have been added.</div>";
}
?>
?>
</td>
</tr>
</table>
</div><br /><br />
<?php
#Show search results
if (!empty($page_list)) {
echo "<table width='100%' border='0' cellspacing='0' cellpadding='5'>\r\r\n \t<tr>\r\r\n\t\t\t<td class='listheader' nowrap>Date Borrowed</td>\r\r\n \t<td class='listheader' nowrap>Title</td>\r\r\n\t\t\t<td class='listheader' nowrap>Returned / Borrowed</td>\r\r\n\t\t\t<td class='listheader' nowrap>Name</td>\r\r\n\t\t\t\r\r\n\t\t\t<td class='listheader' nowrap>Date Expected</td>\r\r\n\t\t\t</tr>";
$counter = 0;
foreach ($page_list as $row) {
#check expiry of rental period
$currentdate = date("Y-m-d H:i:s");
$borrower_status = check_borrower_status($this, $row['borrowerid']);
#Show one row at a time
echo "<tr style='" . get_row_color($counter, 2) . "'>";
echo "\r\r\n\t\t\r\r\n\t\t<td valign='top'>" . date("j M, Y", GetTimeStamp($row['datetaken'])) . "</td>\r\r\n\t\t\r\r\n\t\t<td valign='top'>" . $row['stocktitle'] . "</td>'\r\r\n\t\t\r\r\n\t\t<td valign='top'>" . ($row['copiestaken'] - $borrower_status) . "/" . $row['copiestaken'] . "</td>\r\r\n\t\t\r\r\n\t\t<td valign='top'>" . $row['firstname'] . " " . $row['lastname'] . "</td>\r\r\n\t\t\r\r\n\t\t\r\r\n\t\t\r\r\n\t\t<td valign='top'>" . date("j M, Y", GetTimeStamp($row['returndate'])) . "</td>\r\r\n\t\t\r\r\n\t\t</tr>";
$counter++;
}
echo "<tr></table>";
} else {
echo format_notice("There are no borrowing data matching that criteria at the moment.");
}
?>
<br /><br />
<?php
$this->load->view('incl/footer');
?>
</body>
</html>
$total_credit = 0;
foreach ($page_list as $row) {
#Show one row at a time
if ($row['type'] == 'DEBIT') {
$debit = $row['amount'];
$credit = 0;
$balance -= $debit;
$total_debit += $debit;
} else {
$debit = 0;
$credit = $row['amount'];
$balance += $credit;
$total_credit += $credit;
}
$fee = get_fee_lines($this, $row['fee']);
echo "<tr class='listrow' style='" . get_row_color($counter, 2, 'row_borders') . "'>\r\r\n\t\t<td valign='top' nowrap>";
if (check_user_access($this, 'delete_deal')) {
echo "<a href='javascript:void(0)' onclick=\"confirmDeleteEntity('" . base_url() . "finances/delete_fee/i/" . encryptValue($row['id']) . "', 'Are you sure you want to remove this fee? \\nThis operation can not be undone. \\nClick OK to confirm, \\nCancel to cancel this operation and stay on this page.');\" title=\"Click to remove this fee.\"><img src='" . base_url() . "images/delete.png' border='0'/></a>";
}
#if(check_user_access($this,'update_deals')){
echo " <a href='#' title=\"Click to print this transaction details.\"><img src='" . base_url() . "images/small_pdf.png' border='0'/></a>";
#}
echo "</td>\r\r\n\t\t \t\t<td valign='top'>" . date("j M, Y", GetTimeStamp($row['dateadded'])) . "</td>\r\r\n\t\t\t\t<td valign='top'>" . $fee['fee'] . "</td>\r\r\n\t\t\t\t<td valign='top' nowrap align='right'>" . number_format($debit, 0, '.', ',') . "</td>\r\r\n\t\t\t\t<td valign='top' nowrap align='right'>" . number_format($credit, 0, '.', ',') . "</td>\r\r\n\t\t\t\t<td valign='top' nowrap align='right'>" . number_format($balance, 0, '.', ',') . "</td>\r\r\n\t\t\t</tr>";
$counter++;
}
echo "<tr>\r\r\n\t\t <td colspan='3'></td>\r\r\n\t\t <td><div class='sum'>" . number_format($total_debit, 0, '.', ',') . "</div></td>\r\r\n\t\t <td><div class='sum'>" . number_format($total_credit, 0, '.', ',') . "</div></td>\r\r\n\t\t <td style='padding-right:0'><div class='sum'>" . number_format(-($total_debit - $total_credit), 0, '.', ',') . "</div></td>\r\r\n\t\t </tr>";
echo "<tr>\r\r\n\t<td colspan='6' align='right' class='layer_table_pagination'>" . pagination($this->session->userdata('search_total_results'), $rows_per_page, $current_list_page, base_url() . "classes/manage_classes/p/%d") . "</td>\r\r\n\t</tr>\r\r\n\t</table>";
} else {
echo "<div>No transactions have been added.</div";
}
?>
//Format grading scale data
$grading_scale_info = '';
if (!empty($grading_scale_details)) {
$grading_scale_info = '<div><b>Grading scale details</b></div>' . '<table cellpadding="5" cellspacing="0">' . '<tr class="listheader">' . '<td>Range</td>' . '<td>Grade</td>' . '<td>Value</td>' . '</tr>';
$grade_counter = 0;
$js_grade_ranges = '';
foreach ($grading_scale_details as $grading_scale_detail) {
$grading_scale_info .= '<tr id="grade_scale_row_' . $grading_scale_detail['id'] . '" ' . ($grade_counter % 2 == 0 ? 'class="stripe grade_scale_row"' : 'class="grade_scale_row"') . '>' . '<td>' . $grading_scale_detail['mingrade'] . '-' . $grading_scale_detail['maxgrade'] . '</td>' . '<td>' . $grading_scale_detail['symbol'] . '</td>' . '<td>' . $grading_scale_detail['value'] . '</td>' . '</tr>';
$grade_counter++;
}
$grading_scale_info .= '</table>';
} else {
$grading_scale_info = '<div>' . format_notice('WARNING: No grading scale has been defined') . '</div>';
}
$average_mark = number_format($total_mark / $counter, 2);
echo '<tr>' . '<td colspan="4">' . '<input type="hidden" name="sm" value="' . encryptValue('true') . '" />' . '<input type="hidden" name="s" value="' . encryptValue($subject['id']) . '" />' . '<input type="hidden" name="c" value="' . encryptValue($class['id']) . '" />' . '<input type="hidden" name="e" value="' . (!empty($exam['id']) ? encryptValue($exam['id']) : '') . '" />' . '</td></tr>' . '<tr>' . '<td align="right"><b>Average Mark: </b></td>' . '<td colspan="3">' . '<input type="test" size="4" class="average_mark" readonly="readonly" value="' . $average_mark . '" id="average-mark" />' . '</td></tr>' . '<tr><td colspan="4"> </td></tr>' . '<tr><td colspan="4"><input type="button" value="Save" id="save-marks" class="button" /></td></tr>' . '<tr><td colspan="4"> </td></tr>' . '<tr><td colspan="4">' . $grading_scale_info . '</td></tr>';
} else {
$counter = 0;
foreach ($page_list as $row) {
echo '<tr class="mark_sheet_row" id="student_grades_' . $row['studentid'] . '" style="' . get_row_color($counter, 2) . '">
<td colspan="4"><div>' . $row['studentname'] . '</div></td>
</tr>';
$counter++;
}
}
} else {
echo '<tr><td colspan="3">' . format_notice('WARNING: No ' . $class['class'] . ' students have been registered for ' . $subject['subject'] . ' in ' . $term['term'] . ', ' . $term['year']) . '</td></tr>';
}
?>
</table>
</table>
</td>
</tr>
<tr>
<td>
<div id="searchresults">
<?php
#Show search results
if (!empty($page_list)) {
echo "<table width='100%' border='0' cellspacing='0' cellpadding='5'>\r\r\n \t<tr>\r\r\n\t\t\t<td class='listheader'> </td>\r\r\n\t\t\t<td class='listheader' nowrap>Date Returned</td>\r\r\n\t\t\t<td class='listheader' nowrap>Title</td>\r\r\n\t\t\t<td class='listheader' nowrap>Serial Number</td>\r\r\n\t\t\t</tr>";
$counter = 0;
foreach ($page_list as $row) {
#check expiry of rental period
$currentdate = date("Y-m-d H:i:s");
#Show one row at a time
echo "<tr style='" . get_row_color($counter, 2) . "'>\r\r\n\t\t\t<td valign='top' nowrap>";
if (1) {
echo "<a href='javascript:void(0)' onclick=\"confirmDeleteEntity('" . base_url() . "library/delete_return/i/" . encryptValue($row['returnid']) . "', 'Are you sure you want to remove this borrower? \\nThis operation can not be undone. \\nClick OK to confirm, \\nCancel to cancel this operation and stay on this page.');\" title=\"Click to remove this borrower.\"><img src='" . base_url() . "images/delete.png' border='0'/></a>";
}
if (1) {
echo " <a href='" . base_url() . "library/return_rental/i/" . encryptValue($row['returnid']) . "/s/" . encryptValue($row['stockid']) . "' title=\"Click to edit this return.\"><img src='" . base_url() . "images/edit.png' border='0'/></a>";
}
echo "</td>\r\r\n\t\t\r\r\n\t\t<td valign='top'>" . date("j M, Y", GetTimeStamp($row['returndate'])) . "</td>\r\r\n\t\t\r\r\n\t\t<td valign='top'><a class=\"fancybox fancybox.ajax\" href='" . base_url() . "library/load_stock_form/i/" . encryptValue($row['stockid']) . "/a/" . encryptValue("view") . "' title=\"Click to view this stock item.\">" . $row['stocktitle'] . "</a></td>\r\r\n\t\t\r\r\n\t\t<td valign='top'><a class=\"fancybox fancybox.ajax\" href='" . base_url() . "library/load_stock_item_form/i/" . encryptValue($row['item']) . "/a/" . encryptValue("view") . "/s/" . encryptValue($row['stockid']) . "' title=\"Click to view this item.\">" . $row['serialnumber'] . "</a></td>\r\r\n\t\t\r\r\n\t\t</tr>";
$counter++;
}
echo "<tr>\r\r\n\t<td colspan='5' align='right' class='layer_table_pagination'>" . pagination($this->session->userdata('search_total_results'), $rows_per_page, $current_list_page, base_url() . "library/manage_borrowers/p/%d") . "</td>\r\r\n\t</tr>\r\r\n\t</table>";
} else {
echo format_notice("There is no return at the moment.");
}
?>
</div>
}
?>
<tr>
<td valign="top">
<?php
if (count($teachers)) {
$counter = 0;
echo '<table cellpadding="5">
<tr class="listheader">
<td></td>
<td align="left" >Teacher</td>
<td align="left" >Class</td>
</tr>';
foreach ($teachers as $teacher) {
echo '<tr style=\'' . get_row_color($counter, 2) . '\'>' . '<td><a href="javascript:void(0)" onclick="confirmDeleteEntity(\'' . base_url() . 'curriculum/delete_subject/i/' . encryptValue($teacher['assignmentid']) . '\', \'Are you sure you want to remove this teacher? \\nThis operation can not be undone. \\nClick OK to confirm, \\nCancel to cancel this operation and stay on this page.\');" title="Click to remove "' . $teacher['teacher'] . '"><img src="' . base_url() . 'images/delete.png" border=0 /></a></td>' . '<td align="left">' . $teacher['teacher'] . '</td>' . '<td align="left" >' . $teacher['class'] . '</td>' . '</tr>';
$counter++;
}
echo '</table>';
} else {
echo 'No teachers have been assigned for ' . $subject_details['subject'];
}
?>
</td>
</tr>
</table>
</td>
</tr>
$table_HTML = "<table width='100%' border='0' cellspacing='0' cellpadding='4'>" . "<tr>" . " <td colspan='4'><hr /></td>" . "</tr>" . "<tr>" . "<td> </td>" . "<td nowrap><b>Page</b></td>" . "<td nowrap><b>Help Topic</b></td>" . "<td nowrap><b>Help Content</b></td>" . "</tr>" . "<tr>" . "<td colspan='4'><hr /></td>" . "</tr>";
}
$counter = 0;
foreach ($searchdata as $row) {
if (isset($inpop)) {
$table_HTML .= "<tr style='" . get_row_color($counter, 2) . "'><td nowrap><a href=\"javascript:showFormLayer('" . base_url() . "index.php/settings/acravhelp/load_form/id/" . $row['id'] . "/ispop/Y/layername/" . $row['id'] . "_div','" . $row['id'] . "_div')\">" . $row['topic'] . "</a><br>" . "<div id='" . $row['id'] . "_div' style='visibility:hidden; height:0px'></div>" . "</td></tr>";
} else {
$table_HTML .= "<tr style='" . get_row_color($counter, 2) . "'>" . "<td width='1%' valign='top' nowrap>[ <a href='" . base_url() . "index.php/settings/acravhelp/load_form/id/" . $row['id'] . "'>Edit</a>" . " | <a href=\"javascript:deleteEntity('" . base_url() . "index.php/settings/acravhelp/delete_help_data/id/" . $row['id'] . "','help topic','" . $row['topic'] . "');\">Delete</a> ]</td>" . "<td width='1%' valign='top'>" . $row['page'] . "</td>" . "<td width='1%' valign='top'>" . $row['topic'] . "</td>" . "<td width='97%' valign='top'>" . format_to_length($row['content'], 200) . "</td>" . "</tr>";
}
$counter++;
}
$table_HTML .= "</table>";
} else {
if ($area == 'searchdetails') {
$table_HTML = "<table width='100%' border='0' cellspacing='0' cellpadding='4'>" . "<tr><td><input name='closediv' type='button' id='closediv' value='Close' " . "onclick=\"hideDiv('" . $layername . "')\" class='button'/></td></tr>" . "<tr><td>" . $helpdetails['content'] . "</td></tr>" . "</table>";
} else {
if ($area == 'templaterights') {
$table_HTML = "<table width='100%' border='0' cellspacing='0' cellpadding='4'>" . "<tr><td><b>User Rights for Template \"" . format_user_type($value) . "\"</b></td></tr>";
$i = 0;
#Show the rights
foreach ($rights as $rightdefn) {
$table_HTML .= "<tr style='" . get_row_color($i, 2) . "'><td>" . $rightdefn['definition'] . "</td></tr>";
$i++;
}
$table_HTML .= "</table>";
}
}
}
}
}
echo $table_HTML;
</td>
</tr>
<?php
if (!empty($page_list)) {
?>
<tr>
<td colspan="3" nowrap>
<b>Content List:</b><br />
<div id="sortable" class='selectfield' style='background: #F2F4F4;width:100%;'>
<?php
$counter = 0;
foreach ($page_list as $row) {
#Show one row at a time
echo "<div class='ui-state-default'>\r\r\n\t\t<table style='" . get_row_color($counter, 2) . "' width='100%'>\r\r\n\t\t<tr>\r\r\n \t<td valign='top' width='1%'>\r\r\n\t\t<a href='javascript:void(0)' onclick=\"confirmDeleteEntity('" . base_url() . "help/remove_help_item/i/" . encryptValue($row['id']) . "/t/" . encryptValue($row['topiccode']) . "', 'Are you sure you want to remove this help item? \\nThis operation can not be undone. \\nClick OK to confirm, \\nCancel to cancel this operation and stay on this page.');\" title='Click to remove this help item.'><img src='" . base_url() . "images/delete.png' border='0'/></a>\r\r\n\t\t<input type='hidden' name='helpitem[]' value='" . $row['id'] . "' />\r\r\n\t\t</td>\r\r\n\t\r\r\n \t<td width='98%' align='left'>";
if (!empty($row['fileurl'])) {
if (strtolower(strrchr($row['fileurl'], ".")) == '.swf') {
echo "<a href=\"javascript:void(0)\" onclick=\"updateFieldLayer('" . base_url() . "page/view_video/f/" . encryptValue('documents') . "/u/" . encryptValue($row['fileurl']) . "', '', '', '_', '')\" class='bluelink'>View Larger Video</a>\r\r\n\t\t\t\t<br>\r\r\n\t\t\t\t<object id=\"movie\" type=\"application/x-shockwave-flash\" data=\"" . base_url() . "downloads/documents/" . $row['fileurl'] . "\" style=\"width: 400px; height: 250px;\">\r\r\n\t<embed src=\"" . base_url() . "downloads/documents/" . $row['fileurl'] . "\" type=\"application/x-shockwave-flash\" width=\"400\" height=\"100%\" allowScriptAccess=\"sameDomain\" pluginspage=\"http://get.adobe.com/de/flashplayer/\"></embed>\r\r\n</object>\r\r\n<br>";
} else {
if (is_file_an_image(UPLOAD_DIRECTORY . "documents/" . $row['fileurl'])) {
$WIDTH = 600;
$img_properties = minimize_image(UPLOAD_DIRECTORY . "documents/" . $row['fileurl'], '', $WIDTH);
$imgwidth = $img_properties['actualwidth'] < $WIDTH ? $img_properties['actualwidth'] : $WIDTH;
echo "<a href='javascript:void(0)' onclick=\"updateFieldLayer('" . base_url() . "downloads/documents/" . $row['fileurl'] . "','','','_','')\"><img src='" . base_url() . "downloads/documents/" . $row['fileurl'] . "' width='" . $imgwidth . "' border='0'></a>\r\r\n\t\t\t\t\t <br>";
} else {
echo "<br><a href='" . base_url() . "documents/force_download/u/" . encryptValue($row['fileurl']) . "/f/" . encryptValue('documents') . "' class='bluelink'><img src='" . base_url() . "images/" . get_doc_logo($row['fileurl']) . "' border='0'>\r\r\n\t\t\t \r\r\n\t\t\tDownload Document</a><br>";
}
}
}
if (!empty($row['helplink'])) {
{
$peek_counter++;
}
}
*/
$counter = 0;
$oldsection = "";
foreach ($all_permissions as $row) {
$section = $row['section'];
if ($section != $oldsection) {
if ($oldsection != '') {
echo "</table></div><br>";
}
echo "<a href=\"javascript:showHideLayer('" . $row['section'] . "_div')\" class='bluelink'>" . ucfirst($row['section']) . "</a><hr><div id='" . $row['section'] . "_div' style='display:none'>\r\r\n\t\t\t\t\t\t \r\r\n\t\t\t\t\t\t <table width='100%' border='0' cellspacing='0' cellpadding='3'>";
}
echo "<tr style='" . get_row_color($counter, 2) . "'>\r\r\n <td style='font-size: 13px;' width='1%' nowrap><input name='permissions[]' id='permission_" . $row['id'] . "' onClick=\"selectCheckBoxListWithUncheck('permission_" . $row['id'] . "', '" . get_related_permissions($this, $row['id']) . "', '" . get_related_permissions($this, $row['id'], 'uncheck') . "', 'permission_')\" type='checkbox' value='" . $row['id'] . "'";
if (in_array($row['id'], $permissions_list)) {
echo " checked";
}
echo "/></td>\r\r\n <td style='font-size: 13px;' width='99%' nowrap><label for='permission_" . $row['id'] . "'>" . $row['permission'] . "</label></td>\r\r\n </tr>";
if ($counter == count($all_permissions) - 1) {
echo "</table></div>";
}
$oldsection = $row['section'];
$counter++;
}
?>
</td></tr>
</table> </td>
</tr>
<table class="table table-hover screws-rows">
<thead>
<tr>
<th class="text-center">Screw</th>
<th class="text-center">Instructions</th>
</tr>
</thead>
<tbody>
<?php
for ($i = 0; $i < 4; $i++) {
?>
<tr class="<?php
echo get_row_color($screws[$i]['s']);
?>
">
<td class="text-center"><span class="badge badge <?php
echo get_color($screws[$i]['s']);
?>
"><?php
echo $i + 1;
?>
</span></td>
<td><strong><?php
echo get_rotation_number($screws[$i]['t']);
?>
<?php
echo get_direction($screws[$i]['s']);
?>
$selected = restore_bad_chars($sectionname);
$options = array_merge(array(array('fileunder' => $selected)), $options);
$table_HTML .= get_select_options($options, 'fileunder', 'fileunder', '');
$table_HTML .= "</select>";
} else {
$table_HTML .= "<table class='lightgreybg'>\r\r\n\t\t<tr>\r\r\n\t\t<td class='label'>New Section:</td>\r\r\n\t\t<td><input name='sectionname' type='text' id='sectionname' size='18' class='textfield' value='' /></td>\r\r\n\t\t<td><input type='button' name='addsection' id='addsection' value='Add' class='bodybutton' onclick=\"updateFieldLayer('" . base_url() . "deal/add_section/a/" . encryptValue('add') . "', 'sectionname', 'newsectiondetails', 'fileunderdiv', 'Enter the new section name.')\" /></td>\r\r\n\t\t<td>\r\r\n\t\t<input type='button' name='canceladdn' id='canceladdn' value='Cancel' class='bodybutton' onclick=\"unhideShowLayer('newsec','');absHideDiv('newsectiondetails');\" />\r\r\n\t\t</td>\r\r\n\t\t</tr>\r\r\n\t\t</table>";
}
} else {
if (!empty($area) && $area == 'select_order_user') {
$table_HTML .= $combined_js_HTML;
if (!empty($page_list)) {
$table_HTML .= "<table cellpadding='5' cellspacing='0' border='0'>\r\r\n\t\t<tr><td><b>Top " . NUM_OF_ROWS_PER_PAGE . " Search Results:</b></td><td align='right'><a href='javascript:void(0)' onClick=\"hideLayerSet('" . $layer . "')\"><img src='" . base_url() . "images/delete_icon.png' border='0' /></a></td></tr>";
$counter = 0;
foreach ($page_list as $row) {
#Show one row at a time
$table_HTML .= "<tr style='" . get_row_color($counter, 2) . "'><td colspan='2'><a href='javascript:void(0)' onClick=\"updateFieldLayer('" . base_url() . "deal/add_single_order/d/" . $d . "/u/" . encryptValue($row['id']) . "', '', '', '', '');hideLayerSet('" . $layer . "')\" class='bluelinks'>" . $row['firstname'] . " " . $row['lastname'] . "</a> (" . $row['emailaddress'] . ")</td></tr>";
$counter++;
}
$table_HTML .= "</table>";
} else {
$table_HTML .= "<table><tr><td align='right'><a href='javascript:void(0)' onclick=\"hideLayerSet('" . $layer . "')\"><img src='" . base_url() . "images/delete_icon.png' border='0'/></a></td></tr>\r\r\n\t\t<tr><td>" . format_notice("No user meets search.") . "</td></tr></table>";
}
}
}
}
}
}
}
}
}
}
<td><input type="button" name="search" id="search" value="Search" class="bodybutton"/></td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<div id="searchresults">
<?php
#Show search results
if (!empty($page_list)) {
echo "<table width='100%' border='0' cellspacing='0' cellpadding='5'>\r\r\n \t<tr>\r\r\n\t\t\t<td class='listheader'> </td>\r\r\n\t\t\t<td class='listheader'>Help Topic</td>\r\r\n \t<td class='listheader' nowrap>Last Updated</td>\r\r\n\t\t\t</tr>";
$counter = 0;
foreach ($page_list as $row) {
#Show one row at a time
echo "<tr style='" . get_row_color($counter, 2) . "'>\r\r\n\t\t\t\t<td width='1%'>";
if (check_user_access($this, 'update_help_topic')) {
echo "<a href='" . base_url() . "help/add_help_topic/i/" . encryptValue($row['topiccode']) . "' title=\"Click to edit this help topic.\"><img src='" . base_url() . "images/edit.png' border='0'/></a>";
}
echo "</td>\r\r\n\t\t\t\t\r\r\n\t\t\t\t<td width='1%' valign='top' nowrap><a href='" . base_url() . "help/view_help_topic/i/" . encryptValue($row['topiccode']) . "' class='fancybox fancybox.ajax bluelink'>" . $row['helptopic'] . "</a></td>\r\r\n\t\t\t\t\r\r\n <td width='98%'>" . date('m/d/Y h:iA', strtotime($row['lastupdateddate'])) . "</td>\r\r\n\t\t\t</tr>";
$counter++;
}
echo "<tr>\r\r\n\t<td colspan='3' align='center' class='layer_table_pagination' nowrap>" . pagination($this->session->userdata('search_total_results'), $rows_per_page, $current_list_page, base_url() . "help/manage_help/p/%d") . "</td>\r\r\n\t</tr>\r\r\n\t</table>";
} else {
echo format_notice("There is no help at the moment.");
}
?>
</div>
</td>
</tr>
function print_student_statement()
{
access_control($this);
# Get the passed details into the url data array if any
$urldata = $this->uri->uri_to_assoc(3, array('m', 'i'));
# Pick all assigned data
$data = assign_to_data($urldata);
#Get the student's details
$studentid = decryptValue($data['i']);
$data['studentdetails'] = $this->Query_reader->get_row_as_array('get_students_list', array('isactive' => 'Y', 'limittext' => '', 'searchstring' => ' AND id = ' . $studentid));
#Check if the student belongs to the current user's school
if ($data['studentdetails']['school'] != $this->myschool['id']) {
$data['studentdetails'] = array();
$studentid = '';
$data['msg'] = 'ERROR : The student data could not be found.';
}
#Get student's finances
$query = $this->Query_reader->get_query_by_code('search_student_accounts', array('isactive' => 'Y', 'limittext' => '', 'searchstring' => ' AND student = ' . $studentid));
$query_results = $this->db->query($query);
$financial_details = $query_results->result_array();
#Format the statement
$report_html = '';
#$financial_details = array();
if (!empty($financial_details)) {
$report_html = "<table width='100%' border='0' cellspacing='0' cellpadding='5'>\n \t\t `\t\t\t<tr>\n\t\t\t\t \t\t\t\t<td class='listheader'>Date</td>\n \t\t \t\t\t\t<td class='listheader' nowrap>Particulars</td>\n\t\t\t\t \t\t\t\t<td class='listheader' nowrap align='right'>Debit</td>\n\t\t\t\t \t\t\t\t<td class='listheader' nowrap align='right'>Credit</td>\n \t\t \t\t\t\t<td class='listheader' nowrap align='right'>Balance</td>\n\t\t\t\t \t\t </tr>";
$counter = 0;
$balance = 0;
$total_debit = 0;
$total_credit = 0;
foreach ($financial_details as $row) {
#Show one row at a time
if ($row['type'] == 'DEBIT') {
$debit = $row['amount'];
$credit = 0;
$balance -= $debit;
$total_debit += $debit;
} else {
$debit = 0;
$credit = $row['amount'];
$balance += $credit;
$total_credit += $credit;
}
$fee = get_fee_lines($this, $row['fee']);
$report_html .= "<tr style='" . get_row_color($counter, 2) . "'>\t\t\n\t\t \t\t\t\t\t\t<td valign='top'>" . date("j M, Y", GetTimeStamp($row['dateadded'])) . "</td>\n\t\t\t\t\t\t\t\t<td valign='top'>" . $fee['fee'] . "</td>\t\t\n\t\t\t\t\t\t\t\t<td valign='top' nowrap align='right'>" . number_format($debit, 0, '.', ',') . "</td>\n\t\t\t\t\t\t\t\t<td valign='top' nowrap align='right'>" . number_format($credit, 0, '.', ',') . "</td>\t\t\t\t\n\t\t\t\t\t\t\t\t<td valign='top' nowrap align='right'>" . number_format($balance, 0, '.', ',') . "</td>\t\n\t\t\t\t\t\t\t\t</tr>";
$counter++;
}
$report_html .= "<tr>\n\t\t \t\t\t\t\t<td colspan='2'></td>\n\t\t \t\t\t\t\t<td nowrap align='right'><div>" . number_format($total_debit, 0, '.', ',') . "</div></td>\n\t\t \t\t\t\t\t<td nowrap align='right'><div>" . number_format($total_credit, 0, '.', ',') . "</div></td>\n\t\t \t\t\t\t\t<td style='padding-right:0' nowrap align='right'><div class='sum'>" . number_format(-($total_debit - $total_credit), 0, '.', ',') . "</div></td>\n\t\t \t\t\t\t\t</tr></table>";
} else {
$report_html .= "<div>No transactions have been added.</div";
}
$this->load->library('parser');
$data['report_html'] = $report_html;
$output = $this->parser->parse('incl/print_data', $data, true);
gen_pdf($this, $output);
#$this->load->view('incl/print_data', $data);
}
<?php
#$page_list = array();
if (!empty($page_list)) {
echo "<table width='100%' border='0' cellspacing='0' cellpadding='5'>\r\r\n \t<tr>\r\r\n\t\t\t<td class='listheader'> </td>\r\r\n \t<td class='listheader' nowrap>Class <a class='fancybox fancybox.ajax' href='" . base_url() . "classes/load_class_form')' title='Click to add a class'><img src='" . base_url() . "images/add_item.png' border='0'/></a></td>\r\r\n\t\t\t<td class='listheader' nowrap>Rank</td>\r\r\n \t<td class='listheader' nowrap>Students</td>\r\r\n\t\t\t<td class='listheader' nowrap>Streams</td>\r\r\n\t\t\t<td class='listheader' nowrap>Date Added</td>\r\r\n\t\t\t</tr>";
$counter = 0;
foreach ($page_list as $row) {
#Show one row at a time
echo "<tr id='tr_" . $row['classid'] . "' class='listrow' style='" . get_row_color($counter, 2) . "'>\r\r\n\t\t<td class='leftListCell rightListCell' valign='bottom' width='1%' nowrap>";
#if(check_user_access($this,'delete_deal')){
echo "<a href='javascript:void(0)' onclick=\"asynchDelete('" . base_url() . "classes/delete_class/i/" . encryptValue($row['classid']) . "', 'Are you sure you want to remove this class? \\nThis operation can not be undone. \\nClick OK to confirm, \\nCancel to cancel this operation and stay on this page.', 'tr_" . $row['classid'] . "');\" title=\"Click to remove this class.\"><img src='" . base_url() . "images/delete.png' border='0'/></a>";
#}
#if(check_user_access($this,'update_deals')){
echo " <a href='" . base_url() . "classes/load_class_form/i/" . encryptValue($row['classid']) . "' title=\"Click to edit this class details.\"><img src='" . base_url() . "images/edit.png' border='0'/></a>";
#}
echo "</td>\t\t\r\r\n\t\t\t\t<td valign='top'>" . $row['classname'] . "</td>\t\t\r\r\n\t\t\t\t<td valign='top'>" . $row['rank'] . "</td>\t\t\t\t\r\r\n\t\t\t\t<td valign='top' nowrap>" . $row['numOfStudents'] . "</td>\t\t\r\r\n\t\t\t\t<td valign='top'>0 | <a href=\"#\">Add stream</a></td>\r\r\n\t\t\t\t<td class='rightListCell' valign='top'>" . date("j M, Y", GetTimeStamp($row['classdateadded'])) . "</td>\t\t\r\r\n\t\t\t</tr>";
$counter++;
}
echo "<tr>\r\r\n\t<td colspan='5' align='right' class='layer_table_pagination'>" . pagination($this->session->userdata('search_total_results'), $rows_per_page, $current_list_page, base_url() . "classes/manage_classes/p/%d", 'results') . "</td>\r\r\n\t</tr>\r\r\n\t</table>";
} else {
echo "<div>No classes have been added. Click <a class='fancybox fancybox.ajax' href='" . base_url() . "classes/load_class_form')' title='Click to add a class'><i>here</i></a> to add a class</div>";
}
<tr>
<td valign="top">
<?php
#$page_list = array();
if (!empty($page_list)) {
echo "<table width='100%' border='0' cellspacing='0' cellpadding='5'>\r\r\n \t<tr>\r\r\n\t\t\t<td class='listheader' width='1%'> </td>\r\r\n \t<td class='listheader' nowrap>Group <a class='fancybox fancybox.ajax' href='" . base_url() . "user/load_staff_groups_form')' title='Click to add a user'><img src='" . base_url() . "images/add_item.png' border='0'/></a></td>\r\r\n\t\t\t<td class='listheader' nowrap>Comments</td>\r\r\n\t\t\t<td class='listheader' nowrap>Staff</td>\r\r\n\t\t\t<td class='listheader' nowrap>Date Added</td>\r\r\n\t\t\t</tr>";
$counter = 0;
foreach ($page_list as $row) {
#Get number of users in each group
$staff = get_group_members($this, $row['id']);
#Show one row at a time
echo "<tr id='listrow-" . $row['id'] . "' class='listrow' style='" . get_row_color($counter, 2) . "'>\r\r\n\t\t<td class='leftListCell rightListCell' valign='top' nowrap>";
#if(check_user_access($this,'delete_deal')){
echo "<a href='javascript:void(0)' onclick=\"asynchDelete('" . base_url() . "user/delete_staff_group/i/" . encryptValue($row['id']) . "', 'Are you sure you want to remove this staff group? \\nThis operation can not be undone. \\nClick OK to confirm, \\nCancel to cancel this operation and stay on this page.','listrow-" . $row['id'] . "');\" title=\"Click to remove this staff group.\"><img src='" . base_url() . "images/delete.png' border='0'/></a>";
#}
#if(check_user_access($this,'update_deals')){
echo " <a class='fancybox fancybox.ajax' href='" . base_url() . "user/load_staff_groups_form/i/" . encryptValue($row['id']) . "' title=\"Click to edit this group's details.\"><img src='" . base_url() . "images/edit.png' border='0'/></a>";
#}
#if(check_user_access($this,'update_deals')){
echo " <a class='fancybox fancybox.ajax' href='" . base_url() . "user/manage_staff_group_rights/i/" . encryptValue($row['id']) . "' title=\"Click to edit this group's rights.\"><img src='" . base_url() . "images/user_group_settings.png' border='0'/></a>";
#}
echo "</td>\t\t\r\r\n\t\t\t\t<td valign='top'>" . $row['groupname'] . "</td>\t\t\r\r\n\t\t\t\t<td valign='top'>" . substr($row['comments'], 0, 20) . "..</td>\r\r\n\t\t\t\t<td valign='top'>" . $staff->num_rows() . "</td>\r\r\n\t\t\t\t<td class='rightListCell' valign='top'>" . date("j M, Y", GetTimeStamp($row['dateadded'])) . "</td>\t\t\r\r\n\t\t\t</tr>";
$counter++;
}
echo "<tr>\r\r\n\t\t<td colspan='5' align='right' class='layer_table_pagination'>" . pagination($this->session->userdata('search_total_results'), $rows_per_page, $current_list_page, base_url() . "user/manage_staff_groups/p/%d", "user-groups-results") . "</td></tr></table>";
} else {
echo "<div>No staff groups have been created.<br />Click <a class='fancybox fancybox.ajax' href='" . base_url() . "user/load_staff_groups_form')' title='Click to add a user'><i>here</i></a> to create a staff group</div>";
<td width="99%" style="padding:0px;" nowrap><?php
echo "<table border='0' cellspacing='0' cellpadding='5'>\r\r\n\t\t\t\t\t<tr><td><div id='addtogroup'></div></td></tr>\r\r\n\t\t\t\t\t<tr><td>\r\r\n\t\t\t\t\t\r\r\n\t\t\t\t\t<table border='0' cellspacing='0' cellpadding='5'>\r\r\n\t\t\t\t\t<tr><td class='lightgreybg'><b>Users in this Group:</b></td>\r\r\n\t\t\t\t\t<td align='right' class='lightgreybg'><a href='javascript:void(0)' onClick=\"updateFieldLayer('" . base_url() . "user/add_user_to_group/layer/addtogroup";
#If the user is editing
if (!empty($formdata['groupname'])) {
echo "/gn/" . encryptValue($formdata['groupname']) . "',''";
} else {
echo "','groupname'";
}
echo ",'','addtogroup','Enter a group name.');\" title=\"Click to add a user to the email list.\"><img src='" . base_url() . "images/add_icon.png' border='0'/></a></td></tr>\r\r\n\t\t\t\t\t\r\r\n\t\t\t\t\t<tr><td colspan='2' style='padding:0px;'>\r\r\n\t\t\t\t\t<div id='emailgrouplist'>";
$userlist = array();
if (!empty($page_list)) {
echo "<table width='100%' border='0' cellspacing='0' cellpadding='5'>\r\r\n\t\t\t\t\t<tr>\r\r\n\t\t\t<td class='listheader'> </td>\r\r\n \t<td class='listheader' nowrap>Name</td>\r\r\n\t\t\t<td class='listheader' nowrap>Email</td>\r\r\n\t\t\t</tr>";
$counter = 0;
foreach ($page_list as $row) {
array_push($userlist, $row['userid']);
echo "<tr style='" . get_row_color($counter, 2) . "'>\r\r\n\t\t<td valign='top' nowrap><a href='javascript:void(0)' onclick=\"confirmDeleteEntity('" . base_url() . "user/remove_user_from_group/i/" . encryptValue($row['id']) . "/gn/" . encryptValue($row['groupname']) . "', 'Are you sure you want to remove this user from the group? \\nThis operation can not be undone. \\nClick OK to confirm, \\nCancel to cancel this operation and stay on this page.');\" title=\"Click to remove this user from the group.\"><img src='" . base_url() . "images/delete.png' border='0'/></a></td>\r\r\n\t\t\r\r\n\t\t\t\t\t\t\t<td valign='top'>" . $row['firstname'] . " " . $row['lastname'] . "</td>\r\r\n\t\t\r\r\n\t\t\t\t\t\t\t<td valign='top'>" . $row['emailaddress'] . "</td>\r\r\n\t\t\t\t\t\t</tr>";
$counter++;
}
echo "</table>";
} else {
echo format_notice("There are no users in this email group yet.");
}
#Add the user to the user group list
$this->session->set_userdata('usergrouplist', $userlist);
echo "</div>\r\r\n\t\t\t\t\t</td></tr></table>\r\r\n\t\t\t\t\t</td></tr></table>";
?>
</td>
</tr>
<tr>
<td nowrap> </td>
<tr>
<td width="20%" align="left"><strong><u><?php
echo $rows5 . " ";
?>
Fuel Log</u></strong></td>
<td width="13%" align="left"><strong>Qty</strong></td>
<td width="18%" align="left"><b>Cost/ltr(UGX)</b></td>
<td width="19%" align="left"><b>Total(UGX)</b></td>
<td width="30%" align="left"><b>Date Created</b> </td>
</tr>
<?php
do {
?>
<tr style="<?php
echo get_row_color($counter, 2);
?>
" class="<?php
echo $fuel2['fuel_id'];
?>
">
<td align="left"><a href="trucks.php?&truck_id=<?php
echo $truck_id;
?>
&fuel_id=<?php
echo $fuel2['fuel_id'];
?>
&fl=22">Update</a> | <a class="del" title="Delete?" href="javascript:;" id="fuel|fuel_id|<?php
echo $fuel2['fuel_id'];
?>
">Delete</a></td>
<td><input type="button" name="search" id="search" value="Search" class="bodybutton"/></td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<div id="searchresults">
<?php
#Show search results
if (!empty($page_list)) {
echo "<table width='100%' border='0' cellspacing='0' cellpadding='5'>\r\r\n \t<tr>\r\r\n\t\t\t<td width='1%' class='listheader'> </td>\r\r\n \t<td class='listheader' nowrap>Report</td>\r\r\n\t\t\t<td class='listheader' nowrap>Date</td>\r\r\n\t\t\t</tr>";
$counter = 0;
foreach ($page_list as $row) {
#Show one row at a time
echo "<tr style='" . get_row_color($counter, 2) . "'>\r\r\n\t\t\t\r\r\n\t\t\t<td valign='top' nowrap><img src='" . base_url() . "images/" . get_doc_logo($row['fileurl']) . "' border='0' height='20'/> </td>\r\r\n \r\r\n\t\t\t<td><a href='" . base_url() . "documents/force_download/u/" . encryptValue($row['fileurl']) . "/f/" . encryptValue('reports') . "' class='contentlink'>" . $row['reportname'] . "</a></td>\r\r\n \r\r\n\t\t\t<td>" . date('d-M-Y', strtotime($row['uploaddate'])) . "</td>\r\r\n </tr>";
$counter++;
}
$url_part = !empty($t) && decryptValue($t) == 'archive' ? '/t/' . encryptValue('archive') : '';
echo "<tr>\r\r\n\t<td colspan='3' align='center' class='layer_table_pagination'>" . pagination($this->session->userdata('search_total_results'), $rows_per_page, $current_list_page, base_url() . "reports/report_list" . $url_part . "/p/%d") . "</td>\r\r\n\t</tr>\r\r\n\t</table>";
} else {
$status = !empty($t) && decryptValue($t) == 'archive' ? 'archived' : 'active';
echo format_notice("<span class='error'>There are no " . $status . " reports at the moment.</span>");
}
?>
</div>
</td>
</tr>
</table></td>
</tr>
