</th>
<th></th>
<th><?php
echo rupee_format($grand_total_shortage_amount);
?>
</th>
<th><?php
echo rupee_format($grand_total_payable_before_tax);
?>
</th>
<th><?php
echo rupee_format($grand_total_tax_amount);
?>
</th>
<th><?php
echo rupee_format($grand_total_net_payable);
?>
</th>
</tr>
</tfoot>
</table>
</div>
</div>
</div>
</div>
</div>
<?php
echo in_array('tanker_number', $selected_columns) == true ? "<td></td>" : "";
?>
<?php
echo in_array('productName', $selected_columns) == true ? "<td></td>" : "";
?>
<?php
echo in_array('product_quantity', $selected_columns) == true ? "<td>" . rupee_format($total_product_quantity) . "</td>" : "";
?>
<?php
echo in_array('shortage_amount', $selected_columns) == true ? "<td><?= rupee_format({$total_shortage_amount}) ?></td>" : "";
?>
<?php
echo in_array('source', $selected_columns) == true ? "<td></td>" : "";
?>
<?php
echo in_array('stn_number', $selected_columns) == true ? "<td></td>" : "";
?>
<?php
echo in_array('company', $selected_columns) == true ? "<td></td>" : "";
?>
<?php
echo in_array('company_freight_unit', $selected_columns) == true ? "<td></td>" : "";
?>
<?php
echo in_array('total_freight_cmp', $selected_columns) == true ? "<td>" . rupee_format($grand_total_freight_for_company) . "</td>" : "";
?>
<?php
echo in_array('wht_amount', $selected_columns) == true ? "<td>" . rupee_format($total_wht) . "</td>" : "";
?>
<?php
<th></th>
<th colspan=""><?php
echo rupee_format($grand_total_freight_for_customer);
?>
</th>
<th colspan=""><?php
echo rupee_format($total_customer_freight_amount);
?>
</th>
<th colspan=""><?php
echo rupee_format($grand_total_customer_net_freight_without_shortage);
?>
</th>
<th colspan="">
<div style="border-bottom: 0px solid lightgray;"><?php
echo rupee_format($total_service_charges);
?>
</div>
</th>
<th></th>
</tr>
</tfoot>
</table>
</form>
</div>
<!--//pages-->
<div class="col-lg-12 text-center">
<?php
echo $pages;
?>
</div>
?>
</td>
<?php
}
?>
<?php
if (in_array('net_payable', $columns) == true) {
?>
<td style="text-align:center;">
<div class="dr_cr_status"><?php
echo $detail->get_dr_cr_status('contractor_freight');
?>
</div>
<?php
echo rupee_format($net_payable);
?>
</td>
<?php
}
?>
<?php
if (in_array('contractor_net_freight', $columns) == true) {
?>
<td style="text-align:center;">
<?php
echo rupee_format($contractor_net_freight);
?>
</td>
<?php
$total_freight_for_company = round($detail->get_total_freight_for_company(), 3);
$grand_total_freight_for_company += $total_freight_for_company;
echo $this->helper_model->money($total_freight_for_company);
?>
</td>
<td> OK </td>
<td>
<?php
$voucher = $detail->get_voucher_of_total_freight_for_company();
$date = $voucher->voucher_date;
echo Carbon::createFromFormat('Y-m-d', $date)->toFormattedDateString();
?>
</td>
<td><?php
echo rupee_format($total_freight_for_company);
?>
</td>
</tr>
<?php
}
?>
<?php
}
?>
<?php
}
?>
</tbody>
<tfoot>
<tr style="background-color: #333333; color:white;">
?>
<?php
echo in_array('total_freight_cst', $columns) == true ? "<td>" . rupee_format($grand_total_frieght_cst) . "</td>" : "";
?>
<?php
echo in_array('freight_amount_cst', $columns) == true ? "<td>" . rupee_format($total_freight_amount_cst) . "</td>" : "";
?>
<?php
echo in_array('customer_freight', $columns) == true ? "<td>" . rupee_format($total_customer_freight) . "</td>" : "";
?>
<!--customer-->
<?php
echo in_array('customer', $columns) == true ? "<td></td>" : "";
?>
<?php
echo in_array('service_charges', $columns) == true ? "<td>" . rupee_format($total_service_charges) . "</td>" : "";
?>
<?php
echo in_array('billed', $columns) == true ? "<td></td>" : "";
?>
</tr>
</tfoot>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
public function get_footer_value_of($property)
{
$viewable_value = "";
$total_property_name = "total_" . $property;
if (in_array($property, $this->money_attributes)) {
//$viewable_value = rupee_format($this->$total_property_name);
} else {
if (in_array($property, $this->addable_money_attributes)) {
$viewable_value = rupee_format($this->{$total_property_name});
} else {
if (in_array($property, $this->addable_numeric_attributes)) {
$viewable_value = $this->{$total_property_name};
} else {
if (in_array($property, $this->numeric_attributes)) {
} else {
if (in_array($property, $this->date_attributes)) {
} else {
$viewable_value = "";
}
}
}
}
}
return $viewable_value;
}
?>
</td>
<td><?php
echo Carbon::createFromFormat('Y-m-d', $shortage->date)->toFormattedDateString();
?>
</td>
<td><?php
echo $shortage->quantity;
?>
</td>
<td><?php
echo round($shortage->rate, 2);
?>
</td>
<td><?php
echo rupee_format(round($shortage->shortage_amount, 2));
?>
</td>
<td>
<a href="<?php
echo base_url() . "shortages/edit/" . $shortage->shortage_id;
?>
" class="edit_shortage btn btn-xs btn-warning">Edit</a>
<a class="btn btn-xs btn-danger" onclick="return confirm_deleting()" href="<?php
echo url_path() . "?" . merge_query($_SERVER['QUERY_STRING'], array('del' => $shortage->shortage_id));
?>
">Del</a>
<?php
if ($shortage->committed == false) {
?>
<a href="#commit-shortages-popup" onclick="set_shortage_id_for_commit(<?php
?>
</td>
</tr>
<?php
}
?>
</tbody>
<tfoot>
<tr style="background-color: lightgray;">
<th colspan="4">Totals</th>
<th><?php
echo rupee_format($total_shortage_quantity);
?>
</th>
<th><?php
echo rupee_format($total_shortage_amount);
?>
</th>
</tr>
</tfoot>
</table>
</div>
</div>
</div>
</div>
</div>
echo in_array('freight_amount', $columns) == true ? "<td>" . rupee_format($grand_total_freight_amount) . "</td>" : "";
?>
<?php
echo in_array('shortage_rate', $columns) == true ? "<td></td>" : "";
?>
<?php
echo in_array('shortage_amount', $columns) == true ? "<td>" . rupee_format($grand_total_shortage_amount) . "</td>" : "";
?>
<?php
echo in_array('payable_before_tax', $columns) == true ? "<td>" . rupee_format($grand_total_payable_before_tax) . "</td>" : "";
?>
<?php
echo in_array('tax', $columns) == true ? "<td>" . rupee_format($grand_total_tax_amount) . "</td>" : "";
?>
<?php
echo in_array('net_payable', $columns) == true ? "<td>" . rupee_format($grand_total_net_payable) . "</td>" : "";
?>
</tr>
</tfoot>
</table>
</div>
</div>
</div>
</div>
</div>
