Customising Scaffold code

Question

Customising Scaffold code

Anish Aug '14

Created Aug '14	Last Reply Aug '14	Replies 2	Views 813	Votes 0

Anish 24.2k

Aug '14

<?php
$this->view->title = 'Search Customer ::';
        $numberPage = 1;
        if ($this->request->isPost()) 
        {
            $query = Criteria::fromInput($this->di, "Customer", $_POST);
            $this->persistent->parameters = $query->getParams();
        } 
        else 
        {
            $numberPage = $this->request->getQuery("page", "int");
        }

        $parameters = $this->persistent->parameters;
        $parameters["order"] = "cus_id";

        if (!is_array($parameters)) 
        {
            $parameters = array();
        }

        var_dump($query->getParams());

        $customer = Customer::find($parameters);

This is a slightly modified scaffold code to search. I want to add one more condition to the query. The above code will return result for the query

select from customer where name like '%foo%' I wanto to change the query into something like
select from customer where name like '%foo%' and user_name = 'user_name'

user_name can be get from session data

R van der Feer
5.5k

Accepted
answer

Aug '14

Ah I see; I didn't test this before. Seems to me this functionality is not quite working as it should.

This works for me but seems to miss the point of using the Criteria object in the first place;

<?php

        $criteria = Criteria::fromInput($this->di, 'Customer', $this->request->getPost());

        $params = $criteria->getParams();

        $result = $this->modelsManager
            ->createBuilder()
            ->from($criteria->getModelName())
            ->where($criteria->getConditions(), $params['bind'])
            ->addWhere('user_name = "user_name"')
            ->getQuery()
            ->execute()
        ;

Anish · Answer 1 · 2014-08-19T08:07:49-07:00

Anish
24.2k

Aug '14

Not possible to customise ?

R van der Feer · Answer 2 · 2014-08-26T08:15:55-07:00

I think this approach should work for you; https://forum.phalcon.io/discussion/457/work-with-criteria

Anish · Answer 3 · 2014-08-26T23:10:01-07:00

I tried the code from the link. As the last post says, I am also getting 'At least one model is required to build the query' error

Anish · Answer 4 · 2014-08-28T02:22:53-07:00

Thanks, now it's working. How to add more conditions. Just for knowing. Also there is a typo

addWhere('user_name = "user_name"')

Which is wrong

andWhere('user_name = "user_name"')

is the correct.