<?php

function get_sales_manage_table_headers(){
	$CI =& get_instance();

	$headers = array(
		array('sale_id' => $CI->lang->line('common_id')),
		array('sale_time' => $CI->lang->line('sales_sale_time')),
		array('customer_name' => $CI->lang->line('customers_customer')),
		array('amount_tendered' => $CI->lang->line('sales_amount_tendered')),
		array('amount_due' => $CI->lang->line('sales_amount_due')),
		array('change_due' => $CI->lang->line('sales_change_due')),
		//array('payment_type' => $CI->lang->line('sales_payment_type'))
	);
	
	if($CI->config->item('invoice_enable') == TRUE)
	{
		$headers[] = array('invoice_number' => $CI->lang->line('sales_invoice_number'));
		$headers[] = array('invoice' => '&nbsp', 'sortable' => FALSE);
	}
	$headers[]  = array('pending_due' => "");

	return transform_headers(array_merge($headers, array(array('receipt' => '&nbsp', 'sortable' => FALSE))));
}

function get_receiving_manage_table_headers(){
	$CI =& get_instance();

	$headers = array(
		array('bill' => "ID"),
		array('revdate' => "Received Date"),
		array('name' => "Supplier Name"),
		array('total' => "Total Amount"),
		array('paid' => "Paid Amount"),
		array('pending' => "Pending Amount"),
		array('invoice' => ""),
		array('pending_due' => "list")
	);
	return transform_headers(array_merge($headers, array(array('receipt' => '&nbsp', 'sortable' => FALSE))));
}
function get_receiving_data_last_row($receiving, $controller){
	$CI =& get_instance();
	$controller_name = $CI->uri->segment(1);
	$data_rows = array();
	foreach($receiving as $key=>$rec){
		
		$row = array (
			'bill' => "RECV".$rec->bill,
			'revdate' => date("d-m-Y", strtotime($rec->revdate)),
			'name' => $rec->name,
			'total' => number_format($rec->total,2),
			'paid' => number_format($rec->paid,2),
			'pending' => number_format($rec->pending,2),

		);
		$row['invoice'] = anchor($controller_name."/invoice/$rec->bill", '<span class="glyphicon glyphicon-list-alt"></span>',array('title'=>"Invoice"));
		$row['pending_due'] = anchor($controller_name."/pending_due/$rec->bill", '<span class="glyphicon glyphicon-plus"></span>',
		array('class'=>"modal-dlg print_hide", 'data-btn-delete' => $CI->lang->line('common_delete'), 'data-btn-submit' => $CI->lang->line('common_submit'), 'title' => "Add Payments")
		);
		$data_rows[] = $row;
	}
	return $data_rows;
}
/*
 Gets the html data rows for the sales.
 */
function get_sale_data_last_row($sales, $controller){
	$CI =& get_instance();
	$table_data_rows = '';
	$sum_amount_tendered = 0;
	$sum_amount_due = 0;
	$sum_change_due = 0;

	foreach($sales->result() as $key=>$sale){
		$sum_amount_tendered += $sale->amount_tendered;
		$sum_amount_due += $sale->amount_due;
		$sum_change_due += $sale->change_due;
	}
	return array(
		'sale_id' => '-',
		'sale_time' => '<b>'.$CI->lang->line('sales_total').'</b>',
		'amount_tendered' => '<b>'. to_currency($sum_amount_tendered).'</b>',
		'amount_due' => '<b>'.to_currency($sum_amount_due).'</b>',
		'change_due' => '<b>'.to_currency($sum_change_due).'</b>'
	);
}

function get_sale_data_row($sale, $controller){
	$CI =& get_instance();
	$controller_name = $CI->uri->segment(1);

	$row = array (
		'sale_id' => $sale->invoice_number,
		'sale_time' => date("d-m-Y", strtotime($sale->sale_time)),
		'customer_name' => $sale->customer_name,
		'amount_tendered' => to_currency($sale->amount_tendered),
		'amount_due' => to_currency($sale->amount_due),
		'change_due' => to_currency($sale->change_due),
		'payment_type' => $sale->payment_type
	);

	if($CI->config->item('invoice_enable'))
	{
		$row['invoice_number'] = $sale->invoice_number;
		$row['invoice'] = empty($sale->invoice_number) ? '' : anchor($controller_name."/invoice/$sale->sale_id", '<span class="glyphicon glyphicon-list-alt"></span>',
			array('title'=>$CI->lang->line('sales_show_invoice'))
		);
	}

	$row['receipt'] = anchor($controller_name."/receipt/$sale->sale_id", '<span class="glyphicon glyphicon-usd"></span>',
		array('title'=>$CI->lang->line('sales_show_receipt'))
	);
	$row['edit'] = anchor($controller_name."/edit/$sale->sale_id", '<span class="glyphicon glyphicon-edit"></span>',
		array('class'=>"modal-dlg print_hide", 'data-btn-delete' => $CI->lang->line('common_delete'), 'data-btn-submit' => $CI->lang->line('common_submit'), 'title' => $CI->lang->line($controller_name.'_update'))
	);
   $row['pending_due'] = anchor($controller_name."/pending_due/$sale->sale_id", '<span class="glyphicon glyphicon-plus"></span>',
	array('class'=>"modal-dlg print_hide", 'data-btn-delete' => $CI->lang->line('common_delete'), 'data-btn-submit' => $CI->lang->line('common_submit'), 'title' => "Add Payments")
	);
	return $row;
}

/*
Get the sales payments summary
*/
function get_sales_manage_payments_summary($payments, $sales, $controller)
{
	$CI =& get_instance();
	$table = '<div id="report_summary">';

	foreach($payments as $key=>$payment)
	{
		$amount = $payment['payment_amount'];

		// WARNING: the strong assumption here is that if a change is due it was a cash transaction always
		// therefore we remove from the total cash amount any change due
		if( $payment['payment_type'] == $CI->lang->line('sales_cash') )
		{
			foreach($sales->result_array() as $key=>$sale)
			{
				$amount -= $sale['change_due'];
			}
		}
		$table .= '<div class="summary_row">' . $payment['payment_type'] . ': ' . to_currency( $amount ) . '</div>';
	}
	$table .= '</div>';

	return $table;
}

function transform_headers_readonly($array)
{
	$result = array();
	foreach($array as $key => $value)
	{
		$result[] = array('field' => $key, 'title' => $value, 'sortable' => $value != '', 'switchable' => !preg_match('(^$|&nbsp)', $value));
	}

	return json_encode($result);
}

function transform_headers($array)
{
	$result = array();
	$array = array_merge(array(array('checkbox' => 'select', 'sortable' => FALSE)),
		$array, array(array('edit' => '')));
	foreach($array as $element)
	{
		$result[] = array('field' => key($element),
			'title' => current($element),
			'switchable' => isset($element['switchable']) ?
				$element['switchable'] : !preg_match('(^$|&nbsp)', current($element)),
			'sortable' => isset($element['sortable']) ?
				$element['sortable'] : current($element) != '',
			'checkbox' => isset($element['checkbox']) ?
				$element['checkbox'] : FALSE,
			'class' => isset($element['checkbox']) || preg_match('(^$|&nbsp)', current($element)) ?
				'print_hide' : '');
	}

	//echo json_encode($result); die;
	return json_encode($result);
}

function get_people_manage_table_headers()
{
	$CI =& get_instance();


	$headers = array(
		/*array('people.person_id' => $CI->lang->line('common_id')),*/
		//array('last_name' => $CI->lang->line('common_last_name')),
		array('first_name' => $CI->lang->line('common_first_name')),
		array('email' => $CI->lang->line('common_email')),
		array('phone_number' => $CI->lang->line('common_phone_number'))
		
	);

	//print_r($headers);die();

	if($CI->Employee->has_grant('messages', $CI->session->userdata('person_id')))
	{
		$headers[] = array('messages' => '', 'sortable' => FALSE);
	}
	
	return transform_headers($headers);
}
function get_people_data_row($person, $controller)
{
	$CI =& get_instance();
	$controller_name=strtolower(get_class($CI));

	return array (
		//'people.person_id' => $person->person_id,
		//'last_name' => $person->last_name,
		'first_name' => $person->first_name,
		'email' => empty($person->email) ? '' : mailto($person->email, $person->email),
		'phone_number' => $person->phone_number,
		'messages' => empty($person->phone_number) ? '' : anchor("Messages/view/$person->person_id", '<span class="glyphicon glyphicon-phone"></span>', 
			array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line('messages_sms_send'))),
		'edit' => anchor($controller_name."/view/$person->person_id", '<span class="glyphicon glyphicon-edit"></span>',
			array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
	));
}

function get_person_manage_table_headers(){
	$CI =& get_instance();
	$headers = array(
		/*array('people.person_id' => $CI->lang->line('common_id')),*/
		array('company_name' => $CI->lang->line('customers_company_name')),
		array('first_name' => "Name"),
		array('trans_place' => "Place"),
		array('addr' => "Address"),
		array('phone_number' => $CI->lang->line('common_phone_number')),
		array('gst_in' => "GSTIN"),
		array('email' => "Email")
	);
	return transform_headers($headers);
}
function get_person_data_row($person, $controller)
{
	$CI =& get_instance();
	$controller_name=strtolower(get_class($CI));

	return array (
		'people.person_id' => $person->person_id,
		'company_name' => $person->company_name,
		'first_name' => $person->first_name,
		'trans_place' => $person->trans_place,		
		'addr' => $person->address_1 ." , ". $person->address_2 ." , ". $person->city ." , ". $person->state ." , ". $person->zip." , ". $person->country,
		'email' => empty($person->email) ? '' : mailto($person->email, $person->email),
		'phone_number' => $person->phone_number . " , ". $person->phone_number_alt,
		'gst_in' => $person->gst_in,
		'messages' => empty($person->phone_number) ? '' : anchor("Messages/view/$person->person_id", '<span class="glyphicon glyphicon-phone"></span>', 
			array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line('messages_sms_send'))),
		'edit' => anchor($controller_name."/view/$person->person_id", '<span class="glyphicon glyphicon-edit"></span>',
			array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
	));
}

function get_suppliers_manage_table_headers()
{
	$CI =& get_instance();

	// $headers = array(
	// 	/*array('people.person_id' => $CI->lang->line('common_id')),*/
	// 	array('company_name' => $CI->lang->line('suppliers_company_name')),
	// 	array('agency_name' => $CI->lang->line('suppliers_agency_name')),
	// 	//array('last_name' => $CI->lang->line('common_last_name')),
	// 	array('first_name' => $CI->lang->line('common_first_name')),
	// 	//array('email' => $CI->lang->line('common_email')),
	// 	array('phone_number' => $CI->lang->line('common_phone_number'))
	// );

	// if($CI->Employee->has_grant('messages', $CI->session->userdata('person_id')))
	// {
	// 	$headers[] = array('messages' => '');
	// }
	$headers = array(
		/*array('people.person_id' => $CI->lang->line('common_id')),*/
		array('company_name' => $CI->lang->line('suppliers_company_name')),
		array('first_name' => "Name"),
		array('trans_place' => "Place"),
		array('addr' => "Address"),
		array('phone_number' => $CI->lang->line('common_phone_number')),
		array('gst_in' => "GSTIN"),
		array('email' => "Email")
	);
	return transform_headers($headers);
}

function get_supplier_data_row($supplier, $controller)
{
	$CI =& get_instance();
	$controller_name=strtolower(get_class($CI));

	return array (
		'people.person_id' => $supplier->person_id,
		'company_name' => $supplier->company_name,
		'first_name' => $supplier->first_name,
		'trans_place' => $supplier->trans_place,
		'addr' => $supplier->address_1 ." , ". $supplier->address_2 ." , ". $supplier->city ." , ". $supplier->state ." , ". $supplier->zip." , ". $supplier->country,
		'email' => empty($supplier->email) ? '' : mailto($supplier->email, $supplier->email),
		'phone_number' => $supplier->phone_number . " , ". $supplier->phone_number_alt,
		'gst_in' => $supplier->gst_in,
		//'agency_name' => $supplier->agency_name,
		//'last_name' => $supplier->last_name,
		//'first_name' => $supplier->first_name,
		//'email' => empty($supplier->email) ? '' : mailto($supplier->email, $supplier->email),
		
		'messages' => empty($supplier->phone_number) ? '' : anchor("Messages/view/$supplier->person_id", '<span class="glyphicon glyphicon-phone"></span>', 
			array('class'=>"modal-dlg", 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line('messages_sms_send'))),
		'edit' => anchor($controller_name."/view/$supplier->person_id", '<span class="glyphicon glyphicon-edit"></span>',
			array('class'=>"modal-dlg", 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update')))
		);
}

function get_items_manage_table_headers()
{
	$CI =& get_instance();

	$headers = array(
		/*array('items.item_id' => $CI->lang->line('common_id')),*/
		//array('item_number' => $CI->lang->line('items_item_number')),
		array('name' => $CI->lang->line('items_name')),
		array('category' => $CI->lang->line('items_category')),
		array('hsn_code' => "HSN Code"),
		array('company_name' => $CI->lang->line('suppliers_company_name')),
		array('cost_price' => $CI->lang->line('items_cost_price')),
		//array('unit_price' => $CI->lang->line('items_unit_price')),
		array('quantity' => $CI->lang->line('items_quantity')),
		array('tax_percents' => $CI->lang->line('items_tax_percents'), 'sortable' => FALSE),
		//array('item_pic' => $CI->lang->line('items_image'), 'sortable' => FALSE),
		array('inventory' => ''),
		array('stock' => '')
	);

	return transform_headers($headers);
}

function get_item_data_row($item, $controller)
{
	$CI =& get_instance();
	$item_tax_info=$CI->Item_taxes->get_info($item->item_id);
	$tax_percents = '';
	foreach($item_tax_info as $tax_info)
	{
		$tax_percents.=to_tax_decimals($tax_info['percent']) . '%, ';
	}
	// remove ', ' from last item
	$tax_percents=substr($tax_percents, 0, -2);
	$controller_name=strtolower(get_class($CI));

	$image = '';
	if (!empty($item->pic_id))
	{
		$images = glob("uploads/item_pics/" . $item->pic_id . ".*");
		if (sizeof($images) > 0)
		{
			$image .= '<a class="rollover" href="'. base_url($images[0]) .'"><img src="'.site_url('items/pic_thumb/'.$item->pic_id).'"></a>';
		}
	}

	return array (
		'items.item_id' => $item->item_id,
		'item_number' => $item->item_number,
		'name' => $item->name,
		'category' => $item->category,
		'hsn_code' =>$item->hsn_code,
		'company_name' => $item->company_name,
		'cost_price' => to_currency($item->cost_price),
		'unit_price' => to_currency($item->unit_price),
		'quantity' => to_quantity_decimals($item->quantity),
		'tax_percents' => !$tax_percents ? '-' : $tax_percents,
		'item_pic' => $image,
		'inventory' => anchor($controller_name."/inventory/$item->item_id", '<span class="glyphicon glyphicon-pushpin"></span>',
			array('class' => 'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title' => $CI->lang->line($controller_name.'_count'))
		),
		'stock' => anchor($controller_name."/count_details/$item->item_id", '<span class="glyphicon glyphicon-list-alt"></span>',
			array('class' => 'modal-dlg', 'title' => $CI->lang->line($controller_name.'_details_count'))
		),
		'edit' => anchor($controller_name."/view/$item->item_id", '<span class="glyphicon glyphicon-edit"></span>',
			array('class' => 'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title' => $CI->lang->line($controller_name.'_update'))
		));
}

function get_giftcards_manage_table_headers()
{
	$CI =& get_instance();

	$headers = array(
		/*array('giftcard_id' => $CI->lang->line('common_id')),*/
		array('last_name' => $CI->lang->line('common_last_name')),
		array('first_name' => $CI->lang->line('common_first_name')),
		array('giftcard_number' => $CI->lang->line('giftcards_giftcard_number')),
		array('value' => $CI->lang->line('giftcards_card_value'))
	);

	return transform_headers($headers);
}

function get_giftcard_data_row($giftcard, $controller)
{
	$CI =& get_instance();
	$controller_name=strtolower(get_class($CI));

	return array (
		'giftcard_id' => $giftcard->giftcard_id,
		'last_name' => $giftcard->last_name,
		'first_name' => $giftcard->first_name,
		'giftcard_number' => $giftcard->giftcard_number,
		'value' => to_currency($giftcard->value),
		'edit' => anchor($controller_name."/view/$giftcard->giftcard_id", '<span class="glyphicon glyphicon-edit"></span>',
			array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
		));
}

function get_item_kits_manage_table_headers()
{
	$CI =& get_instance();

	$headers = array(
		/*array('item_kit_id' => $CI->lang->line('item_kits_kit')),*/
		array('name' => $CI->lang->line('item_kits_name')),
		//array('description' => $CI->lang->line('item_kits_description')),
		array('cost_price' => "price", 'sortable' => FALSE),
		//array('unit_price' => $CI->lang->line('items_unit_price'), 'sortable' => FALSE)
	);

	return transform_headers($headers);
}

function get_item_kit_data_row($item_kit, $controller)
{
	$CI =& get_instance();
	$controller_name=strtolower(get_class($CI));

	return array (
		'item_kit_id' => $item_kit->item_kit_id,
		'name' => $item_kit->name,
		'description' => $item_kit->description,
		'cost_price' => to_currency($item_kit->total_cost_price),
		'unit_price' => to_currency($item_kit->total_unit_price),
		'edit' => anchor($controller_name."/view/$item_kit->item_kit_id", '<span class="glyphicon glyphicon-edit"></span>',
			array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
		));
}
 function get_reorder_manage_table_headers(){
 	$CI =& get_instance();
	$headers = array(
		array('item_name' => $CI->lang->line('reord_item_name')),
		array('supplier_name' => $CI->lang->line('reord_supplier_name')),
		array('reorder_qnt' => $CI->lang->line('reord_qnt')),
		array('status' =>$CI->lang->line('reord_sts')),
		array('receiving_qnt' =>$CI->lang->line('receiving_qnt'))
	);
 	return transform_headers($headers);
 }
 function get_reorder_data_row($reorder, $controller){
	$CI =& get_instance();
	$controller_name=strtolower(get_class($CI));
	$status = "";
	if($reorder->status === "0"){
		$status = "Pending";
	}else{
		$status = "Received";
	}
	return array ('item_name' => $reorder->item_name,
				'supplier_name' => $reorder->supplier_name,
				'reorder_qnt' => $reorder->reorder_qnt,
				'status' => $status,
				'receiving_qnt'=>$reorder->receiving_qnt);
}
function get_hsn_manage_table_headers(){
	$CI =& get_instance();

	$headers = array(
	//array('form_no' => $CI->lang->line('common_hsn_formno')),
	array('hsn_code' => $CI->lang->line('common_hsn_code')),
	array('hsn_name' => $CI->lang->line('common_hsn_name')),
	//array('hsn_desc' => $CI->lang->line('common_hsn_desc')),
	array('sgst' => $CI->lang->line('common_hsn_sgst')),
	array('cgst' => $CI->lang->line('common_hsn_cgst')),
	array('igst' => $CI->lang->line('common_hsn_igst')),
	//array('cess' => $CI->lang->line('common_hsn_cess')),
	);
	return transform_headers($headers);
}
function get_hsn_table_rows($hsn,$controller){
	$CI =& get_instance();
	$controller_name=strtolower(get_class($CI));

	return array(
		'slno' => $hsn->slno,
		'form_no' => $hsn->form_no,
		'hsn_code' => $hsn->hsn_code,
		'hsn_name' => $hsn->hsn_name,
		'hsn_desc' => $hsn->hsn_desc,
		'sgst' => $hsn->sgst,
		'cgst' => $hsn->cgst,
		'igst' => $hsn->igst,
		'cess' => $hsn->cess,
		'edit' => anchor("hsn/hsnview/$hsn->slno","<span class='glyphicon glyphicon-edit'></span>",array('class'=>'modal-dlg', 'data-btn-submit' => 'Submit', 'title'=>'Upadte HSN'))
		);
}
function get_transport_manage_table_headers(){
	$CI =& get_instance();

	$headers = array(
	array('booking_date' => $CI->lang->line('booking_date')),
	array('company_name' => $CI->lang->line('company_name')),
	array('place' => $CI->lang->line('place')),
	array('lrno' => $CI->lang->line('lrno')),
	array('no_of_pack' => $CI->lang->line('no_of_pack')),
	array('transport_name' => $CI->lang->line('transport_name')),
	array('transport_mob_no' => $CI->lang->line('transport_mob_no')),	
	array('booking_type' => $CI->lang->line('booking_type')),
	array('amount' => $CI->lang->line('amount'))
	);
	return transform_headers($headers);
}
function get_transport_table_rows($transport,$controller){
	$CI =& get_instance();
	$controller_name=strtolower(get_class($CI));
	if((int)$transport->booking_type === 1){
		$booking_type = "To pay";
	}else{
		$booking_type = "Pay";
	}
	return array(
		'booking_date' => date("d-m-Y", strtotime($transport->booking_date)),
		'company_name' => $transport->company_name,
		'place' => $transport->place,
		'lrno' => $transport->lrno,
		'no_of_pack' => $transport->no_of_pack,
		'transport_name' => $transport->transport_name,
		'transport_mob_no' => $transport->transport_mob_no,
		'booking_type' => $booking_type,
		'amount' => $transport->amount,
		'edit' => anchor("transport/view/$transport->id","<span class='glyphicon glyphicon-edit'></span>",array('class'=>'modal-dlg', 'data-btn-submit' => 'Submit', 'title'=>'Upadte Booking'))
		);
}
function get_expense_manage_table_headers(){
	$CI =& get_instance();

	$headers = array(
	array('expense_date' => $CI->lang->line('date')),
	array('voucher_no' => $CI->lang->line('voucher_no')),
	array('expense_info' => $CI->lang->line('expense_info')),
	array('remarks' => $CI->lang->line('remarks')),
	array('method' => $CI->lang->line('method')),
	array('amount' => $CI->lang->line('amount'))	
	);
	return transform_headers($headers);
}
function get_expense_table_rows($expense,$controller){
	$CI =& get_instance();
	$controller_name=strtolower(get_class($CI));

	return array(
		'expense_date' => date("d-m-Y", strtotime($expense->expense_date)),
		'voucher_no'=>$expense->voucher_no,
		'expense_info' => $expense->expense_info,
		'remarks' => $expense->remarks,
		'method' => $expense->method,
		'amount' => $expense->amount,		
		'edit' => anchor("expense/view/$expense->id","<span class='glyphicon glyphicon-edit'></span>",array('class'=>'modal-dlg', 'data-btn-submit' => 'Submit', 'title'=>'Upadte Expense'))
		);
}
?>