function postDownloads() { if ($this->access['is_excel'] == 0) { return Redirect::to('')->with('message', SiteHelpers::alert('error', Lang::get('core.note_restric'))); } $sort = !is_null(Input::get('sort')) ? Input::get('sort') : 'OrderID'; $order = !is_null(Input::get('order')) ? Input::get('order') : 'desc'; $data = DB::table('orders'); if ($_POST['OrderID'] != '') { $data->where('OrderID', "LIKE", "%" . $_POST['OrderID'] . "%"); } if ($_POST['name'] != '') { $data->where('name', "LIKE", "%" . $_POST['name'] . "%"); } if ($_POST['email'] != '') { $data->where('email', "LIKE", "%" . $_POST['email'] . "%"); } if ($_POST['phone'] != '') { $data->where('phone', "LIKE", "%" . $_POST['phone'] . "%"); } if ($_POST['address'] != '') { $data->where('address', "=", $_POST['address']); } if ($_POST['status'] != '') { $data->where('status', "LIKE", "%" . $_POST['status'] . "%"); } if ($_POST['provinceid'] != '') { $data->where('provinceid', "=", $_POST['provinceid']); } $data = $data->get(); $content = $this->data['pageTitle']; $content .= '<table border="1">'; $content .= '<tr>'; $content .= '<th style="background:#f9f9f9;">' . Lang::get('core.table_id') . '</th>'; $content .= '<th style="background:#f9f9f9;">' . Lang::get('core.table_name') . '</th>'; $content .= '<th style="background:#f9f9f9;">' . Lang::get('core.table_phone') . '</th>'; $content .= '<th style="background:#f9f9f9;">' . Lang::get('core.table_email') . '</th>'; $content .= '<th style="background:#f9f9f9;">' . Lang::get('core.sex') . '</th>'; $content .= '<th style="background:#f9f9f9;">' . Lang::get('core.table_city') . '</th>'; $content .= '<th style="background:#f9f9f9;">' . Lang::get('core.table_district') . '</th>'; $content .= '<th style="background:#f9f9f9;">' . Lang::get('core.table_ward') . '</th>'; $content .= '<th style="background:#f9f9f9;">' . Lang::get('core.table_date') . '</th>'; $content .= '</tr>'; foreach ($data as $item) { $content .= '<tr>'; $content .= '<td>' . $item->OrderID . '</td>'; $content .= '<td>' . $item->name . '</td>'; $content .= '<td>' . $item->phone . '</td>'; $content .= '<td>' . $item->email . '</td>'; $content .= '<td>' . SiteHelpers::getSex($item->sex) . '</td>'; $content .= '<td>' . SiteHelpers::getNameaddress($item->provinceid, 'province', "provinceid") . '</td>'; $content .= '<td>' . SiteHelpers::getNameaddress($item->districtid, 'district', "districtid") . '</td>'; $content .= '<td>' . SiteHelpers::getNameaddress($item->wardid, 'ward', "wardid") . '</td>'; $content .= '<td>' . $item->OrderDate . '</td>'; $content .= '</tr>'; } $content .= '</table>'; @header('Content-Type: application/ms-excel'); @header('Content-Length: ' . strlen($content)); @header('Content-disposition: inline; filename="' . $title . ' ' . date("d/m/Y") . '.xls"'); echo $content; exit; }