" class="input-medium numbercommas" /> <select id="bid-documents-currency" class="input-small m-wrap" name="bid_documents_currency"> <?php echo get_select_options($currencies, 'id', 'title', !empty($formdata['bid_documents_currency']) ? $formdata['bid_documents_currency'] : 1); ?> </select> </div> </div> <div class="control-group <?php echo in_array('bid_security', $requiredfields) ? 'error' : ''; ?> "> <label class="control-label">Bid security:</label> <div class="controls"> <input type="text" name="bid_security_amount" value="<?php echo !empty($formdata['bid_security_amount']) ? addCommas($formdata['bid_security_amount'], 0) : ''; ?> " class="input-medium numbercommas" /> <select id="bid-security-currency" class="input-small m-wrap" name="bid_security_currency"> <?php echo get_select_options($currencies, 'id', 'title', !empty($formdata['bid_security_currency']) ? $formdata['bid_security_currency'] : 1); ?> </select> </div> </div> <div class="control-group <?php echo in_array('invitation_to_bid_date', $requiredfields) ? 'error' : ''; ?> "> <label class="control-label">Invitation to bid date:<span>*</span></label> <div class="controls">
?> " data-date-format="yyyy-mm-dd" data-date-viewmode="days" class="m-ctrl-medium date-picker" type="text" value="<?php echo !empty($formdata['advance_payment_date']) && str_replace('-', '', $formdata['advance_payment_date']) > 0 ? custom_date_format('Y-m-d', $formdata['advance_payment_date']) : ''; ?> "> <span class="add-on"> <i class="fa fa-calendar"></i> </span> </div> </div> </div> <div class="control-group"> <label class="control-label">Total actual payments made: <span>*</span></label> <div class="controls"> <input type="text" name="total_actual_payments" value="<?php echo !empty($formdata['total_actual_payments']) ? addCommas($formdata['total_actual_payments'], 0) : ''; ?> " class="input-medium numbercommas" /> <select id="total_actual_payments_currency" class="input-small m-wrap" name="total_actual_payments_currency"> <?php echo get_select_options($currencies, 'id', 'title', !empty($formdata['total_actual_payments_currency']) ? $formdata['total_actual_payments_currency'] : 1); ?> </select> </div> </div> <div class="control-group"> <label class="control-label">Date of actual completion:<span>*</span></label> <div class="controls"> <div class="input-append date date-picker" data-date="<?php echo !empty($formdata['actual_completion_date']) && str_replace('-', '', $formdata['actual_completion_date']) > 0 ? custom_date_format('Y-m-d', $formdata['actual_completion_date']) : date('Y-m-d'); ?>
$providername = $row['providernames']; if (!empty($row['joint_venture'])) { $providername = ''; $jv_info = $this->db->query('SELECT * FROM joint_venture WHERE jv = "' . $row['joint_venture'] . '"')->result_array(); if (!empty($jv_info[0]['providers'])) { $providers = $this->db->query('SELECT * FROM providers WHERE providerid IN (' . rtrim($jv_info[0]['providers'], ',') . ')')->result_array(); foreach ($providers as $provider) { $providername .= (!empty($providername) ? ', ' : '') . $provider['providernames']; } } } $table_HTML .= '<tr>' . ($formdata['contracts_report_type'] == 'AC' ? '<td style="text-align: left; border-bottom: solid #000 1px; font-size:12px; font-family: Calibri, arial, sans-serif;">' . custom_date_format('d M, Y', $row['date_signed']) . '</td>' : '') . (in_array($formdata['contracts_report_type'], array('CDC', 'LC')) ? '<td style="text-align: left; border-bottom: solid #000 1px; font-size:12px; font-family: Calibri, arial, sans-serif;">' . custom_date_format('d M, Y', $row['completion_date']) . '</td>' : '') . '<td style="text-align: left; border-bottom: solid #000 1px; font-size:12px; font-family: Calibri, arial, sans-serif;">' . format_to_length($row['pdename'], 30) . '</td>' . '<td style="text-align: left; border-bottom: solid #000 1px; font-size:12px; font-family: Calibri, arial, sans-serif;">' . $row['procurement_ref_no'] . '</td>' . '<td style="text-align: left; border-bottom: solid #000 1px; font-size:12px; font-family: Calibri, arial, sans-serif;">' . $row['subject_of_procurement'] . '</td>' . '<td style="text-align: left; border-bottom: solid #000 1px; font-size:12px; font-family: Calibri, arial, sans-serif;">' . $providername . '</td>' . (in_array($formdata['contracts_report_type'], array('LC')) ? '<td style="text-align: left; border-bottom: solid #000 1px; font-size:12px; font-family: Calibri, arial, sans-serif;">' . get_date_diff(empty($row['actual_completion_date']) ? date('Y-m-d') : $row['actual_completion_date'], $row['completion_date'], 'days') . '</td>' : '') . (in_array($formdata['contracts_report_type'], array('CC')) ? '<td style="text-align: left; border-bottom: solid #000 1px; font-size:12px; font-family: Calibri, arial, sans-serif;">' . custom_date_format('d M, Y', $row['actual_completion_date']) . '</td>' : '') . (in_array($formdata['contracts_report_type'], array('CC')) ? '<td style="text-align: right; border-bottom: solid #000 1px; font-size:12px; font-family: Calibri, arial, sans-serif;">' . addCommas($row['total_amount_paid'], 0) . '</td>' : '') . '<td style="text-align: right; border-bottom: solid #000 1px; font-size:12px; font-family: Calibri, arial, sans-serif;">' . addCommas($row['total_price'], 0) . '</td>' . '</tr>'; $grand_contracts_value += $row['total_price']; $grand_total_amount_paid += $row['total_amount_paid']; } $table_HTML .= '<tr>' . ($formdata['contracts_report_type'] == 'AC' ? '<td> </td>' : '') . (in_array($formdata['contracts_report_type'], array('CDC', 'LC')) ? '<td> </td>' : '') . '<td> </td>' . '<td> </td>' . '<td> </td>' . '<td> </td>' . (in_array($formdata['contracts_report_type'], array('LC')) ? '<td> </td>' : '') . (in_array($formdata['contracts_report_type'], array('CC')) ? '<td> </td>' : '') . (in_array($formdata['contracts_report_type'], array('CC')) ? '<td style="text-align:right; font-weight:bold; font-size: 14px; font-family: Georgia">' . addCommas($grand_total_amount_paid, 0) . '</td>' : '') . '<td style="text-align:right; font-weight:bold; font-size: 16px; font-family: Georgia">' . addCommas($grand_contracts_value, 0) . '</td>' . '</tr>'; $table_HTML .= '</tbody></table>'; } elseif (!empty($formdata)) { $table_HTML .= format_notice('Your search criteria does not match any results'); } } else { if (!empty($area) && $area == 'procurement_record_details') { if (!empty($procurement_details)) { $table_HTML .= '<div class="control-group subject_of_procurement">' . '<label class="control-label">Subject of procurement:</label>' . '<div class="controls">' . (!empty($procurement_details['subject_of_procurement']) ? $procurement_details['subject_of_procurement'] : '<i>undefined</i>') . '<input type="hidden" name="procurement_details[subject_of_procurement]" value="' . $procurement_details['subject_of_procurement'] . '" />' . '</div>' . '</div>' . '<div class="control-group">' . '<label class="control-label">Financial year:</label>' . '<div class="controls">' . (!empty($procurement_details['financial_year']) ? $procurement_details['financial_year'] : '<i>undefined</i>') . '<input type="hidden" name="procurement_details[financial_year]" value="' . $procurement_details['financial_year'] . '" />' . '</div>' . '</div>' . '<div class="control-group">' . '<label class="control-label">Source of funding:</label>' . '<div class="controls">' . (!empty($procurement_details['funding_source']) ? $procurement_details['funding_source'] : '<i>undefined</i>') . '<input type="hidden" name="procurement_details[funding_source]" value="' . $procurement_details['funding_source'] . '"/>' . '</div>' . '</div>'; if (!empty($procurement_details['quantity'])) { $total_ifb_q = $procurement_details['quantity'] - $procurement_details['total_ifb_quantity']; $table_HTML .= '<div class="control-group">' . '<label class="control-label">Quantity:</label>' . '<div class="controls">' . (!empty($total_ifb_q) ? $total_ifb_q : '<i>undefined</i>') . '<input type="hidden" id="procurement_details_quantity" name="procurement_details_quantity" value="' . $total_ifb_q . '"/>' . '</div>' . '</div>'; } $table_HTML .= '<div class="control-group">' . '<label class="control-label">Method of procurement:</label>' . '<div class="controls">' . (!empty($procurement_details['procurement_method']) ? $procurement_details['procurement_method'] : '<i>undefined</i>') . '<input type="hidden" name="procurement_details[procurement_method]" value="' . $procurement_details['procurement_method'] . '" />' . '</div>' . '</div>'; if (!empty($procurement_details['providers'])) { #$st = 'SELECT * FROM providers WHERE providerid in('.$procurement_details['providers'].')';
function format_fields_instr($field_array, $row_data = array()) { $bool = FALSE; #assuming instructions are in the first array item switch ($field_array[0]) { case 'UCFIRST': $string = ucfirst($row_data[$field_array[1]]); $bool = TRUE; break; case 'MONEY': $string = '$' . addCommas($row_data[$field_array[1]]); $bool = TRUE; break; case 'ADDCOMMAS': $string = addCommas($row_data[$field_array[1]]); $bool = TRUE; break; default: $string = ''; break; } return array('bool' => $bool, 'string' => $string); }
$status_str = ''; $completion_str = ''; if (!empty($row['actual_completion_date']) && str_replace('-', '', $row['actual_completion_date']) > 0) { $status_str = '<span class="label label-success label-mini">Completed</span>'; $completion_str = '<a title="Click to view contract completion details" href="' . base_url() . 'contracts/contract_completion_form/c/' . encryptValue($row['id']) . '/v/' . encryptValue('view') . '"><i class="fa fa-eye"></i></a>'; } else { $status_str = '<span class="label label-warning label-mini">Awarded</span>'; $completion_str = '<a title="Click to enter contract completion details"" href="' . base_url() . 'contracts/contract_completion_form/c/' . encryptValue($row['id']) . '"><i class="fa fa-check"></i></a>'; } $termintate_str = '<a href="#"><i class="fa fa-times-circle"></i></a>'; $more_actions = '<div class="btn-group" style="font-size:10px"> <a href="#" class="btn btn-primary">more</a><a href="javascript:void(0);" data-toggle="dropdown" class="btn btn-primary dropdown-toggle"><span class="fa fa-caret-down"></span></a> <ul class="dropdown-menu"> <li><a href="#"><i class="fa fa-times-circle"></i></a></li> <li class="divider"></li> <li>' . $completion_str . '</li> </ul> </div>'; print '<tr>' . '<td>'; if ($this->session->userdata('isadmin') == 'N') { print $delete_str . ' ' . $edit_str . ' ' . $termintate_str . ' ' . $completion_str; } print ' </td>' . '<td>' . custom_date_format('d M, Y', $row['date_signed']) . '</td>' . '<td>' . format_to_length($row['procurement_ref_no'], 30) . '</td>' . '<td>' . format_to_length($row['subject_of_procurement'], 30) . '</td>' . '<td>' . $status_str . '</td>' . '<td style="text-align:right; font-family:Georgia; font-size:14px">' . addCommas($row['total_price'], 0) . '</td>' . '<td>' . custom_date_format('d M, Y', $row['dateadded']) . ' by ' . format_to_length($row['authorname'], 10) . '</td>' . '</tr>'; } print '</tbody></table>'; } else { print format_notice('WARNING: No contracts have been signed in the system'); } ?> </div> </div>
function format_column_numbers($data_array, $array_cols) { $new_data_array = array(); foreach ($data_array as $rowkey => $row) { foreach ($row as $key => $value) { #Format the field if it is in the given columns if (in_array($key, $array_cols)) { $new_data_array[$rowkey][$key] = addCommas(str_replace('$', '', str_replace(',', '', $value))); } else { $new_data_array[$rowkey][$key] = $value; } } } return $new_data_array; }
function monthlyreportonexpiringcontracts($level) { $urldata = $this->uri->uri_to_assoc(3, array('m', 'p')); # Pick all assigned data $data = assign_to_data($urldata); $data = add_msg_if_any($this, $data); $data = handle_redirected_msgs($this, $data); $search_str =''; # code... $querys = $this->db->query("select distinct b.pdeid,b.pdename,a.* from pdes b inner join users a on a.pde = b.pdeid ")->result_array(); foreach($querys as $row => $records ) { $entityname = $records['pdename']; $search_str = ''; $search_str .= 'AND PP.pde_id ='.$records['pdeid'].' AND C.completion_date BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 10 DAY)'; $query = $this->Query_reader->get_query_by_code('get_published_contracts', array('orderby'=>'C.date_signed DESC', 'limittext'=>'','searchstring'=>' AND PPE.isactive ="Y" AND BI.isactive = "Y" AND C.isactive="Y"' . $search_str)); $result = $this->db->query($query)->result_array(); print_r($this->db->last_query()); $str = '<style>.tablex tr th{text-align:left; background:#ccc; padding:20px; text-transform:uppercase;} .tablex tr td{border:1px solid #eee; padding:5px; font-size:15px;}</style> <div class="widget-body" id="results" style="width:100%;">'; if(!empty($result)) { $str .= '<h2 style="width:100%; text-align:center; padding:5px;">CONTRACTS SOON EXPIRING THIS MONTH FOR '.$records['pdename'].'</h2> <table class="table tablex table-striped table-hover" style="width:100%; padding:5px;">'. '<thead>'. '<tr style="width:100%; padding:5px; border:1px solid #eee;" >'. '<th width="94px"></th>'; if($this->session->userdata('isadmin') == 'N') { $str .= '<th> Procuring And Diposing Entity </th>'; } $str .= '<th>Date signed</th>'. '<th>Procurement Reference Number </th>'. '<th>Subject of procurement</th>'. '<th>Status</th>'. '<th style="text-align:right">Contract amount (UGX)</th>'. '<th class="hidden-480">Date added</th>'. '</tr>'. '</thead>'. '</tbody>'; foreach ($result as $key => $row) { # code... $edit_str = ''; $delete_str = ''; if(!empty($row['actual_completion_date']) && str_replace('-', '', $row['actual_completion_date'])>0) { $delete_str = '<a title="Delete contract details" href="javascript:void(0);" onclick="confirmDeleteEntity(\''.base_url().'contracts/delete_contract/i/'.encryptValue($row['id']).'\', \'Are you sure you want to delete this contract?\nClick OK to confirm, \nCancel to cancel this operation and stay on this page.\')"><i class="fa fa-trash"></i></a>'; $termintate_str = ''; }else { $termintate_str = '<a href="'. base_url() .'contracts/contract_termination/i/'.encryptValue($row['id']) .'" title="Click to terminate contract"><i class="fa fa-times-circle"></i></a>'; $edit_str = '<a title="Edit contract details" href="'. base_url() .'contracts/contract_award_form/i/'.encryptValue($row['id']).'"><i class="fa fa-edit"></i></a>'; } $status_str = ''; $completion_str = ''; if(!empty($row['actual_completion_date']) && str_replace('-', '', $row['actual_completion_date'])>0) { $status_str = '<span class="label label-success label-mini">Completed</span>'; $completion_str = '<a title="Click to view contract completion details" href="'. base_url() .'contracts/contract_completion_form/c/'.encryptValue($row['id']).'/v/'. encryptValue('view') .'"><i class="fa fa-eye"></i></a>'; } else { $status_str = '<span class="label label-warning label-mini">Awarded</span>'; $completion_str = '<a title="Click to enter contract completion details"" href="'. base_url() .'contracts/contract_completion_form/c/'.encryptValue($row['id']) .'"><i class="fa fa-check"></i></a>'; } $variations = ' <a class="view_variations" id="view_'.$row['id'].'" data-ref="'. base_url() .'contracts/contract_variation_view/i/'.encryptValue($row['id']) .'" title="Click to view Variations "><i class="fa fa-bars"></i></a> '; if(empty($row['actual_completion_date']) ) { $variations .= '<a href="'. base_url() .'contracts/contract_variation_add/i/'.encryptValue($row['id']) .'" title="Click to Add Variations "><i class="fa fa-plus-circle "></i></a> '; } $more_actions = '<div class="btn-group" style="font-size:10px"> <a href="#" class="btn btn-primary">more</a><a href="javascript:void(0);" data-toggle="dropdown" class="btn btn-primary dropdown-toggle"><span class="fa fa-caret-down"></span></a> <ul class="dropdown-menu"> <li><a href="#"><i class="fa fa-times-circle"></i></a></li> <li class="divider"></li> <li>'. $completion_str .'</li> </ul> </div>'; $str .= '<tr>'. '<td>'; if($this->session->userdata('isadmin') == 'N') $str .= $delete_str .' '. $edit_str .' '. $termintate_str .' '.$completion_str.' '.$variations;; $str .= ' </td>'; if($this->session->userdata('isadmin') == 'N') { $str .= '<th> '.$row['pdename'].' </th>'; } $str .= '<td>'. custom_date_format('d M, Y',$row['date_signed']) .'</td>'. '<td>'. format_to_length($row['procurement_ref_no'], 30) .'</td>'. '<td>'. format_to_length($row['subject_of_procurement'], 30).''; if($row['pmethod'] == 'Framework and Special Contracts' ) { $str .= '<br/><a href="#" id="'.$row['id'].'" class="togglecalloforders" > Add Call off Order </a> | <a href="#" data-procurement="'.$row['procurement_ref_no'].'" id="'.$row['id'].'" class="viewlistcalloff" >View Call off Orders </a> </br/>'; } $str .= '</td>'. '<td>'. $status_str .'</td>'. '<td style="text-align:right; font-family:Georgia; font-size:14px">'. addCommas($row['total_price'], 0) .'</td>'. '<td>'. custom_date_format('d M, Y', $row['dateadded']) .' by '. format_to_length($row['authorname'], 10) .'</td>'. '</tr>'; } $str .= '</tbody></table>'; } else { $str .="<h2> No Records Expiring soon this month for ".$entityname." </h2>"; } $str .= '</div>'; $adons = ' | '.date('d-m-y'); $level = "Procurement"; $titles = "Monthly Report on Soon Expiring Contracts for ".$entityname.'| '. $adons; $body = " ".html_entity_decode($str); $permission = "view_bid_invitations"; $this-> push_permission($titles,$body,$level,$permission,$records ['pdeid']); echo $body; } }
</th> </tr> </thead> <tbody> <?php if (!empty($formdata['contract_amount'])) { foreach ($formdata['contract_amount'] as $contract_amount) { if (is_array($contract_amount)) { $contract_amount_arr[0] = $contract_amount['amount']; $contract_amount_arr[1] = $contract_amount['currency_id']; $contract_amount_arr[2] = $contract_amount['xrate']; $contract_amount_arr[3] = $contract_amount['title']; } else { $contract_amount_arr = explode('__', $contract_amount); } print '<tr>' . '<td style="text-align:center">' . '<a title="Click to remove" href="javascript:void(0);">' . '<i class="fa fa-remove"></i></a>' . '<input type="hidden" name="contract_amount[]" value="' . $contract_amount_arr[0] . '__' . $contract_amount_arr[1] . '__' . $contract_amount_arr[2] . '__' . $contract_amount_arr[3] . '" />' . '</td>' . '<td>' . addCommas($contract_amount_arr[0], 0) . '</td>' . '<td class="hidden-phone" style="font-size:11px"><strong>' . $contract_amount_arr[3] . '</strong></td>' . '<td class="right-align-text hidden-phone">' . '<input type="hidden" class="curId" value="' . $contract_amount_arr[1] . '" />' . '<span class"number">' . addCommas($contract_amount_arr[2], 0) . '</span></td>' . '<td style="text-align:right" class="right-align-text hidden-phone">' . '<span class"number">' . addCommas(removeCommas($contract_amount_arr[0]) * removeCommas($contract_amount_arr[2]), 0) . '</span>' . '</td></tr>'; } } ?> </tbody> </table> </div> </div> <div class="form-actions"> <button type="submit" name="save" value="save" class="btn blue"><i class="fa fa-ok"></i> Save</button> <button type="reset" name="cancel" value="cancel" class="btn"><i class="fa fa-remove"></i> Cancel</button> </div>
$table_HTML .= "<table cellpadding='5' cellspacing='0' border='0'>\r\r\n\t\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></table>" . format_notice("No sector meets search."); } } else { if (!empty($area) && $area == 'nav_amt_details') { $table_HTML .= $combined_js_HTML . $combined_css_HTML; if ((!empty($unfunded) || $unfunded == 0) && !empty($fundedamount)) { $table_HTML .= "<b>Unfunded Amount:</b> \$" . addCommas($unfunded) . " NAV: \$" . addCommas(removeCommas(restore_bad_chars($fundedamount))); } else { $table_HTML .= format_notice("<span class='error'>Invalid Commitment or funded amount.</span>"); } } else { if (!empty($area) && $area == 'called_amt_details') { $table_HTML .= $combined_js_HTML . $combined_css_HTML; if ((!empty($uncalled) || $uncalled == 0) && !empty($dealamount) && $uncalled >= 0) { $perc = addCommas($uncalled / removeCommas($dealamount) * 100); $table_HTML .= "<b>Uncalled Amount:</b> \$" . addCommas($uncalled) . " (" . $perc . "%)"; } else { $table_HTML .= format_notice("<span class='error'>Invalid called or commitment amount.</span>"); } } else { if (!empty($area) && $area == 'new_section_details') { $table_HTML .= $combined_js_HTML . $combined_css_HTML; if (!empty($a) && decryptValue($a) == 'add') { $table_HTML .= format_notice("New section added") . "<select name='fileunder' id='fileunder' class='selectfield' onchange=\"showWithValue('fileunder', 'addbtn', 'addfields')\">"; $section_list = $this->db->query($this->Query_reader->get_query_by_code('search_file_under', array('searchstring' => ''))); $options = $section_list->result_array(); $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 {
</td> </tr> <tr> <td><b>Planned date of completion</b></td> <td style="text-align:left"> <span class=""><?php echo custom_date_format('d M, Y', $details['completion_date']); ?> </span> </td> </tr> <tr> <td><b>Contract Amount</b></td> <td style="text-align:left"> <span class=""><?php echo addCommas($details['total_price'], 0) . ' UGX'; ?> </span> </td> </tr> </tbody> </table> </div> </div> </div> <?php $url = "http://" . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'] . ""; print '' . ' <a href="https://twitter.com/share" class="twitter-share-button " data-url="' . $url . '" data-size="small" data-hashtags="tenderportal_ug" data-count="none" data-dnt="none"></a> <div class="g-plusone" data-action="share" data-size="medium" data-annotation="none" data-height="24" data-href="' . $url . '"></div> <div class="fb-share-button" data-href="' . $url . '" data-layout="button" data-size="medium"></div>'; ?>
?> </label> <div class="controls"> <select id="currency" class="input-small m-wrap" name="currency"> <?php echo get_select_options(get_active_currencies(), 'id', 'title', !empty($formdata['currency']) ? $formdata['currency'] : '1'); ?> </select> <input style="display:none" class=" input-small numbercommas" value="<?php echo !empty($formdata['exchange_rate']) ? addCommas($formdata['exchange_rate'], 0) : ''; ?> " name="exchange_rate" placeholder="Exchange rate" type="text" /> <input type="text" name="estimated_amount" value="<?php echo !empty($formdata['estimated_amount']) ? addCommas($formdata['estimated_amount'], 0) : ''; ?> " class="input-medium numbercommas" /> </div> </div> <div class="control-group <?php echo in_array('funding_source', $requiredfields) ? 'error' : ''; ?> "> <label class="control-label">Source of funding <?php echo text_danger_template('*'); ?> </label>