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++; } }