/**
* static function to read the xls and store
*
* @param int $id
* @return Response*/
public static function orderimport_xls($pathname, $camp_id, $campid, $description, $object_id)
{
$camp = Camp::findOrFail($camp_id);
Excel::load($pathname, function ($reader) use($camp) {
$results = $reader->get();
foreach ($results as $result) {
$save['order_id'] = $result->order_id;
$save['warehouse'] = $result->warehouse;
$save['ship_date'] = date('Y-m-d H:i:s', strtotime($result->ship_date));
$save[$status] = $result->status;
$save['order_amount'] = $result->order_amount;
$save['actual_time_to_deliver'] = $result->actual_time_to_deliver;
$save['payment_method'] = $result->payment_method;
$save['associate'] = $result->associate;
$save['address_type'] = $result->address_type;
$save['address'] = $result->customer_name . ',' . $result->status . ',' . $result->city . ',' . $result->district . ',' . $result->province . ',' . $result->customer_phone;
$save[$campid] = $camp->id;
Order::create($save);
Session::flash('success', Lang::get('ruban.camp.updated'));
unset($save);
}
$timeline[$description] = Auth::user()->first_name . ' ' . Auth::user()->last_name . ' has imported the daily camp xls for <a href="javascript:;">' . $camp->title . '</a>';
$timeline[$object_type] = 5;
$timeline[$object_id] = $camp->id;
Timeline::create($timeline);
});
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$camp = Camp::findOrFail($id);
$camp->delete();
Session::flash($this->success, Lang::get('ruban.task.deleted'));
return Redirect::route('ruban.tasks.index');
}
