public function kemsa_approve_order()
{
$this->load->helper('string');
$delivery = $this->uri->segment(3);
$order_details_array = Orderdetails::get_order($delivery);
$myobj = Doctrine::getTable('Ordertbl')->find($delivery);
$o_total = $myobj->orderTotal;
$f_code = $myobj->facilityCode;
$o_date = $myobj->orderDate;
$count = 1;
$code = random_string('alnum', 6);
$code2 = random_string('alnum', 6);
$date = date("y-m-d");
$kemsa_order_input = array("kemsa_order_no" => $code, "local_order_no" => $delivery, "order_batch_no" => $code2, "order_total" => $o_total, "facility_mfl_code" => $f_code, "dispatch_date" => date($date, strtotime('+2 weeks')), "recieve_date" => date($date, strtotime('+1 weeks')), "order_date" => $o_date);
$myobj->dispatchDate = date($date, strtotime('+2 weeks'));
$myobj->orderStatus = 'dispatched';
$myobj->save();
$u1 = new Kemsa_Order();
$u1->fromArray($kemsa_order_input);
$u1->save();
foreach ($order_details_array as $data) {
$input_array = array("kemsa_code" => $data->kemsa_code, "kemsa_order_no" => $code, "batch_no" => 'AB' . $count, "quantity" => $data->quantityOrdered, "expiry_date" => '2013-10-15', "manufacture" => 'GlaxoSmithkline');
$u = new Kemsa_Order_Details();
$u->fromArray($input_array);
$u->save();
$count++;
}
}
