Data show using Jquery Ajax

[shovonbugs]

I'm trying to retrive data using jquery Ajax, Here is my code....

 

Problem is when I select value from drop down list the selected value posted successfully and I checked in browser console that the value is passing and show but cannot retrive in template file that I'm trying to get after query execute. Also I attached the browser console file.

 

Please help me someone...

 

Template File (content.tpl)

________________________

{literal}
<script>
  $("#monthID").change(function() {
      var showJsMonth = ($(this).val());
            $.ajax({
                type: 'POST',
                async: true,
                cache: false,
                data : {
                    ajax : true,
                    controller : 'AdminHome',
                    token : '{token}',
                    monthSM : showJsMonth,
                    action : 'showMonthresult'
                },
                url: 'ajax-tab.php',
                dataType : 'JSON',
                success: function(data) {
               
                      $(".showMonth").html(data[2].id_address); /* Not working */

                },
                error: function(data, textStatus, errorThrown)
                {
                    jAlert("TECHNICAL ERROR:");
                }
            });
  });
</script>
{/literal}

-----------------------------------------------------------------------------

Controller Page(AdminHomeController.php)

________________________________________________

public function ajaxProcessShowMonthresult()
    {  
    $smarty = $this->context->smarty;
    $monthSM=Tools::getValue('monthSM');
    $smarty->assign('showMonth', ObjectModel::getRefrigOrdersMonth($monthSM));

    }

________________________________________________

Model File(ObjectModel.php)

________________________________________________

public function getRefrigOrdersMonth($monthSM){
    $monthSMs =  pSQL($monthSM);
    $a1 = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS('
        SELECT '._DB_PREFIX_.'address.`id_address`,'._DB_PREFIX_.'address.`address1`, '._DB_PREFIX_.'address.`address2`, '._DB_PREFIX_.'address.`postcode`, '._DB_PREFIX_.'address.`city`, '._DB_PREFIX_.'orders.`id_customer`, '._DB_PREFIX_.'orders.`id_order`, '._DB_PREFIX_.'address.`company`, '._DB_PREFIX_.'customer.`firstname`, '._DB_PREFIX_.'customer.`lastname`, '._DB_PREFIX_.'order_detail.`product_quantity`, '._DB_PREFIX_.'order_detail.`product_name`, '._DB_PREFIX_.'manufacturer.`name` FROM `'._DB_PREFIX_.'orders`
                LEFT JOIN `'._DB_PREFIX_.'order_detail`
                ON `'._DB_PREFIX_.'orders`.id_order = `'._DB_PREFIX_.'order_detail`.id_order
                LEFT JOIN `'._DB_PREFIX_.'customer`
                ON `'._DB_PREFIX_.'customer`.id_customer = `'._DB_PREFIX_.'orders`.id_customer
                LEFT JOIN `'._DB_PREFIX_.'address`
                ON `'._DB_PREFIX_.'address`.id_customer = `'._DB_PREFIX_.'customer`.id_customer
                
                LEFT JOIN `'._DB_PREFIX_.'manufacturer`
                ON `'._DB_PREFIX_.'address`.address1 = `'._DB_PREFIX_.'manufacturer`.id_manufacturer
                
                WHERE `'._DB_PREFIX_.'order_detail`.product_name LIKE \'%'.$monthSMs.'%\'
                
                ORDER BY `'._DB_PREFIX_.'orders`.id_order
        
        ' );
            
        for ($z = 0; $z < count($a1); $z++){
        echo $firstname= $a1[$z][id_address];
        $result[] = array($firstname);    
        }
        return ($result);
}

 

--------------------------------------------------------------------------------------------

[vekia]

what you've got in data exactly?

looks like this: http://i.imgur.com/FPT12E3.png

 

so why use: data[2].id_address - it doesnt exist

[shovonbugs]

Now I'm getting datas but problem is how do I show multiples data in ajax template, please the attached file..

 

Here is my updated code

 

content.tpl

---------------------------------------------

{literal}
<script>
  $("#monthID").change(function() {
      var showJsMonth = ($(this).val());
            $.ajax({
                type: 'POST',
                async: true,
                cache: false,
                data : {
                    ajax : 1,
                    controller : 'AdminHome',
                    token : '{token}',
                    monthSM : showJsMonth,
                    action : 'showMonthresult'
                },
                url: 'ajax-tab.php',
                dataType : 'JSON',
                success: function(msg)
                        {
                            if (msg)
                            {
                                
                                var infos = msg.infos.split('_');
                                $('.showMonth').html(infos[0] + infos[1] + infos[2]);

                                
                            }
                            
                        },
                error: function(msg, textStatus, errorThrown)
                {
                    jAlert("TECHNICAL ERROR:");
                }
            });
  });
</script>
{/literal}

-------------------------

AdminhomeController.php

------------------------------------------

public function ajaxProcessShowMonthresult()
    {  

    if (Tools::getValue('monthSM'))
        {
            $monthSM = pSQL(Tools::getValue('monthSM'));
            $monthSMResult = ObjectModel::getRefrigOrdersMonth($monthSM);
            if (!empty($monthSMResult))
            {
                foreach($monthSMResult as $monthSMR){
                //$monthSMResult = $monthSMResult['0'];
                echo Tools::jsonEncode(array('infos' => pSQL($monthSMR['firstname']).'_'.pSQL($monthSMR['lastname']).'_'.pSQL($monthSMR['id_address'])));
                }
            }
        }
        die;
        
        
    }

------------------------------

ObjectModel.php

-----------------------------

public function getRefrigOrdersMonth($monthSM){
    $monthSMs =  pSQL($monthSM);
    $sql = '
        SELECT '._DB_PREFIX_.'address.`id_address`,'._DB_PREFIX_.'address.`address1`, '._DB_PREFIX_.'address.`address2`, '._DB_PREFIX_.'address.`postcode`, '._DB_PREFIX_.'address.`city`, '._DB_PREFIX_.'orders.`id_customer`, '._DB_PREFIX_.'orders.`id_order`, '._DB_PREFIX_.'address.`company`, '._DB_PREFIX_.'customer.`firstname`, '._DB_PREFIX_.'customer.`lastname`, '._DB_PREFIX_.'order_detail.`product_quantity`, '._DB_PREFIX_.'order_detail.`product_name`, '._DB_PREFIX_.'manufacturer.`name` FROM `'._DB_PREFIX_.'orders`
                LEFT JOIN `'._DB_PREFIX_.'order_detail`
                ON `'._DB_PREFIX_.'orders`.id_order = `'._DB_PREFIX_.'order_detail`.id_order
                LEFT JOIN `'._DB_PREFIX_.'customer`
                ON `'._DB_PREFIX_.'customer`.id_customer = `'._DB_PREFIX_.'orders`.id_customer
                LEFT JOIN `'._DB_PREFIX_.'address`
                ON `'._DB_PREFIX_.'address`.id_customer = `'._DB_PREFIX_.'customer`.id_customer
                
                LEFT JOIN `'._DB_PREFIX_.'manufacturer`
                ON `'._DB_PREFIX_.'address`.address1 = `'._DB_PREFIX_.'manufacturer`.id_manufacturer
                
                WHERE `'._DB_PREFIX_.'order_detail`.product_name LIKE \'%'.$monthSMs.'%\'
                
                ORDER BY `'._DB_PREFIX_.'orders`.id_order
        
        ';
            
return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);
}

------------------------------------------

Edited October 3, 2013 by shovonbugs (see edit history)

[vekia]

you've got technical error so it mean that you've got probably problem ajax query

you see this part:
 

error: function(msg, textStatus, errorThrown)
                {
                    jAlert("TECHNICAL ERROR:");
                }

it's weirdy mainly because you've got response and HTTP status 200 OK

 

there is no 404 etc. ?