в моем контроллере:
public function viewOrders() {
$territoryId = $this->input->post('tid');
$dateStart = $this->input->post('sdate');
$dateEnd = $this->input->post('edate');
$data = array(
'TERRITORY_ID' => $territoryId,
'ORDER_DATE' => $dateStart,
'EXP_COLL_DATE' => $dateEnd
);
$this->order->viewOrder($data);
}
в моей модели:
public function viewOrder($data) {
return $this->db->select('ORDER_ID,ORDER_DATE,EXP_COLL_DATE,STATUS')
->from('ORDER_HEADER')
->join('ORDER_DETAILS', 'ORDER_HEADER.TERRITORY_ID=ORDER_DETAILS.TERRITORY_ID', 'INNER')
->where($data);
}
в нижнем колонтитуле (просмотр):
function viewOrders() {
var dateStart = $('#dateStart').val();
var dateEnd = $('#dateEnd').val();
var territories = $('#territory').val();
$.post("/index.php/Orders/viewOrders", {tid: territories, sdate: dateStart, edate: dateEnd}).done(function (data) {
alert(data);
});
}
Подробнее здесь: https://stackoverflow.com/questions/465 ... and-jquery
