How to pass data from view to controller in cakephp?

Question

I have a view like that: enter image description here

What I want is when I click on the button, it will execute a select query:

SELECT discounts.product_id, products.product_name,
sum(products.product_price - discounts.product_discount) as total_Amount,
count(orders.order_id) as total_Number
FROM products 
inner join discounts on products.product_id = discounts.product_id
inner join orders on discounts.discount_id = orders.discount_id

where discounts.start_time >= **FromTextBox** and discounts.end_time <= **ToTextBox**

group by discounts.product_id,products.product_name

FromTextBox and ToTextBox are values from 2 textboxes.

This is in my controller:

....
$option['fields']= array('Discount.product_id','Product.product_name','benefit','number');
    //$option['conditions']=array('Discount.start_time >'=>array(''));  //where I put values from view
    $option['group'] = array('Discount.product_id','Product.product_name');
    $products = $this->Order->find('all',$option);
    $this->set('products',$products);

And my view:

<label class="control-label">From</label>
<div class="controls input-append date" id="dp1" data-date="" data-date-format="dd MM yyyy" data-link-field="dtp_input2" data-link-format="yyyy-mm-dd">
                <input size="16" type="text" value="" readonly>   <-- where I put textbox
                <span class="add-on"><i class="icon-remove"></i></span>
                <span class="add-on"><i class="icon-th"></i></span>
</div>
<label class="control-label">To</label>
<div class="controls input-append date" id="dp2" data-date="" data-date-format="dd MM yyyy" data-link-field="dtp_input2" data-link-format="yyyy-mm-dd">
                <input size="16" type="text" value="" readonly>   <-- where I put textbox
                <span class="add-on"><i class="icon-remove"></i></span>
                <span class="add-on"><i class="icon-th"></i></span>
</div>
 <div>
    <?php echo $this->Form->button('A Button'); ?>
</div>

Two textboxes are used Bootstrap datepicker. Please help me! thanks in advance.

nithin · Accepted Answer · 2013-12-02 07:03:58Z

2

You should use "Ajax" to send what is selected in "datepicker" to server, execute your query and use the result to create your table. There is no direct way in cakephp for your problem

answered Dec 2, 2013 at 7:03

nithin

4492 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tung Pham Over a year ago

thank you for your answer. is there any example for that? I am kind of new to cakephp.

nithin Over a year ago

I dont have a sample code for this. There is a jquery plugin "datatable". See the server side configuration and datefilter. I think your requirement is almost the same. datatables.net/examples/data_sources/server_side.html jquery-datatables-column-filter.googlecode.com/svn/trunk/….

Collectives™ on Stack Overflow

How to pass data from view to controller in cakephp?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related