public function get_product_list($inputs)
{
$CI =& get_instance();
$CI->db->select('product.*');
$CI->db->select('manufacture.manufacture_name');
$CI->db->select('category.category_name');
$CI->db->select('supplier.company_name');
$CI->db->select('warehouse.warehouse_name');
// $CI->db->select('COUNT(product.product_name) no_of_product');
$CI->db->from($CI->config->item('table_product') . ' product');
if ($inputs['category']) {
$CI->db->where('product.category_id', $inputs['category']);
}
if ($inputs['product_name']) {
$CI->db->where('product.product_name', $inputs['product_name']);
}
if ($inputs['manufacture']) {
$CI->db->where('product.manufacture_id', $inputs['manufacture']);
}
if ($inputs['supplier']) {
$CI->db->where('product.supplier_id', $inputs['supplier']);
}
if ($inputs['warehouse']) {
$CI->db->where('product.warehouse_id', $inputs['warehouse']);
}
// $CI->db->order_by('product.id','ASC');
//check product type
if ($inputs['product_type'] == 'unassigned') {
$CI->db->where('product_assign.product_id IS NULL', NULL, true);
$CI->db->join($CI->config->item('table_product_assign') . ' product_assign', 'product_assign.product_id = product.id', 'LEFT');
} elseif ($inputs['product_type'] == 'assigned') {
$CI->db->where('product_assign.product_id IS NOT NULL', NULL, true);
$CI->db->where('product_assign.status', 1);
$CI->db->join($CI->config->item('table_product_assign') . ' product_assign', 'product_assign.product_id = product.id', 'LEFT');
}
$CI->db->join($CI->config->item('table_manufacture') . ' manufacture', 'manufacture.id = product.manufacture_id', 'LEFT');
$CI->db->join($CI->config->item('table_product_category') . ' category', 'category.id = product.category_id', 'LEFT');
$CI->db->join($CI->config->item('table_supplier') . ' supplier', 'supplier.id = product.supplier_id', 'LEFT');
$CI->db->join($CI->config->item('table_warehouse') . ' warehouse', 'warehouse.id = product.warehouse_id', 'LEFT');
// $CI->db->order_by("product.id", "desc");
// $CI->db->group_by('product.product_name');
$results = $CI->db->get()->result_array();
//echo $CI->db->last_query();
foreach ($results as &$result) {
$result['unit_price'] = System_helper::Get_Eng_to_Bng($result['unit_price']);
}
return $results;
}
public function get_record_list()
{
$CI =& get_instance();
$this->db->select("ticket_assign.user_id id, count(ticket_assign.ticket_issue_id) ticket_issue_id, users.name_bn, users.email,\r\n users.mobile,users.pbx");
$this->db->from($CI->config->item('table_ticket_assign'));
$this->db->join($CI->config->item('table_users') . ' users', 'users.id = ticket_assign.user_id', 'LEFT');
$this->db->where('ticket_assign.status =' . $this->config->item('STATUS_ASSIGN'));
$this->db->group_by('ticket_assign.user_id');
$users = $this->db->get()->result_array();
//echo $this->db->last_query();
foreach ($users as &$user) {
$user['edit_link'] = $CI->get_encoded_url('ticket_management/ticket_assign/index/batch_details/' . $user['id']);
$user['ticket_issue_id'] = System_helper::Get_Eng_to_Bng($user['ticket_issue_id']);
}
return $users;
}
public function get_user_list()
{
$CI =& get_instance();
$CI->db->from($CI->config->item('table_product_assign') . ' pa');
$CI->db->select('pa.status,user.name_en user_name, user.email,user.phone');
$CI->db->select('user.id id');
$CI->db->select('count(pa.id) nub_of_product');
$CI->db->join($CI->config->item('table_users') . ' user', 'user.id = pa.user_id', 'LEFT');
//$CI->db->join($CI->config->item('table_product'). ' product','product.id = pa.product_id','LEFT');
$CI->db->where('pa.status = 1');
$CI->db->group_by('user.id');
$results = $this->db->get()->result_array();
foreach ($results as &$result) {
$result['edit_link'] = $CI->get_encoded_url('asset_management/product_return/index/edit/' . $result['id']);
$result['nub_of_product'] = System_helper::Get_Eng_to_Bng($result['nub_of_product']);
}
return $results;
}
public function get_record_list()
{
$user = User_helper::get_user();
if ($user->user_group_level == $this->config->item('END_GROUP_ID') || $user->user_group_level == $this->config->item('TOP_MANAGEMENT_GROUP_ID') || $user->user_group_level == $this->config->item('SUPPORT_GROUP_ID') || $user->user_group_level == $this->config->item('OPERATOR_GROUP_ID')) {
$this->db->where('ticket_issue.user_id', $user->id);
} else {
}
$CI =& get_instance();
$this->db->select("core_01_users.name_bn,\r\n ticket_issue.id,\r\n ticket_issue.token,\r\n product.product_name,product.product_code,\r\n ticket_issue.`subject`,\r\n ticket_issue.`create_date`,\r\n ticket_issue.`status`");
$this->db->from($CI->config->item('table_ticket_issue'));
$this->db->join($CI->config->item('table_users') . ' core_01_users', 'core_01_users.id = ticket_issue.user_id', 'LEFT');
$this->db->join($CI->config->item('table_product') . ' product', 'product.id = ticket_issue.product_id', 'LEFT');
$this->db->order_by('ticket_issue.id', 'DESC');
$users = $this->db->get()->result_array();
//echo $this->db->last_query();
foreach ($users as &$user) {
$user['edit_link'] = $CI->get_encoded_url('ticket_management/ticket_issue/index/batch_details/' . $user['id']);
if ($user['status'] == $this->config->item('STATUS_INACTIVE')) {
$user['status_text'] = $CI->lang->line('PENDING');
} else {
if ($user['status'] == $this->config->item('STATUS_ACTIVE')) {
$user['status_text'] = $CI->lang->line('RESOLVE');
} else {
if ($user['status'] == $this->config->item('STATUS_ASSIGN')) {
$user['status_text'] = $CI->lang->line('ASSIGN');
} else {
if ($user['status'] == $this->config->item('STATUS_RESOLVE')) {
$user['status_text'] = $CI->lang->line('RESOLVE');
} else {
if ($user['status'] == $this->config->item('STATUS_REJECT')) {
$user['status_text'] = $CI->lang->line('REJECT');
} else {
$user['status_text'] = $user['status'];
}
}
}
}
}
$user['create_date_time'] = date('h:i A - d M,y', $user['create_date']);
$user['id'] = System_helper::Get_Eng_to_Bng($user['id']);
}
return $users;
}
public function get_record_list()
{
$user = User_helper::get_user();
if ($user->user_group_level == $this->config->item('SUPPORT_GROUP_ID')) {
$this->db->where('ticket_assign.user_id', $user->id);
}
$CI =& get_instance();
$this->db->select("ticket_assign.id,\r\n ticket_assign.ticket_issue_id,\r\n ticket_assign.create_date,\r\n ticket_assign.priority,\r\n ticket_assign.`status`,\r\n `ticket_issue`.`subject`,\r\n product.product_name,product.product_code,\r\n users.name_bn,\r\n users_assign.name_bn support_name,\r\n ticket_assign.resolved_date");
$this->db->from($CI->config->item('table_ticket_assign') . ' ticket_assign');
$this->db->join($CI->config->item('table_ticket_issue') . ' ticket_issue', 'ticket_issue.id = ticket_assign.ticket_issue_id', 'INNER');
$this->db->join($CI->config->item('table_users') . ' users', 'users.id = ticket_issue.user_id', 'INNER');
$this->db->join($CI->config->item('table_users') . ' users_assign', 'users_assign.id = ticket_assign.user_id', 'INNER');
$this->db->join($CI->config->item('table_product') . ' product', 'product.id = ticket_issue.product_id', 'LEFT');
$this->db->where('ticket_assign.status =' . $this->config->item('STATUS_ASSIGN'));
$this->db->order_by('ticket_assign.ticket_issue_id', 'DESC');
$users = $this->db->get()->result_array();
//echo $this->db->last_query();
$all_priority = $CI->config->item('ticket_priority');
foreach ($users as &$user) {
$user['edit_link'] = $CI->get_encoded_url('ticket_management/ticket_resolve/index/edit/' . $user['id']);
$user['ticket_issue_id'] = System_helper::Get_Eng_to_Bng($user['ticket_issue_id']);
// if($user['status']==$this->config->item('STATUS_ASSIGN'))
// {
// $user['status_text']=$CI->lang->line('ASSIGN');
// }
// else if($user['status']==$this->config->item('STATUS_RESOLVE'))
// {
// $user['status_text']=$CI->lang->line('RESOLVE');
// }
// else if($user['status']==$this->config->item('STATUS_REJECT'))
// {
// $user['status_text']=$CI->lang->line('REJECT');
// }
// else
// {
// $user['status_text']=$user['status'];
// }
$user['create_date_time'] = date('h:i A - d M,y', $user['create_date']);
$user['priority'] = isset($all_priority[$user['priority']]) ? $all_priority[$user['priority']] : '';
}
return $users;
}
images/government-logo.png">
</td>
</tr>
<tr>
<td style="text-align:center;">
<h1 class="text-center">বাংলাদেশ জাতীয় সংসদ</h1>
<h3 class="text-center">প্রোডাক্ট সম্পর্কিত প্রতিবেদন</h3>
</td>
</tr>
</table>
<h5 class="pull-right"> মুদ্রণ তারিখ: <?php
echo System_helper::Get_Eng_to_Bng(date('d-m-Y'));
?>
</h5>
<table class="table table-bordered" style="overflow: auto">
<thead>
<tr style="background: #eee">
<th>প্রোডাক্ট নাম</th>
<th>ক্যটাগরি</th>
<th>ইউনিট মূল্য</th>
<th>ওয়ারহাউস</th>
<th>প্রস্তুতকারক</th>
<th>সরবরাহকারী</th>
<th>আইটেম ইউনিট</th>
<th>সংক্ষিপ্ত বর্ণনা</th>
<th>স্পেসিফিকেশন</th>
<?php
echo $ticket_issue['product_name'] . '(' . $ticket_issue['product_code'] . ')';
?>
</span>
<span class="label label-sm label-danger" title="<?php
echo $this->lang->line('TIME');
?>
"><?php
echo date('h:i A', $ticket_issue['create_date']);
?>
</span>
<span class="badge badge-warning" title="<?php
echo $this->lang->line('TOKEN');
?>
"><?php
echo System_helper::Get_Eng_to_Bng($ticket_issue['id']);
?>
</span>
</div>
</div>
</div>
</div>
<div class="col2">
<div class="date">
<?php
echo date('d M,y', $ticket_issue['create_date']);
?>
</div>
</div>
</li>
<?php
?>
<td><span style="color: #008800" class="glyphicon glyphicon-ok"></span>
</td>
<?php
} else {
?>
<td><span style="color: #dd1144" class="glyphicon glyphicon-remove"></span>
<?php
}
?>
<?php
}
?>
<td><?php
echo System_helper::Get_Eng_to_Bng($total_uplaod);
?>
</td>
<?php
$upload_percent = $total_uplaod * 100 / $numDays;
if ($upload_percent >= 70) {
?>
<td><?php
echo $this->lang->line('SATISFIED');
?>
</td>
<?php
} elseif ($upload_percent >= 50 && $upload_percent < 70) {
?>
<td><?php
echo $this->lang->line('FAIRLY_SATISFIED');
<div id="system_action_button_container" class="system_action_button_container">
<?php
$CI->load_view('system_action_buttons');
?>
</div>
<!-- BEGIN PAGE CONTENT INNER -->
<div class="row margin-top-10">
<div class="col-md-12">
<!-- BEGIN SAMPLE FORM PORTLET-->
<div class="portlet box grey-cararra">
<div class="col-lg-12 text-danger h4">
<?php
echo $this->lang->line('TOTAL_NOT_ASSIGN_ISSUE');
?>
( <?php
echo System_helper::Get_Eng_to_Bng($ticket['number_of_not_assign_issue'] ? $ticket['number_of_not_assign_issue'] : 0);
?>
)
</div>
<div class="portlet-body">
<div id="system_dataTable">
</div>
</div>
</div>
<!-- END SAMPLE FORM PORTLET-->
</div>
</div>
<!-- END PAGE CONTENT INNER -->
</div>
</div>
echo $CI->lang->line('YEAR');
?>
</label>
</div>
<div class="col-sm-4 col-xs-8">
<select name="year" class="form-control">
<?php
$start_year = 2011;
$end_year = date('Y');
for ($i = $start_year; $i <= $end_year; $i++) {
?>
<option value="<?php
echo $i;
?>
"><?php
echo System_helper::Get_Eng_to_Bng($i);
?>
</option>
<?php
}
?>
</select>
</div>
</div>
<div class="row show-grid">
<div class="col-xs-4">
</div>
<div class="col-sm-4 col-xs-8">
<input type="submit" class="btn btn-primary" value="<?php
* LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
* OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
* THE SOFTWARE.
*
* @package CodeIgniter
* @author EllisLab Dev Team
* @copyright Copyright (c) 2008 - 2014, EllisLab, Inc. (http://ellislab.com/)
* @copyright Copyright (c) 2014 - 2015, British Columbia Institute of Technology (http://bcit.ca/)
* @license http://opensource.org/licenses/MIT MIT License
* @link http://codeigniter.com
* @since Version 1.0.0
* @filesource
*/
defined('BASEPATH') or exit('No direct script access allowed');
$lang['REPORT_HEADER_TITLE'] = 'ডিজিটাল সেন্টার ম্যানেজমেন্ট সিস্টেম ';
$lang['REPORT_CURRENT_DATE_VIEW'] = 'প্রতিবেদনের তারিখ: ' . System_helper::Get_Eng_to_Bng(date('d-m-Y'));
$lang['FROM_DATE'] = 'তারিখ হইতে';
$lang['TO_DATE'] = 'তারিখ পর্যন্ত';
$lang['TO'] = 'হইতে';
$lang['INCOME'] = 'আয় (টাকা)';
$lang['CENTER_STATUS'] = 'সেন্টারের অবস্থা ';
$lang['UPLOAD_YES'] = 'আপলোড করেছে ';
$lang['UPLOAD_NO'] = 'আপলোড করেনি';
$lang['DIGITAL_CENTER'] = 'ডিজিটাল সেন্টার';
$lang['UDC'] = 'ইউডিসি';
$lang['PDC'] = 'পিডিসি';
$lang['CDC'] = 'সিডিসি';
$lang['PLEASE_INPUT_REQUIRE_FIELD'] = 'অনুগ্রহপূর্বক লাল তারকা (*) চিহ্ন তথ্য গুলো পূরণ বাঞ্ছনীয়।';
$lang['SERVICE_HOLDER'] = 'সেবা গ্রহীতা';
//$lang[''];
//// //UISC REGISTRATION
<p><?php
echo $this->lang->line('ENTREPRENEUR');
?>
</p>
</div>
<div class="chart" style=" float:right; margin-top:0px;">
<span class="right_top_box" style="color:#FFB400"><?php
echo $this->lang->line('NUMBER_OF_ENTREPRENEUR_MEN');
?>
</span>
</div>
</li>
<li class="li-tab">
<div style="font-family:nikoshBan;" class="left margin-left-top">
<h4 style="font-family:nikoshBan;color:#090;"><?php
echo System_helper::Get_Eng_to_Bng(Website_helper::get_total_entrepreneurs_women());
?>
জন</h4>
<p style="color:#090;"><?php
echo $this->lang->line('ENTREPRENEUR');
?>
</p>
</div>
<div class="chart" style=" float:right; margin-top:0px;">
<span class="right_top_box" style="color:#090"><?php
echo $this->lang->line('NUMBER_OF_ENTREPRENEUR_WOMEN');
?>
</span>
</div>
</li>
</ul>
?>
</th>
<th style="text-align: right;"><?php
echo System_helper::Get_Eng_to_Bng($grand_total_invoice_women);
?>
</th>
<th style="text-align: right;"><?php
echo System_helper::Get_Eng_to_Bng($grand_total_invoice_tribe);
?>
</th>
<th style="text-align: right;"><?php
echo System_helper::Get_Eng_to_Bng($grand_total_invoice_disability);
?>
</th>
<th style="text-align: right;"><?php
echo System_helper::Get_Eng_to_Bng($grand_total_invoice_men + $grand_total_invoice_women + $grand_total_invoice_tribe + $grand_total_invoice_disability);
?>
</th>
</tr>
<?php
}
?>
</tbody>
</table>
<!-- <table class="table table-responsive table-bordered">-->
<!-- <thead>-->
<!-- <tr>-->
<!-- <th colspan="21" class="text-center">-->
<!-- --><?php
<h5><?php
echo $title;
?>
</h5>
</div>
<table class="table table-responsive table-bordered">
<thead>
<tr>
<th colspan="21" class="text-center">
<?php
echo System_helper::Get_Bangla_Month($month) . " " . $this->lang->line('MONTH');
?>
,
<?php
echo System_helper::Get_Eng_to_Bng($year);
?>
</th>
</tr>
<tr>
<!-- <th>--><?php
//echo $this->lang->line('DIVISION_NAME');
?>
<!--</th>-->
<!-- <th>--><?php
//echo $this->lang->line('ZILLA_NAME');
?>
<!--</th>-->
<!-- <th>--><?php
//echo $this->lang->line('UPAZILLA_NAME');
?>
<script src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.11.4/jquery-ui.min.js"></script>-->
<?php
$union_infos = Dashboard_helper::get_union_wise_income($user->zilla, $user->upazila);
$total_male_female = Dashboard_helper::get_total_male_female_user_upazila($user->zilla, $user->upazila);
$week_start_date = date('Y-m-d', strtotime("-7 day"));
$yesterday = date('Y-m-d', strtotime("-1 day"));
?>
<script>
$(function () {
$('#container').highcharts({
chart: {
type: 'column'
},
title: {
text: '<?php
echo $CI->lang->line('REPORT_TITLE_UNION') . ' (' . System_helper::Get_Eng_to_Bng($week_start_date) . ' ' . $CI->lang->line('TO') . ' ' . System_helper::Get_Eng_to_Bng($yesterday) . ')';
?>
'
},
xAxis: {
categories: [<?php
$index = 0;
foreach ($union_infos as $union) {
if ($index == 0) {
echo "'" . $union['name'] . "'";
} else {
echo ",'" . $union['name'] . "'";
}
$index++;
}
?>
}
?>
<tr style="background: #EEEEEE">
<td> </td>
<td> </td>
<td> </td>
<td><?php
echo $this->lang->line('IN_TOTAL');
?>
</td>
<td><?php
echo System_helper::Get_Eng_to_Bng($total_service);
?>
</td>
<td><?php
echo System_helper::Get_Eng_to_Bng($total_income);
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
</body>
</html>
$total_male_female = Dashboard_helper::get_total_male_female_user_all();
//$highcharts_info=array();
//echo "<pre>";
//print_r($user);
//echo "</pre>";
?>
<script>
$(function ()
{
$('#container').highcharts({
chart: {
type: 'column'
},
title: {
text: '<?php
echo $report_caption . ' (' . System_helper::Get_Eng_to_Bng($week_start_date) . ' ' . $CI->lang->line('TO') . ' ' . System_helper::Get_Eng_to_Bng($yesterday) . ')';
?>
'
},
xAxis: {
categories: [<?php
$index = 0;
foreach ($highcharts_info as $element) {
if (!empty($element['element_name'])) {
$element_name = Dashboard_helper::get_div_zilla_upazilla($element['element_name']);
if ($index == 0) {
echo "'" . $element_name . "'";
} else {
echo ",'" . $element_name . "'";
}
$index++;
<span style="color:#FF0000">*</span></label>
</div>
<div class="col-sm-4 col-xs-8">
<select name="year" id="year" class="form-control">
<option selected="selected"><?php
echo $this->lang->line('SELECT');
?>
</option>
<?php
foreach ($CI->config->item('approval_year') as $key => $value) {
?>
<option value="<?php
echo $key;
?>
"><?php
echo System_helper::Get_Eng_to_Bng($value);
?>
</option>
<?php
}
?>
</select>
</div>
</div>
<div class="row show-grid">
<div class="col-xs-4">
</div>
<div class="col-sm-4 col-xs-8">
<input type="submit" class="btn btn-primary" value="<?php
echo $CI->lang->line('SEARCH');
?>
</th>
<th><?php
echo $this->lang->line('SERVICE_NAME');
?>
</th>
</tr>
</thead>
<tbody>
<?php
if (is_array($services) && sizeof($services) > 0) {
foreach ($services as $key => $service) {
?>
<tr>
<td><?php
echo System_helper::Get_Eng_to_Bng($key + 1);
?>
</td>
<td><?php
echo $service['service_name'];
?>
</td>
</tr>
<?php
}
} else {
echo $this->lang->line('DO_DATA_FOUND');
}
?>
</tbody>
</table>
</td>
<td style="text-align: center"><span
class="label label-primary"><?php
echo System_helper::Get_Eng_to_Bng($product['nub_of_product']);
?>
</span>
</td>
<td style="text-align: center"><span
class="label label-warning"> <?php
echo System_helper::Get_Eng_to_Bng($product['nub_of_product'] - ($nub_of_product_warehouse = isset($data['current_product'][$product['product_name']]) ? $data['current_product'][$product['product_name']]['nub_of_product'] : 0));
?>
</span>
</td>
<td style="text-align: center"><span class="label label-success">
<?php
echo System_helper::Get_Eng_to_Bng(isset($data['current_product'][$product['product_name']]) ? $data['current_product'][$product['product_name']]['nub_of_product'] : 0);
?>
</span>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
</body>
</html>
?>
<!--</td>-->
<td align='center'><?php
echo $report_record['unionname'];
?>
</td>
<!-- <td align='center'>--><?php
//echo $report_record['municipalname']
?>
<!--</td>-->
<!-- <td align='center'>--><?php
//echo $report_record['citycorporationname']
?>
<!--</td>-->
<td align='center'><?php
echo System_helper::Get_Eng_to_Bng($report_record['total_service']);
?>
</td>
</tr>
<?php
}
}
?>
</tbody>
</table>
</div>
</div>
</div>
<script>
function winclose()
</td>
<?php
} else {
if ($report_status == 3) {
?>
<td><?php
echo System_helper::Get_Eng_to_Bng($grand_total_local_service);
?>
</td>
<?php
}
}
}
}
?>
<td><?php
echo System_helper::Get_Eng_to_Bng($grand_total_all_service);
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
</body>
</html>
<div class="clearfix"></div>
<div id="system_content" class="dashboard-wrapper">
<div class="grid_12" >
<div class="container">
<section class="main">
<ul class="timeline">
<?php
if (is_array($notices) && sizeof($notices) > 0) {
foreach ($notices as $notice) {
?>
<li class="event">
<input type="radio" name="tl-group"/>
<label></label>
<div class="thumb user-3"><span><?php
echo System_helper::Get_Eng_to_Bng(date('Y-m-d', $notice['create_date']));
?>
</span></div>
<div class="content-perspective">
<div class="content">
<div class="content-inner">
<h3><?php
echo $notice['notice_title'];
?>
</h3>
<p>
<?php
echo $notice['notice_details'];
if ($notice['upload_file'] != '') {
?>
<br/><br/>
} else {
echo $uisc['uisc_name'];
$uisc_name = $uisc['uisc_name'];
}
}
?>
</td>
<!--<td>--><?php
//echo System_helper::Get_Bangla_Month($invoice['invoice_month']);
?>
<!--</td>-->
<?php
if ($report_status == '100') {
?>
<td><?php
echo System_helper::Get_Eng_to_Bng($invoice['increment_date']);
?>
</td>
<?php
}
?>
<td><?php
echo $upload_yes;
echo $upload_no;
?>
</td>
</tr>
<?php
}
} else {
</td>
<td><?php
echo isset($report_lists[$i - 1]) && $report_lists[$i]['citycorporationwardid'] == $report_lists[$i - 1]['citycorporationwardid'] ? '' : $report_lists[$i]['wardname'];
?>
</td>
<td><?php
echo $report_lists[$i]['uisc_name'];
?>
</td>
<td>
<?php
//echo System_helper::Get_Eng_to_Bng();
$date = explode('-', $report_lists[$i]['invoice_date']);
echo System_helper::Get_Eng_to_Bng($date[2]) . ' ';
echo System_helper::Get_Bangla_Month($date[1]) . ', ';
echo System_helper::Get_Eng_to_Bng($date[0]);
?>
</td>
<td style="text-align: center;"><?php
echo $union_total;
?>
</td>
</tr>
<?php
}
?>
<!-- <tr style="background-color: #cccccc">-->
<!-- <td colspan="2"> </td>-->
<!-- <td >--><?php
//echo $this->lang->line('CITY_CORPORATION');
?>
<td align='center'><?php
echo $report_record['upazilaname'];
?>
</td>
<td align='center'><?php
echo $report_record['municipalname'];
?>
</td>
<td align='center'><?php
echo $report_record['zillaname'];
?>
</td>
<td align='center'><?php
echo $report_record['citycorporationname'];
?>
</td>
<td align='center'><?php
echo System_helper::Get_Eng_to_Bng($report_record['total_income']);
?>
</td>
</tr>
<?php
}
}
?>
</tbody>
</table>
</div>
</div>
</div>
<!-- <td> </td>-->
<!-- <td align="right">--><?php
//echo $this->lang->line('TOTAL');
?>
<!--:</td>-->
<!-- <td style="text-align: center;">--><?php
//echo System_helper::Get_Eng_to_Bng($total_division);
?>
<!--</td>-->
<!-- </tr>-->
<tr>
<td> </td>
<td colspan="5" align="right"><?php
echo $this->lang->line('IN_TOTAL');
?>
: </td>
<td style="text-align: center;"><?php
echo System_helper::Get_Eng_to_Bng($total);
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
</body>
</html>
</div>
</div>
</div>
</div>
<!-- END SAMPLE TABLE PORTLET-->
</div>
<div class="col-md-6">
<!-- BEGIN SAMPLE TABLE PORTLET-->
<div class="portlet box green">
<div class="portlet-title">
<div class="caption">
<i class="fa fa-shopping-cart"></i><?php
echo $CI->lang->line('MY_PRODUCTS_LIST');
?>
<span class="label label-warning"><?php
echo System_helper::Get_Eng_to_Bng(count($get_product_list));
?>
</span>
</div>
<div class="tools">
<a href="javascript:;" class="collapse external">
</a>
<a href="javascript:;" class="remove external">
</a>
</div>
</div>
<div class="portlet-body">
<div class="scroller" style="height: 300px;" data-always-visible="1" data-rail-visible="0">
<?php
if (!count($get_product_list)) {
echo '<h3 class="text-center"><span class="label label-danger">' . $CI->lang->line('NO_DATA_FOUND') . '</span></h3>';
<th><?php
echo System_helper::Get_Eng_to_Bng(number_format($grand_total_income, 0));
?>
</th>
<th><?php
echo System_helper::Get_Eng_to_Bng(number_format($grand_total_service_holder, 0));
?>
</th>
<th><?php
echo System_helper::Get_Eng_to_Bng(number_format($grand_total_report_upload_percentage, 0));
?>
</th>
<th><?php
echo System_helper::Get_Eng_to_Bng(number_format($grand_total_income_percentage, 0));
?>
</th>
<th><?php
echo System_helper::Get_Eng_to_Bng(number_format($grand_total_service_holder_percentage, 0));
?>
</th>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
</body>
</html>
//$services_column=$total_service/3;
$sl = 0;
foreach ($services as $service) {
++$sl;
?>
<tr>
<td><?php
echo System_helper::Get_Eng_to_Bng($sl);
?>
</td>
<td><?php
echo $service['service_name'];
?>
</td>
<td><?php
echo System_helper::Get_Eng_to_Bng($service['service_amount']);
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
<?php
}
?>
</div>
</div>
</div>
