php - How to pass data from model in a multidimensional array -


i want data of '$quantity' array without repeating before index values.in below code there repeating of before index values 

$sql="select      tou.retailer_code,tou.retailer_name, tso.added_date,tso.sales_order_code,tsohfi.id_sales_order          tbl_sales_order_has_free_item tsohfi     inner join      tbl_sales_order tso on     tsohfi.id_sales_order=tso.id_sales_order     inner join     tbl_outlet_has_route tohr on      tso.id_outlet_has_route=tohr.id_outlet_has_route     inner join     tbl_outlet tou on     tou.id_outlet=tohr.outlet_id     inner join     tbl_product tp on     tp.product_id=tsohfi.product_id     tso.status=1 {$root}{$sales_date}     group tsohfi.id_sales_order     ";     $free_sql = $this->db->mod_select($sql);   foreach($free_sql $value){        $sql2="select              product_id,qty                         tbl_sales_order_has_free_item             id_sales_order= $value->id_sales_order";       $quantity_sql=$this->db->mod_select($sql2);       foreach ($quantity_sql $row)     {          $quantity[] = array(                 'product_id' => $row->product_id,                 'quantity' => $row->qty               );              }                $item_array[]=array(             'retailer_code' => $value->retailer_code,             'retailer_name' => $value->retailer_name,             'added_date' => $value->added_date,             'sales_order_code'=>$value->sales_order_code,             'id_sales_order'=>$value->id_sales_order,             'quantity'=>$quantity                );                }        return $item_array;

output of repeating loop want [0] value 1st , 1 values 2nd , [2] values in 3rd etc


Comments

Post a Comment

Popular posts from this blog

javascript - Google App Script ContentService downloadAsFile not working -

i have web app developed using google app script htmlservice , html form, populating excel sheet in google drive using spreadsheetapp . , 1 section calling contentservice download data excel file. function doget(e) { // read excel sheet //getappfile(); // render application html template return htmlservice.createtemplatefromfile('index').evaluate() .settitle('go smart') .setsandboxmode(htmlservice.sandboxmode.iframe); } function downloaddoublequatecsvfile() { var sheetid = propertiesservice.getscriptproperties().getproperty('sheetid'); var ss = spreadsheetapp.openbyid(sheetid).getactivesheet(); //var ss = spreadsheetapp.getactivespreadsheet().getactivesheet(); var maxcolumn = ss.getlastcolumn(); var maxrow = ss.getlastrow(); var data = ss.getrange(1, 1, maxrow, maxcolumn).getvalues(); if (data.length > 1) { var csv = ""; (var row = 0; row < data.length; row++) { (var c...
Read more

javascript - Function overwritting -

is there way overwrite function or event handling in function? using addeventlistener, can have many event handlers on element want var test=document.getelementbyid("div"); test.addeventlistener("click",function(){alert("im first");},false); test.addeventlistener("click",function(){alert("im second");},false); // alerts "im first" , after "im second" but if want overwrite function/event example based on client width example this function one() { alert("first"); } function two() { alert("second"); } window.onresize = function() { var test = document.getelementbyid("div"); if (window.innerwidth > 500) { test.onclick = 1 } else { test.onclick = two; } } is possible in javascript? in case use effective little known approach. addeventlistener can accept object property handleevent event handler. in case it's easy overwr...
Read more

php - Find a regex to take part of Email -

i have following emails need extract part from: bestellnummer xxx: 1 von xxx, 1er pack ------------- anfang der nachricht ------------- foo bar baz foo bar baz // <<<<< need text here ------------- ende der nachricht ------------- ------------- anfang der nachricht ------------- foo bar baz foo bar baz ------------- ende der nachricht ------------- there 0 unlimited occurences of ------------- anfang der nachricht ------------- ------------- ende der nachricht ------------- and i'm able extract first part regex: $re = "/------------- .*? -------------.?(.*?).?------------- .*? -------------/s"; but, i'm quite new on learning regex, i'm pretty sure there must better regex extract part (foo bar baz foo bar baz) of text between ------------- anfang der nachricht ------------- ------------- ende der nachricht ------------- as can in different languages, i'm using .? to match between hyphens. i...
Read more