function index_get() { $filters = $this->get("filter")["filters"]; $page = $this->get('page') !== false ? $this->get('page') : 1; $limit = $this->get('limit') !== false ? $this->get('limit') : 100; $sort = $this->get("sort"); $data["results"] = array(); $data["count"] = 0; $obj = new Stock(null, $this->entity); //Sort if (!empty($sort) && isset($sort)) { foreach ($sort as $value) { $obj->order_by($value["field"], $value["dir"]); } } //Filter if (!empty($filters) && isset($filters)) { $deleted = 0; foreach ($filters as $value) { if (!empty($value["operator"]) && isset($value["operator"])) { if ($value["operator"] == "where_in") { $obj->where_in($value["field"], $value["value"]); } else { if ($value["operator"] == "or_where_in") { $obj->or_where_in($value["field"], $value["value"]); } else { if ($value["operator"] == "where_not_in") { $obj->where_not_in($value["field"], $value["value"]); } else { if ($value["operator"] == "or_where_not_in") { $obj->or_where_not_in($value["field"], $value["value"]); } else { if ($value["operator"] == "like") { $obj->like($value["field"], $value["value"]); } else { if ($value["operator"] == "or_like") { $obj->or_like($value["field"], $value["value"]); } else { if ($value["operator"] == "not_like") { $obj->not_like($value["field"], $value["value"]); } else { if ($value["operator"] == "or_not_like") { $obj->or_not_like($value["field"], $value["value"]); } else { if ($value["operator"] == "startswith") { $obj->like($value["field"], $value["value"], "after"); } else { if ($value["operator"] == "endswith") { $obj->like($value["field"], $value["value"], "before"); } else { if ($value["operator"] == "contains") { $obj->like($value["field"], $value["value"], "both"); } else { if ($value["operator"] == "or_where") { $obj->or_where($value["field"], $value["value"]); } else { if ($value["operator"] == "by_category") { $obj->where_related("product", $value["field"], $value["value"]); } else { $obj->where($value["field"] . ' ' . $value["operator"], $value["value"]); } } } } } } } } } } } } } } else { if ($value["field"] == "deleted") { $deleted = $value["value"]; } else { $obj->where($value["field"], $value["value"]); } } } $obj->where("deleted", $deleted); } //Results $obj->get_paged_iterated($page, $limit); $data["count"] = $obj->paged->total_rows; if ($obj->result_count() > 0) { foreach ($obj as $value) { //Fullname $c = new Contact(null, $this->entity); $c = $value->contact->get(); $fullname = $c->surname . ' ' . $c->name; if ($c->contact_type_id == 3 || $c->contact_type_id == 5) { $fullname = $c->company; } $data["results"][] = array("id" => $value->id, "currency_id" => $value->currency_id, "bill_id" => $value->bill_id, "contact_id" => $value->contact_id, "product_id" => $value->product_id, "unit_id" => $value->unit_id, "quantity" => floatval($value->quantity), "price" => floatval($value->price), "issued_date" => $value->issued_date, "deleted" => $value->deleted, "currency" => $value->currency->get_raw()->result(), "bill" => $value->bill->get_raw()->result(), "fullname" => $fullname, "product" => $value->product->get_raw()->result(), "unit" => $value->unit->get()->name); } } //Response Data $this->response($data, 200); }