ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / centosnipponia / public_html / apptt-oldgit / app / Http / Controllers

<?php

namespace App\Http\Controllers;
use Carbon\Carbon;
use Illuminate\Http\Request;
use Ripcord\Ripcord;
use PhpXmlRpc\Client;
use Illuminate\Support\Facades\DB;
use App\Services\Odoocall;
class OdooController extends Controller
{
 //production
    //const URL ='https://alpiek-oisterwijk-traden-and-traffic-modules.odoo.com';
    //const DB ='alpiek-oisterwijk-traden-and-traffic-modules-13-0-874478';
//production

//test
    //const URL ="https://testodoo.trade-traffic.com"; 
    //const DB = "alpiek-oisterwijk-traden-and-traffic-modules-13-0-te-1303822";
    //test

//functions used in this controler
   //..........................................................................
   function searchmodelname($ftable, $modelname) {
    $size = count($ftable);
    $thesi = -1;
    for($i = 0; $i < $size; $i++)
            {
                if ($ftable[$i]["name"]==$modelname) :
                    $thesi = $i;
                    break;
                endif;
            }
    return $thesi;
    }
    //..........................................................................

public function fetch_product_image(){

$model = 'product.template';
        //$query_arguments=array('&','&','&','&','&','&','&','&',	array('product_tmpl_id.categ_id','ilike', 'Motorcycles'), array('tracking', '=', 'serial'),array(['location_id'][0],'!=',15),array(['location_id'][0],'!=',762),array(['location_id'][0],'!=',13),array(['location_id'][0],'!=',16),array(['location_id'][0],'!=',2013),array(['location_id'][0],'!=',5),array(['location_id'][0],'!=',4),array(['location_id'][0],'!=',14)); // Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
        $query_arguments=array(	array('default_code','=', 'F3_F03')); // Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
    
        
        //$limitations=array('fields'=>array('location_id','product_id','inventory_quantity','quantity','reserved_quantity','product_tmpl_id','x_product_category')) ;
        $call=new Odoocall();
        $uii=$call->Odooquery($model,$query_arguments );

foreach($uii as $result)
        {

$imagetoshow=$result['image_1920'];
            $file_path=$this->generateImage($imagetoshow);
        }

//echo base64_decode($imagetoshow);
      
        
       //dd( $imagetoshow);
 //$this->generateImage($imagetoshow);
 return view('fetch_product_image')->with('file_path',$file_path);

}

public function generateImage($img)
    {

$folderPath = "temp/";

$image_base64 = base64_decode($img);
        $file = $folderPath . uniqid() . '.png';

file_put_contents($file, $image_base64);
return  $file;
    }

public function fetch_current_stock()
        {
            $this->update_vin_stock_table();
            $model = 'stock.quant';
            //$query_arguments=array('&','&','&','&','&','&','&','&',	array('product_tmpl_id.categ_id','ilike', 'Motorcycles'), array('tracking', '=', 'serial'),array(['location_id'][0],'!=',15),array(['location_id'][0],'!=',762),array(['location_id'][0],'!=',13),array(['location_id'][0],'!=',16),array(['location_id'][0],'!=',2013),array(['location_id'][0],'!=',5),array(['location_id'][0],'!=',4),array(['location_id'][0],'!=',14)); // Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
            $query_arguments=array('&','&','&','&','&','&','&','&','&','&','&',
            array('product_tmpl_id.categ_id','ilike', 'Motorcycles'),
            array('quantity','>', 0),
            array('product_tmpl_id.categ_id','not like', 'Samples'),
            array('tracking', '=', 'serial'),
            array(['location_id'][0],'!=',15),
            array(['location_id'][0],'!=',762),
            array(['location_id'][0],'!=',13),
            array(['location_id'][0],'!=',16),
            array(['location_id'][0],'!=',2013),
            array(['location_id'][0],'!=',5),
            array(['location_id'][0],'!=',14),
            array(['location_id'][0],'!=',2975)); // Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
            $limitations=array('fields'=>array('location_id','product_id','inventory_quantity','quantity','reserved_quantity','product_tmpl_id','x_product_category','x_list_price')) ;
            $call=new Odoocall();
            $uii=$call->Odooquery($model,$query_arguments ,$limitations);
//print_r($uii);
            //$uii=$call->Odooquery($model,$query_arguments);
            //15->Production
            //2075 -> Mol
            //2076 ->Mol Input (sthn ousia einai pali Partner Locations/Customers/Input)
            //1975->WH/Trade & Traffic Plus BV/Heerde
            //8-> WH/Trade & Traffic Plus BV
            //9-> Partner Locations/Customers/Input
            //4-> "Partner Locations/Vendors" 
            //5->Partner Locations/Customers poulimeno
            //13->"Physical Locations/Trade & Traffic Plus BV: Transit Location"
            //14->"Virtual Locations/Trade & Traffic Plus BV: Inventory adjustment"
            //762->Virtual Locations/Trade and Traffic Plus BV: Missing
            //2013->Virtual Locations/Trade and Traffic Plus BV: Disassembled
            //16->Virtual Locations/Trade & Traffic Plus BV: Scrap
            //2960 ->Requested
             // 2975->Virtual Locations/Trade and Traffic Plus BV: No Battery

//print_r($uii);

//dd( $uii);

$modelcount = array();
            foreach($uii as $result)
           {

$category_full_name=$result['x_product_category'][1];
            $category_id=$result['x_product_category'][0];
            $category_name_potition=strrpos($category_full_name," / ")+3;
            $category_name=substr($category_full_name,$category_name_potition);

$modelochk=$result['product_tmpl_id'][1];
               $chkthesi=$this->searchmodelname($modelcount,$modelochk); //allivs tha epsaxne na brei mia global synarthsh
               $currentlocation=$result['location_id'][0];
               $reserved_v=$result['reserved_quantity'];
               $id=$result['product_tmpl_id'][0];//$result['product_id'][0];
               $list_price=$result['x_list_price'];
           if ($reserved_v==0):
                   if ($chkthesi==-1):
                           if($currentlocation==8 or $currentlocation==2075 or $currentlocation==1975):
                               $pushtobe=['name'=>$modelochk, 'list_price'=>$list_price, 'WH'=> 1,'soon'=> 0, 'nonWH'=> 0, 'reserv'=> 0, 'id'=>$id, 'cat_id'=> $category_id, 'cat_name'=> $category_name];
                               array_push($modelcount, $pushtobe);
                           elseif($currentlocation==9):
                               $pushtobe=['name'=>$modelochk, 'list_price'=>$list_price, 'WH'=> 0, 'soon'=> 1, 'nonWH'=> 0, 'reserv'=> 0, 'id'=>$id,  'cat_id'=> $category_id, 'cat_name'=> $category_name];	
                               array_push($modelcount, $pushtobe);
                           elseif($currentlocation!=4 and $currentlocation!=5 and $currentlocation!=14 and $currentlocation!=762 and $currentlocation!=13):
                               $pushtobe=['name'=>$modelochk, 'list_price'=>$list_price, 'WH'=> 0,'soon'=> 0, 'nonWH'=> 1, 'reserv'=> 0, 'id'=>$id,  'cat_id'=> $category_id, 'cat_name'=> $category_name];
                               array_push($modelcount, $pushtobe);
                           endif;
                           
                   else:
                           if($currentlocation==8 or $currentlocation==2075 or $currentlocation==1975):
                               $modelcount[$chkthesi]["WH"]++;
                       elseif($currentlocation==9 or $currentlocation==2076):
                               $modelcount[$chkthesi]["soon"]++;
                           elseif($currentlocation!=4 and $currentlocation!=5 and $currentlocation!=14 and $currentlocation!=762 and $currentlocation!=13):
                               $modelcount[$chkthesi]["nonWH"]++;
                           endif;
                   endif;
           endif;
           
           if ($reserved_v!=0):
                   if ($chkthesi==-1):
                           if($currentlocation==8 ):
                               $pushtobe=['name'=>$modelochk, 'list_price'=>$list_price, 'WH'=> 0,'soon'=> 0, 'nonWH'=> 0, 'reserv'=> 1, 'id'=>$id,  'cat_id'=> $category_id, 'cat_name'=> $category_name];
                               array_push($modelcount, $pushtobe);
                           elseif($currentlocation==9 or $currentlocation==2076):
                               $pushtobe=['name'=>$modelochk, 'list_price'=>$list_price, 'WH'=> 0, 'soon'=> 1, 'nonWH'=> 0, 'reserv'=> 0, 'id'=>$id,  'cat_id'=> $category_id, 'cat_name'=> $category_name];	
                               array_push($modelcount, $pushtobe);
                           elseif($currentlocation!=4 and $currentlocation!=5 and $currentlocation!=14 and $currentlocation!=762 and $currentlocation!=13):
                               $pushtobe=['name'=>$modelochk, 'list_price'=>$list_price, 'WH'=> 0,'soon'=> 0, 'nonWH'=> 0, 'reserv'=> 1, 'id'=>$id,  'cat_id'=> $category_id, 'cat_name'=> $category_name];
                               array_push($modelcount, $pushtobe);
                           endif;
                           
                   else:
           
                               
           
                       if($currentlocation==9 or $currentlocation==2076):
                               $modelcount[$chkthesi]["soon"]++;
                           else:
                               //$modelcount[$chkthesi]["reserv"]++;
                           endif;
                    endif;
           endif;
             }
//dd($modelcount);
//change array to category friendly array
             $modelcountnew = array();
             foreach($modelcount as $model2){

if(isset($modelcountnew[$model2['cat_id']])){

$modelcountnew[$model2['cat_id']]['WH']+=$model2['WH'];
                    $modelcountnew[$model2['cat_id']]['nonWH']+=$model2['nonWH'];
                    //$modelcountnew[$model2['cat_id']]['reserv']+=$model2['reserv'];
                    $modelcountnew[$model2['cat_id']]['soon']+=$model2['soon'];
                    $modelcountnew[$model2['cat_id']]['id']=$modelcountnew[$model2['cat_id']]['id'].'*'.$model2['id'];
                }
                else
                {$modelcountnew[$model2['cat_id']]['category_name']=$model2['cat_name'];
                    $modelcountnew[$model2['cat_id']]['WH']=$model2['WH'];
                    $modelcountnew[$model2['cat_id']]['nonWH']=$model2['nonWH'];
                    $modelcountnew[$model2['cat_id']]['reserv']=0;
                    $modelcountnew[$model2['cat_id']]['demands']=0;
                    $modelcountnew[$model2['cat_id']]['soon']=$model2['soon'];
                    $modelcountnew[$model2['cat_id']]['id']=$model2['id'];
                    $modelcountnew[$model2['cat_id']]['cat_id']=$model2['cat_id'];
                    $modelcountnew[$model2['cat_id']]['origind']="";
                    $modelcountnew[$model2['cat_id']]['originr']="";
                    $modelcountnew[$model2['cat_id']]['list_price']=$model2['list_price'];

}

//dd($modelcountnew);

//change array to category friendly array
//who demands what call
$model = 'stock.move';
$query_arguments=array('&' ,'&' , array('state', '=', 'confirmed'),array('product_tmpl_id.tracking','=','serial'),array('product_tmpl_id.categ_id','not like', 'Samples'),array('origin','!=', false));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
$limitations=array('fields'=>array('product_uom_qty','x_product_category','origin'));
$call=new Odoocall();
$uii=$call->Odooquery($model,$query_arguments);
//print_r($uii);
//dd("9");
foreach($uii as $result){
    $category_full_name=$result['x_product_category'][1];
    $category_id=$result['x_product_category'][0];
    $category_name_potition=strrpos($category_full_name," / ")+3;
    $category_name=substr($category_full_name,$category_name_potition);

if(isset($modelcountnew[$category_id])){

$modelcountnew[$category_id]['demands']+=$result['product_uom_qty'];
        $modelcountnew[$category_id]['origind']=$modelcountnew[$category_id]['origind'].$result['origin'].",";
    }
    else
    {
        $modelcountnew[$category_id]['category_name']= $category_name;
        $modelcountnew[$category_id]['reserv']=0;
        $modelcountnew[$category_id]['demands']=$result['product_uom_qty'];
        $modelcountnew[$category_id]['cat_id']=$category_id;
        $modelcountnew[$category_id]['WH']=0;
        $modelcountnew[$category_id]['nonWH']=0;
        $modelcountnew[$category_id]['soon']=0;
        $modelcountnew[$category_id]['origind']="";
        $modelcountnew[$category_id]['originr']="";
          }

}

//who demands what call

//who reserves what call
$model = 'stock.move';
//$query_arguments=array('&' ,'&' ,array('picking_code','=','outgoing'), array('state','in',array('assigned','partially_available')),array('product_tmpl_id.tracking','=','serial'));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ]         
$query_arguments=array('&' ,'&','&' ,array('picking_code','=','outgoing'), array('state','in',array('assigned','partially_available')) ,array('product_tmpl_id.tracking','=','serial'),array('product_tmpl_id.categ_id','not like', 'Samples'),array('origin','!=', false));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
$limitations=array('fields'=>array('product_uom_qty','x_product_category','origin'));
$call=new Odoocall();
$uii=$call->Odooquery($model,$query_arguments,$limitations);

foreach($uii as $result){
    $category_full_name=$result['x_product_category'][1];
    $category_id=$result['x_product_category'][0];
    $category_name_potition=strrpos($category_full_name," / ")+3;
    $category_name=substr($category_full_name,$category_name_potition);

if(isset($modelcountnew[$category_id])){

$modelcountnew[$category_id]['reserv']+=$result['product_uom_qty'];
        $modelcountnew[$category_id]['originr']=$modelcountnew[$category_id]['originr'].$result['origin'].",";
    }
    else
    {
        $modelcountnew[$category_id]['category_name']= $category_name;
        $modelcountnew[$category_id]['reserv']=$result['product_uom_qty'];
        $modelcountnew[$category_id]['demands']=0;
        $modelcountnew[$category_id]['cat_id']=$category_id;
        $modelcountnew[$category_id]['WH']=0;
        $modelcountnew[$category_id]['nonWH']=0;
        $modelcountnew[$category_id]['soon']=0;
        $modelcountnew[$category_id]['origind']="";
        $modelcountnew[$category_id]['originr']="";
        $modelcountnew[$category_id]['reserv']=0;

}

//who reserves what call
     
            //return view('current_stock')->with('current_stock', $modelcount);

//cost
            //$cost_per_cat_etc=DB::select(DB::raw('SELECT cat_id, sum(cost) as cost2 FROM costpervins WHERE in_stock=1 group by cat_id;'));//DB::table('snelstart_inv_clients')->groupBy('dealerid');
            $cost_per_cat_etc=DB::select(DB::raw('SELECT costpervins.cat_id as cat_id2, sum(cost) as cost2, COUNT(CASE WHEN costpervins.cost = 0 THEN 1 END) as nocostcount FROM vins_in_stocks RIGHT JOIN costpervins on vins_in_stocks.vin=costpervins.vin GROUP BY costpervins.cat_id;'));//DB::table('snelstart_inv_clients')->groupBy('dealerid');
            
            foreach ($cost_per_cat_etc as $value) {
            $cost_per_cat[$value->cat_id2]['cost'] = $value->cost2;
            $cost_per_cat[$value->cat_id2]['nocostcount'] = $value->nocostcount;
            }
//cost

return view('current_stock')->with('modelcount',$modelcountnew)->with('uii', $uii)->with('cost_per_cat', $cost_per_cat);
        }
    
 //..........................................................................

public function fetch_current_stock_model(Request $request){
           
                $catid = intval($request->catid);
                $model = 'stock.quant';
                //  $query_arguments=array('&','&','&','&','&','&','&','&',array('location_id.usage','=','internal'),array('create_date','>=',$datemin),array('create_date','<=',$datemax),array(['location_id'][0],'!=',2075),array(['location_id'][0],'!=',2076),array(['location_id'][0],'!=',1975),array(['location_id'][0],'!=',8),array(['location_id'][0],'!=',9),array(['product_tmpl_id'][0],'=',$modelid),array('lot_id','!=',False));            
                $limitations=array('fields'=>array('product_tmpl_id','display_name','lot_id','location_id'));  // Array of wanted fields True, False   
                // $query_arguments=array('&','&','&',array(['product_tmpl_id'][0],'=',$modelid),array('tracking', '=', 'serial'),array(['location_id'][0],'!=',5),array(['location_id'][0],'!=',4),array(['location_id'][0],'!=',14)); // Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
                //$query_arguments=array('&','&','&','&','&','&','&','&',array(['x_product_category'][0],'=',$catid),array(['location_id'][0],'!=',15),array('tracking', '=', 'serial'),array(['location_id'][0],'!=',13),array(['location_id'][0],'!=',762),array(['location_id'][0],'!=',16),array(['location_id'][0],'!=',2013),array(['location_id'][0],'!=',5),array(['location_id'][0],'!=',4),array(['location_id'][0],'!=',14)); // Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ]    
                $query_arguments=array('&','&','&','&','&','&','&','&','&','&','&','&',
                array(['x_product_category'][0],'=',$catid),
                array('reserved_quantity','!=',1),
                array(['location_id'][0],'!=',15),
                array('tracking', '=', 'serial'),
                array(['location_id'][0],'!=',13),
                array(['location_id'][0],'!=',762),
                array(['location_id'][0],'!=',16),
                array(['location_id'][0],'!=',2013),
                array(['location_id'][0],'!=',5),
                array(['location_id'][0],'!=',4),
                array(['location_id'][0],'!=',9),
                array(['location_id'][0],'!=',2975),
                array(['location_id'][0],'!=',14));
               
                
               
                $call=new Odoocall();

$uii=$call->Odooquery($model,$query_arguments ,$limitations);
                //$uii=$call->Odooquery($model,$query_arguments);
                
                $vin_cost_etc=DB::select(DB::raw('select VIN,cost,po from costpervins where cat_id="'.$catid.'";'));//DB::table('snelstart_inv_clients')->groupBy('dealerid');
                foreach ($vin_cost_etc as $value) {
                    $vin_cost[$value->VIN]['cost'] = $value->cost;
                    $vin_cost[$value->VIN]['po'] = $value->po;
                }
                //dd($vin_cost);

//dd($vin_cost);
               // print_r($uii);
        return view('current_stock_model')->with('model_list',$uii)->with('vin_cost',$vin_cost);

}

public function fetch_delivery_ready(){
            //connection strings
            $url = Config('configva.odoo.production_url');//einai ston config folder
            $db = Config('configva.odoo.production_db');//einai ston config folder
            $username = Config('configva.odoo.user');//einai ston config folder
            $password = Config('configva.odoo.pass');//einai ston config folder
            //connection strings
            $common = Ripcord::client("$url/xmlrpc/2/common");
            $uid = $common->authenticate($db, $username, $password, array());
            $models = Ripcord::client("$url/xmlrpc/2/object");
            $query_arguments=array(array('invoice_status', '=', 'to invoice'));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
            //$limitations=array('fields'=>array('in_date','lot_id','location_id','tracking','inventory_quantity','quantity','reserved_quantity','product_id','product_uom_id','display_name','create_uid','product_tmpl_id')) ;
            $uii=$models->execute_kw($db, $uid, $password, 'sale.order', 'search_read', array($query_arguments));//telos execute_kw
            return view('delivery_ready')->with('uii',$uii);

}

public function fetch_dealer_list(){

$url = Config('configva.odoo.production_url');//einai ston config folder
            $db = Config('configva.odoo.production_db');//einai ston config folder
            $username = Config('configva.odoo.user');//einai ston config folder
            $password = Config('configva.odoo.pass');//einai ston config folder
            //connection strings
            $common = Ripcord::client("$url/xmlrpc/2/common");
            $uid = $common->authenticate($db, $username, $password, array());
            $models = Ripcord::client("$url/xmlrpc/2/object");
            $query_arguments=array('&', array('customer_rank', '>', 0), array('is_company', '=', True));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
            //$limitations=array('fields'=>array('in_date','lot_id','location_id','tracking','inventory_quantity','quantity','reserved_quantity','product_id','product_uom_id','display_name','create_uid','product_tmpl_id')) ;
            $limitations=array('fields'=>array( 'display_name','id','total_due','total_invoiced','sale_order_count','purchase_order_count'));  // Array of wanted fields True, False   
            $uii=$models->execute_kw($db, $uid, $password, 'res.partner', 'search_read', array($query_arguments),$limitations);//telos execute_kw
            $totalvaluesnl=DB::select(DB::raw('select dealerid,sum(invoicevalue) as invoicevalue_total from snelstart_inv_clients group by dealerid;'));//DB::table('snelstart_inv_clients')->groupBy('dealerid');
           //dd($totalvaluesnl);//->where('dealerid','=',$dealerid)->sum('invoicevalue');

$totalvaluesnl=$this->make_raw_db_result_array($totalvaluesnl);
            //dd($totalvaluesnl);
            return view('dealer_list')->with('uii',$uii)->with('totalvaluesnl',$totalvaluesnl);

}

public function fetch_bulk_dealer_mail_list(){

$url = Config('configva.odoo.production_url');//einai ston config folder
            $db = Config('configva.odoo.production_db');//einai ston config folder
            $username = Config('configva.odoo.user');//einai ston config folder
            $password = Config('configva.odoo.pass');//einai ston config folder
            //connection strings
            $common = Ripcord::client("$url/xmlrpc/2/common");
            $uid = $common->authenticate($db, $username, $password, array());
            $models = Ripcord::client("$url/xmlrpc/2/object");
            //$query_arguments=array(array('name', '!=', ''));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
            //$limitations=array('fields'=>array('in_date','lot_id','location_id','tracking','inventory_quantity','quantity','reserved_quantity','product_id','product_uom_id','display_name','create_uid','product_tmpl_id')) ;
            $limitations=array('fields'=>array( 'lot_stock_id','x_mail'));  // Array of wanted fields True, False   
            //$uii=$models->execute_kw($db, $uid, $password, 'stock.warehouse', 'search_read', array($query_arguments),$limitations);//telos execute_kw
            $uii=$models->execute_kw($db, $uid, $password, 'stock.warehouse', 'search_read', array(),$limitations);//telos execute_kw
            $txt_to_copy="";

$locations_with_consignements=$this->consignments();

//dd($locations_with_consignements);
            foreach ($uii as $result) {
                if(array_search($result['lot_stock_id'][1], $locations_with_consignements)){
                if (str_contains($result['x_mail'], "@") & !str_contains($result['x_mail'], "molcargo") & !str_contains($result['x_mail'], "trade-traffic")) {
                    $txt_to_copy.=$result['x_mail'].';';
                }
            }
            }

$txt_to_copy=str_replace(" ","",$txt_to_copy);

//dd( $txt_to_copy);

//dd($txt_to_copy);

return view('bulk_contact')->with('txt_to_copy',$txt_to_copy);

}

public function consignments()//epistrefei mia lista me ta locations poy yparxoyn consignements
{

$consignment_locations=array();
$i=0;

foreach ($consignment_list as $result) {
            $consignment_locations[$i]=$result['location_id'][1];
            $i=$i+1;
        }

return  array_unique($consignment_locations);
    
}

public function revenue_target(Request $request){
            $year=intval($request->year);
            //$year='2021';
            $initdate = Carbon::createFromFormat('Y-m-d', $year.'-01-01');
      
            $url = Config('configva.odoo.production_url');//einai ston config folder
            $db = Config('configva.odoo.production_db');//einai ston config folder
            $username = Config('configva.odoo.user');//einai ston config folder
            $password = Config('configva.odoo.pass');//einai ston config folder
            //connection strings
            $common = Ripcord::client("$url/xmlrpc/2/common");
            $uid = $common->authenticate($db, $username, $password, array());
            $models = Ripcord::client("$url/xmlrpc/2/object");

$datefrom =  $initdate->format('Y-m-d');
            $dateto =  $initdate->addYear(1)->format('Y-m-d');

$query_arguments=array('&', '&', '|',array('type', '=', 'out_invoice'),array('type', '=', 'out_refund'), array('invoice_date','>=',$datefrom), array('invoice_date','<',$dateto));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
            $limitations=array('fields'=>array( 'amount_untaxed_signed','invoice_date'));  // Array of wanted fields True, False   
            $uii=$models->execute_kw($db, $uid, $password, 'account.move', 'search_read', array($query_arguments),$limitations);//telos execute_kw
      
            $total=0;
            $totalpermonth[1]=0;
            $totalpermonth[2]=0;
            $totalpermonth[3]=0;
            $totalpermonth[4]=0;
            $totalpermonth[5]=0;
            $totalpermonth[6]=0;
            $totalpermonth[7]=0;
            $totalpermonth[8]=0;
            $totalpermonth[9]=0;
            $totalpermonth[10]=0;
            $totalpermonth[11]=0;
            $totalpermonth[12]=0;

$totalrevenueall=0;

foreach ($uii as $ammount) {
$invoicedmonth=Carbon::createFromFormat('Y-m-d', $ammount['invoice_date'])->month;
$total=$ammount['amount_untaxed_signed'];
$totalrevenueall+=$total;

switch ($invoicedmonth) {
                        case 1:
                            $totalpermonth[1]+=$total; 
                         break;
                         case 2:
                            $totalpermonth[2]+=$total; 
                         break;
                         case 3:
                             $totalpermonth[3]+=$total; 
                         break;
                         case 4:
                            $totalpermonth[4]+=$total; 
                         break;
                         case 5:
                            $totalpermonth[5]+=$total; 
                         break;
                         case 6:
                             $totalpermonth[6]+=$total; 
                         break;                   
                         case 7:
                            $totalpermonth[7]+=$total; 
                         break;
                         case 8:
                            $totalpermonth[8]+=$total; 
                         break;
                         case 9:
                             $totalpermonth[9]+=$total; 
                         break;
                         case 10:
                            $totalpermonth[10]+=$total; 
                         break;
                         case 11:
                            $totalpermonth[11]+=$total; 
                         break;
                         case 12:
                             $totalpermonth[12]+=$total; 
                         break;                      
                            }
                }

$revenue= $totalpermonth;

$totaltarget=DB::table('sale_target')->where('year','=',$year)->get()->toArray();

$total=0;
$totalpermonthtarget[1]=0;
$totalpermonthtarget[2]=0;
$totalpermonthtarget[3]=0;
$totalpermonthtarget[4]=0;
$totalpermonthtarget[5]=0;
$totalpermonthtarget[6]=0;
$totalpermonthtarget[7]=0;
$totalpermonthtarget[8]=0;
$totalpermonthtarget[9]=0;
$totalpermonthtarget[10]=0;
$totalpermonthtarget[11]=0;
$totalpermonthtarget[12]=0;

$totaltargetall=0;
foreach ($totaltarget as $targetammount) {
    $total=$targetammount->sale_euro;
    $totaltargetall+=$total;
 
    
                        switch ( intval($targetammount->month)) {
                            case 1:
                                $totalpermonthtarget[1]+=$total; 
                             break;
                             case 2:
                                $totalpermonthtarget[2]+=$total; 
                             break;
                             case 3:
                                 $totalpermonthtarget[3]+=$total; 
                             break;
                             case 4:
                                $totalpermonthtarget[4]+=$total; 
                             break;
                             case 5:
                                $totalpermonthtarget[5]+=$total; 
                             break;
                             case 6:
                                 $totalpermonthtarget[6]+=$total; 
                             break;                   
                             case 7:
                                $totalpermonthtarget[7]+=$total; 
                             break;
                             case 8:
                                $totalpermonthtarget[8]+=$total; 
                             break;
                             case 9:
                                 $totalpermonthtarget[9]+=$total; 
                             break;
                             case 10:
                                $totalpermonthtarget[10]+=$total; 
                             break;
                             case 11:
                                $totalpermonthtarget[11]+=$total; 
                             break;
                             case 12:
                                 $totalpermonthtarget[12]+=$total; 
                             break;                      
                                }
                    }

for ($i = 1; $i <= 12; $i++){

if(count($totalpermonthtarget)>=$i and count($totalpermonth)>=$i and $totalpermonthtarget[$i]==0){
    $percentage[$i]= 0;
    }else
    {
        $percentage[$i]= 100*($totalpermonth[$i]-$totalpermonthtarget[$i])/$totalpermonthtarget[$i];

}
}

return view('revenue_target')->with('revenue', $revenue)->with('totaltargetall', $totaltargetall)->with('totalrevenueall', $totalrevenueall)->with('selected_year', $year)->with('totalpermonthtarget', $totalpermonthtarget)->with('percentage', $percentage);
            
        }

public function units_target(Request $request){
            $year=intval($request->year);
            $month=intval($request->month);
            //$year='2021';

$initdate =  $month!=0?Carbon::createFromFormat('Y-m-d', $year.'-'.$month.'-01'):Carbon::createFromFormat('Y-m-d', $year.'-01-01');
     // dd($initdate);
            $url = Config('configva.odoo.production_url');//einai ston config folder
            $db = Config('configva.odoo.production_db');//einai ston config folder
            $username = Config('configva.odoo.user');//einai ston config folder
            $password = Config('configva.odoo.pass');//einai ston config folder
            //connection strings
            $common = Ripcord::client("$url/xmlrpc/2/common");
            $uid = $common->authenticate($db, $username, $password, array());
            $models = Ripcord::client("$url/xmlrpc/2/object");

$datefrom =  $initdate->format('Y-m-d');
            $dateto = $month!=0? $initdate->addMonth(1)->format('Y-m-d'):$initdate->addYear(1)->format('Y-m-d');
            //dd($dateto);
          
            //$query_arguments=array( '&','&','&',array('invoice_status', '!=', 'no'),array('categ_id', 'ilike', 'Motorcycles'),array('date', '>=', $datefrom),array('date', '<', $dateto));// etsi itan prin to thema me ta diva poy kai thn meriki paradosh mias megalis paraggelias
            $query_arguments=array( '&','&','&',array('categ_id', 'ilike', 'Motorcycles'),array('date', '>=', $datefrom),array('date', '<', $dateto),array('state', '!=', 'cancel'));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
      
            //$query_arguments=array( '&',array('categ_id', 'ilike', 'Motorcycles'),array(['product_tmpl_id'][0], '=', 99));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
     
            $limitations=array('fields'=>array( 'product_tmpl_id','invoice_status','name','product_uom_qty','qty_invoiced','qty_delivered','name','categ_id','date','untaxed_amount_invoiced'));  // Array of wanted fields True, False   
            $uii=$models->execute_kw($db, $uid, $password, 'sale.report', 'search_read', array($query_arguments),$limitations);//telos execute_kw

//dd($uii);

/*   ******Gia na emfanisei pinaka me categories kai id******

377 => "F3"
373 => "e-Legance"
395 => "iLark"
374 => "Cit-e"
397 => "iTank"
372 => "e-Rex"
352 => "Volty"
399 => "Tremor"
392 => "2Fast"
375 => "Drag-e"
388 => "E3"
396 => "iTango"
393 => "Pride"
378 => "F7"
376 => "e-Viball"
394 => "Trimo"
384 => "Diva"

$model_table=array();
     foreach($uii as $result){
        $category_full_name=$result['categ_id'][1];
        $category_id=$result['categ_id'][0];
        $category_name_potition=strrpos($category_full_name," / ")+3;
        $category_name=substr($category_full_name,$category_name_potition);
        $model_table[$category_id]=$category_name;

}

dd(array_unique($model_table));
           
*/

$target_sales = DB::table('sales_unit_target') //pinakas me antistoixisi bi me odoo id edo den ginetai na ginei merge me ta targets
            ->where('month', '=', $month )
            ->where('year', '=', $year )
            ->get()->toArray();

$sales_odoo_models_id=array();

//dd($target_sales);

//print_r($uii);

foreach($uii as $result)
{
    $category_full_name=$result['categ_id'][1];
    $category_id=$result['categ_id'][0];
    $category_name_potition=strrpos($category_full_name," / ")+3;
    $category_name=substr($category_full_name,$category_name_potition);

//$modeltmplid= $result['product_tmpl_id'][0];
    // $modeltmplname= $result['product_tmpl_id'][1];
    //if($modeltmplid==""){echo 'keno';}
    //dd($this->search_object($bi_odoo_prod_binds, 'odoo_id', $modeltmplid));
   
    $categ_id1=$this->search_multidim($sales_odoo_models_id,'categ_id', $category_id);
   //echo  $categ_id1.'<br>';
    if ($categ_id1!=false or $categ_id1===0)  //($categ_id1) ena apo ta pio epimona troubleshooting, edo otan epestrefe 0 to theoroyse os 0 kai eftiaxne kainourgia grammi
    {
        
       $position= $categ_id1;//array_search($modelbiid,$sales_odoo_models_id);
        $sales_odoo_models_id[$position]['real_invoiced']=$sales_odoo_models_id[$position]['real_invoiced']+$result['qty_invoiced'];
        $sales_odoo_models_id[$position]['delivered']=$sales_odoo_models_id[$position]['delivered']+$result['qty_delivered'];
        $sales_odoo_models_id[$position]['in_so']=$sales_odoo_models_id[$position]['in_so']+$result['product_uom_qty'];
        $sales_odoo_models_id[$position]['untaxed_amount_invoiced']=$sales_odoo_models_id[$position]['untaxed_amount_invoiced']+$result['untaxed_amount_invoiced'];
        $sales_odoo_models_id[$position]['so_name'] = ($result['product_uom_qty'] > 0 and !str_contains($sales_odoo_models_id[$position]['so_name'],$result['name']))? $sales_odoo_models_id[$position]['so_name'].$result['name']."," : $sales_odoo_models_id[$position]['so_name'];
       
  }
    else
    {
        $manual_input_obj= $this->search_object($target_sales, 'categ_id', $category_id);
        if($manual_input_obj===false) {
       $target_units= 0;
       $wholesale_price= 0;
        }else

{
            
            $target_units= $manual_input_obj->total_units_month;
            $wholesale_price= $manual_input_obj->wholesale_price;

}

$so_name= $result['product_uom_qty'] > 0 ? $result['name']."," : "";

array_push($sales_odoo_models_id,
        array(   
            'categ_id' => $category_id,
            'bi_name' => $category_name,
            'target'=> $target_units,
            'wholesale_price'=>  $wholesale_price,
            'in_so'=>$result['product_uom_qty'],
            'delivered'=>$result['qty_delivered'],
            'real_invoiced'=>$result['qty_invoiced'],
            'untaxed_amount_invoiced'=>$result['untaxed_amount_invoiced'],
            'so_name'=> $so_name,//$result['name'].",",
            'percentage'=>0
        ));   
          
           
    }

//print_r($sales_odoo_models_id);

}
  //dd($sales_odoo_models_id);
  $month_name= date('F', mktime(0, 0, 0, $month, 10)); 
  return  view('units_target')->with('sales_odoo_models_id', $sales_odoo_models_id)->with('selected_year', $year)->with('selected_month', $month)->with('selected_month_name', $month_name);
    
 }

public function search_multidim($pinakas, $field, $value)
 {
    if (empty($pinakas)) {
        return false;
    }
   foreach($pinakas as $key => $row)
   {
      if ( $row[$field] === $value )
         return $key;
   }
   return false;
  }

public function search_object($obj, $field, $value)
{
    if (empty($obj)) {
        return false;
    }
    foreach($obj as $item) 
    {
       if ($value===$item->$field)
       {
        return $item;
                 
       }
      
    }
   return false;
}

public function make_raw_db_result_array($result_raw)
{

$result_array=array();
   
    foreach ($result_raw as $object_change) {
        $object_array=(array) $object_change;
        array_push($result_array,$object_array);

}

foreach ($result_array as $result) {
        $final_array[$result['dealerid']]=$result['invoicevalue_total'];

}

return  $final_array;
    
}

public function fetch_current_dealer(Request $request){
           
            $dealerid = intval($request->id);
            $url = Config('configva.odoo.production_url');//einai ston config folder
            $db = Config('configva.odoo.production_db');//einai ston config folder
            $username = Config('configva.odoo.user');//einai ston config folder
            $password = Config('configva.odoo.pass');//einai ston config folder
            $common = Ripcord::client("$url/xmlrpc/2/common");
            $uid = $common->authenticate($db, $username, $password, array());
            $models = Ripcord::client("$url/xmlrpc/2/object");
            $query_arguments=array(array('id', '=', $dealerid));
            $uii=$models->execute_kw($db, $uid, $password,'res.partner', 'search_read',array($query_arguments));
           
            foreach($uii as $result){
                $dealer_name=$result['display_name'];

}
          
           //consignments
           $query_arguments=array('&','&',array(['location_id'][0],'like','%'. $dealer_name.'%'),array('lot_id','!=',False),array('location_id.usage','=','internal'));  
           $limitations=array('fields'=>array('product_tmpl_id','display_name','lot_id','location_id','create_date'));  // Array of wanted fields True, False
           $consignment_list=$models->execute_kw($db, $uid, $password,'stock.quant', 'search_read',array($query_arguments),$limitations);
           //consignments
           
        
            //invoices INV
            $query_arguments=array('&','&',array('partner_id','=',$dealerid),array('invoice_date','!=',False),array('state', '=', 'posted'));  
           $limitations=array('fields'=>array('name','amount_untaxed_signed','invoice_date'));  // Array of wanted fields True, False
            $invoices_list=$models->execute_kw($db, $uid, $password,'account.move', 'search_read',array($query_arguments),$limitations);
           
       $total_inv=0;
      $total_rinv=0;
      $total_bill=0;
      foreach($invoices_list as $invoice){
            if (str_contains($invoice['name'], 'INV')){
                $total_inv+=$invoice['amount_untaxed_signed'];
                    }
            if (str_contains($invoice['name'], 'RINV')){
            $total_rinv+=$invoice['amount_untaxed_signed'];
                    }
             if (str_contains($invoice['name'], 'BIL')){
             $total_bill+=$invoice['amount_untaxed_signed'];
                    }
    }
           
           
   //invoices INV        
           
       
            //Sale Report
            $query_arguments=array('&',array('partner_id','=',$dealerid),array('product_tmpl_id.tracking','=','serial'));  
          $limitations=array('fields'=>array('product_tmpl_id','name','display_name'));  // Array of wanted fields True, False
            $sales_list=$models->execute_kw($db, $uid, $password,'sale.report', 'search_read',array($query_arguments), $limitations);

$per_model_sold_qty_ass=array();
           foreach($sales_list as $moto_sold){
               if (array_key_exists($moto_sold['product_tmpl_id'][1], $per_model_sold_qty_ass)){
            $per_model_sold_qty_ass[$moto_sold['product_tmpl_id'][1]]+=1;
                }
                else {
                    $per_model_sold_qty_ass[$moto_sold['product_tmpl_id'][1]]=1;
                }
               
           }
           arsort($per_model_sold_qty_ass);
          
           $per_model_sold_qty=array();

$i=0;
           foreach($per_model_sold_qty_ass as $x => $x_value) {
            $per_model_sold_qty[$i]['name']= $x;
            $per_model_sold_qty[$i]['qty']=$x_value;
            $i+=1;
          }

//Sale Report

//Back orders
 
$query_arguments=array('&' , array('state', '=', 'confirmed'),array('product_tmpl_id.tracking','=','serial'),array('partner_id','=',$dealerid ));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
//$limitations=array('fields'=>array('in_date','lot_id','location_id','tracking','inventory_quantity','quantity','reserved_quantity','product_id','product_uom_id','display_name','create_uid','product_tmpl_id')) ;
$bo_list=$models->execute_kw($db, $uid, $password, 'stock.move', 'search_read', array($query_arguments));

//Back orders

$totalvaluesnl=DB::table('snelstart_inv_clients')->where('dealerid','=',$dealerid)->sum('invoicevalue');

return view('current_dealer')->with('bo_list',$bo_list)->with('currentdealerid',$dealerid)->with('totalvaluesnl',$totalvaluesnl)->with('dealerid',$dealerid)->with('dealer_data',$uii)->with('consignment_list',$consignment_list)->with('invoices_list',$invoices_list)->with('sales_list',$sales_list)->with('per_model_sold_qty',$per_model_sold_qty)->with('total_inv',$total_inv)->with('total_bill',$total_bill)->with('total_inv',$total_inv)->with('total_rinv',$total_rinv)->with('total_bill',$total_bill);

}

public function fetch_current_dealer_refresh(Request $request){
           
        $dealerid = intval($request->input('dealerid'));
        $invstart = $request->input('start');
        $invend = $request->input('end');

}
      
       //consignments
       $query_arguments=array('&','&',array(['location_id'][0],'like','%'. $dealer_name.'%'),array('lot_id','!=',False),array('location_id.usage','=','internal'));  
       $limitations=array('fields'=>array('product_tmpl_id','display_name','lot_id','location_id','create_date'));  // Array of wanted fields True, False
       $consignment_list=$models->execute_kw($db, $uid, $password,'stock.quant', 'search_read',array($query_arguments),$limitations);
       //consignments
       
    
        //invoices INV
        $query_arguments=array('&','&',array('partner_id','=',$dealerid),array('invoice_date','!=',False),array('invoice_date','<',$invend),array('invoice_date','>',$invstart),array('state', '=', 'posted'));  
       $limitations=array('fields'=>array('name','amount_untaxed_signed','invoice_date'));  // Array of wanted fields True, False
        $invoices_list=$models->execute_kw($db, $uid, $password,'account.move', 'search_read',array($query_arguments),$limitations);
        //dd($invoices_list);  
   $total_inv=0;
  $total_rinv=0;
  $total_bill=0;
  foreach($invoices_list as $invoice){
        if (str_contains($invoice['name'], 'INV')){
            $total_inv+=$invoice['amount_untaxed_signed'];
                }
        if (str_contains($invoice['name'], 'RINV')){
        $total_rinv+=$invoice['amount_untaxed_signed'];
                }
         if (str_contains($invoice['name'], 'BIL')){
         $total_bill+=$invoice['amount_untaxed_signed'];
                }
}

//invoices INV        
       
   
        //Sale Report
        $query_arguments=array('&',array('partner_id','=',$dealerid),array('product_tmpl_id.tracking','=','serial'),array('date','<',$invend),array('date','>',$invstart));  
      $limitations=array('fields'=>array('product_tmpl_id','name','display_name'));  // Array of wanted fields True, False
        $sales_list=$models->execute_kw($db, $uid, $password,'sale.report', 'search_read',array($query_arguments), $limitations);

$per_model_sold_qty_ass=array();
       foreach($sales_list as $moto_sold){
           if (array_key_exists($moto_sold['product_tmpl_id'][1], $per_model_sold_qty_ass)){
        $per_model_sold_qty_ass[$moto_sold['product_tmpl_id'][1]]+=1;
            }
            else {
                $per_model_sold_qty_ass[$moto_sold['product_tmpl_id'][1]]=1;
            }
           
       }

arsort($per_model_sold_qty_ass);
       $per_model_sold_qty=array();

$i=0;
       foreach($per_model_sold_qty_ass as $x => $x_value) {
        $per_model_sold_qty[$i]['name']= $x;
        $per_model_sold_qty[$i]['qty']=$x_value;
        $i+=1;
      }

//Sale Report

//Back orders
 
 $query_arguments=array('&' , array('state', '=', 'confirmed'),array('product_tmpl_id.tracking','=','serial'),array('partner_id','=',$dealerid ));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
 //$limitations=array('fields'=>array('in_date','lot_id','location_id','tracking','inventory_quantity','quantity','reserved_quantity','product_id','product_uom_id','display_name','create_uid','product_tmpl_id')) ;
 $bo_list=$models->execute_kw($db, $uid, $password, 'stock.move', 'search_read', array($query_arguments));

//Back orders

$totalvaluesnl=DB::table('snelstart_inv_clients')->where('dealerid','=',$dealerid)->sum('invoicevalue');

return view('current_dealer')->with('bo_list',$bo_list)->with('currentdealerid',$dealerid)->with('dealerid',$dealerid)->with('totalvaluesnl',$totalvaluesnl)->with('dealer_data',$uii)->with('consignment_list',$consignment_list)->with('invoices_list',$invoices_list)->with('sales_list',$sales_list)->with('per_model_sold_qty',$per_model_sold_qty)->with('total_inv',$total_inv)->with('total_bill',$total_bill)->with('total_inv',$total_inv)->with('total_rinv',$total_rinv)->with('total_bill',$total_bill);

}

public function fetch_current_dealer_snelstart(Request $request){

$dealerid = intval($request->input('id'));
    $old_inv=DB::table('snelstart_inv_clients')->where('dealerid','=',$dealerid)->get();//->where('dealerid','=',$dealerid)->sum('invoicevalue');

return view('snelstart_old_invoices')->with('old_inv',$old_inv);

}

public function fetch_quotations_pending(){
            //connection strings
            $url = Config('configva.odoo.production_url');//einai ston config folder
            $db = Config('configva.odoo.production_db');//einai ston config folder
            $username = Config('configva.odoo.user');//einai ston config folder
            $password = Config('configva.odoo.pass');//einai ston config folder
            //test
        
            //connection strings
            $common = Ripcord::client("$url/xmlrpc/2/common");
            $uid = $common->authenticate($db, $username, $password, array());
            $models = Ripcord::client("$url/xmlrpc/2/object");
            $query_arguments=array(array('state', '=', 'draft'));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
            //$limitations=array('fields'=>array('in_date','lot_id','location_id','tracking','inventory_quantity','quantity','reserved_quantity','product_id','product_uom_id','display_name','create_uid','product_tmpl_id')) ;
            $uii=$models->execute_kw($db, $uid, $password, 'sale.order', 'search_read', array($query_arguments));//telos execute_kw
            return view('quotations_pending')->with('uii',$uii);

}

public function fetch_speedversion_change(){
            //connection strings
            $url = Config('configva.odoo.production_url');//einai ston config folder
            $db = Config('configva.odoo.production_db');//einai ston config folder
            $username = Config('configva.odoo.user');//einai ston config folder
            $password = Config('configva.odoo.pass');//einai ston config folder
            //connection strings
            $common = Ripcord::client("$url/xmlrpc/2/common");
            $uid = $common->authenticate($db, $username, $password, array());
            $models = Ripcord::client("$url/xmlrpc/2/object");
            $query_arguments=array('&',array('serial_no','=',False),array('state', '=', 'sale'));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
            //$limitations=array('fields'=>array('in_date','lot_id','location_id','tracking','inventory_quantity','quantity','reserved_quantity','product_id','product_uom_id','display_name','create_uid','product_tmpl_id')) ;
            $uii=$models->execute_kw($db, $uid, $password, 'sale.order.line', 'search_read', array($query_arguments));//telos execute_kw
            return view('speedversion_change')->with('uii',$uii);

}

public function fetch_simple_preparation(){
            //connection strings
            $url = Config('configva.odoo.production_url');//einai ston config folder
            $db = Config('configva.odoo.production_db');//einai ston config folder
            $username = Config('configva.odoo.user');//einai ston config folder
            $password = Config('configva.odoo.pass');//einai ston config folder
            //connection strings
            $common = Ripcord::client("$url/xmlrpc/2/common");
            $uid = $common->authenticate($db, $username, $password, array());
            $models = Ripcord::client("$url/xmlrpc/2/object");
            $query_arguments=array('&',array('serial_no','!=',False),array('state', '=', 'sale'));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
            //$limitations=array('fields'=>array('in_date','lot_id','location_id','tracking','inventory_quantity','quantity','reserved_quantity','product_id','product_uom_id','display_name','create_uid','product_tmpl_id')) ;
            $uii=$models->execute_kw($db, $uid, $password, 'sale.order.line', 'search_read', array($query_arguments));//telos execute_kw
            return view('simple_preparation')->with('uii',$uii);

}

public function fetch_sold_ytd(){
            $model = 'sale.report';
            $invstart=date("Y").'-01-01 00:00:52';
            $query_arguments=array('&',array(['product_id'][0],'=',13991),array('date','>',$invstart));
            $limitations=array('fields'=>array('product_id','qty_invoiced'));
            $call=new Odoocall();
            $uii=$call->Odooquery($model,$query_arguments);
            dd($uii);
            $modelcount=array();
            foreach($uii as $result)
            {
                $modelochk[$result['product_id'][0]]=$result['quantity'];

}

return view('sold')->with('modelcount',$modelcount);

}

public function fetch_who_reserved_what(Request $request){

$serial =$request->input('serial');

//$query_arguments=array('&' , array('state', '=', 'confirmed'),array('product_tmpl_id.tracking','=','serial'));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
           //'&' ,array('picking_code','=','outgoing'),
           // $query_arguments=array('&',array('picking_type_code','=','outgoing'),array('state','in',array('assigned','partially_available')));
           //$query_arguments=array('picking_code','=','outgoing');
           //$limitations=array('fields'=>array('in_date','lot_id','location_id','tracking','inventory_quantity','quantity','reserved_quantity','product_id','product_uom_id','display_name','create_uid','product_tmpl_id')) ;
          //var_dump($uii);

$model = 'stock.move';
                    $query_arguments= $serial=="true" ? array('&' ,'&' ,array('picking_code','=','outgoing'), array('state','in',array('assigned','partially_available')),array('product_tmpl_id.tracking','=','serial')) : array('&' ,'&' ,array('picking_code','=','outgoing'), array('state','in',array('assigned','partially_available')),array('product_tmpl_id.tracking','!=','serial'));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
                    $call=new Odoocall();
                    $uii=$call->Odooquery($model,$query_arguments);
            return view('who_reserved_what')->with('uii',$uii);
            
        }

public function fetch_who_demands_what(Request $request){

$serial = $request->input('serial');
                $model = 'stock.move';
                $query_arguments= $serial=="true" ? array('&' , array('state', '=', 'confirmed'),array('product_tmpl_id.tracking','=','serial')) : array('&' , array('state', '=', 'confirmed'),array('product_tmpl_id.tracking','!=','serial'));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
                $limitations=array('fields'=>array('x_vedor_ref_va','partner_id','product_id','product_uom_qty','origin','create_date','create_date','x_factory'));
                $call=new Odoocall();
                $uii=$call->Odooquery($model,$query_arguments,$limitations);

return view('who_demands_what')->with('uii',$uii)->with('withserial',$serial);
           
        }

public function fetch_aged_consignments_model(){
           
            $url = Config('configva.odoo.production_url');//einai ston config folder
            $db = Config('configva.odoo.production_db');//einai ston config folder
            $username = Config('configva.odoo.user');//einai ston config folder
            $password = Config('configva.odoo.pass');//einai ston config folder
             
                $common = Ripcord::client("$url/xmlrpc/2/common");
                $uid = $common->authenticate($db, $username, $password, array());
                $models = Ripcord::client("$url/xmlrpc/2/object");
                $query_arguments=array('&','&','&','&',array('location_id.usage','=','internal'),array(['location_id'][0],'!=',2075),array(['location_id'][0],'!=',2076),array(['location_id'][0],'!=',1975),array(['location_id'][0],'!=',8),array(['location_id'][0],'!=',9),array('lot_id','!=',False));
                $limitations=array('fields'=>array('product_tmpl_id','lot_id','location_id','create_date'));  // Array of wanted fields True, False
                $uii=$models->execute_kw($db, $uid, $password,'stock.quant', 'search_read',array($query_arguments),$limitations);

$modelcount = array();
             
                
                foreach($uii as $result)
                {

$modeloidchk=$result['product_tmpl_id'][0];
                    $modelochk=$result['product_tmpl_id'][1];
                    $chkthesi=$this->searchmodelname($modelcount,$modelochk); //allivs tha epsaxne na brei mia global synarthsh
                    $now = time();
                    $datediff = $now - strtotime($result['create_date']);
                    $days_in_consignment =round($datediff / (86400));  //    60*60*24=86400

if ($chkthesi==-1):
                                if($days_in_consignment<=30):
                                        $pushtobe=['referenceid'=>$modeloidchk,'name'=>$modelochk, 'd1_30'=> 1,'d31_60'=> 0, 'd61_90'=> 0, 'd91_120'=> 0, 'older'=>0, 'total'=>1];
                                        array_push($modelcount, $pushtobe);
                                    elseif($days_in_consignment>30 and $days_in_consignment<=60):
                                        $pushtobe=['referenceid'=>$modeloidchk,'name'=>$modelochk, 'd1_30'=> 0,'d31_60'=> 1, 'd61_90'=> 0, 'd91_120'=> 0, 'older'=>0, 'total'=>1];
                                        array_push($modelcount, $pushtobe);
                                    elseif($days_in_consignment>60 and $days_in_consignment<=90):
                                        $pushtobe=['referenceid'=>$modeloidchk,'name'=>$modelochk, 'd1_30'=> 0,'d31_60'=> 0, 'd61_90'=> 1, 'd91_120'=> 0, 'older'=>0, 'total'=>1];
                                        array_push($modelcount, $pushtobe);
                                    elseif($days_in_consignment>90 and $days_in_consignment<=120):
                                        $pushtobe=['referenceid'=>$modeloidchk,'name'=>$modelochk, 'd1_30'=> 0,'d31_60'=> 0, 'd61_90'=> 0, 'd91_120'=> 1, 'older'=>0, 'total'=>1];
                                        array_push($modelcount, $pushtobe);
                                    elseif($days_in_consignment>120):
                                        $pushtobe=['referenceid'=>$modeloidchk,'name'=>$modelochk, 'd1_30'=> 0,'d31_60'=> 0, 'd61_90'=> 0, 'd91_120'=> 0, 'older'=>1, 'total'=>1];
                                        array_push($modelcount, $pushtobe);
                                endif;                                
                        else:
                                  if($days_in_consignment<=30):
                                    $modelcount[$chkthesi]["d1_30"]++;
                                    $modelcount[$chkthesi]["total"]++;
                                  elseif($days_in_consignment>30 and $days_in_consignment<=60):
                                    $modelcount[$chkthesi]["d31_60"]++;
                                    $modelcount[$chkthesi]["total"]++;
                                  elseif($days_in_consignment>60 and $days_in_consignment<=90):
                                    $modelcount[$chkthesi]["d61_90"]++;
                                    $modelcount[$chkthesi]["total"]++;
                                  elseif($days_in_consignment>90 and $days_in_consignment<=120):
                                    $modelcount[$chkthesi]["d91_120"]++;
                                    $modelcount[$chkthesi]["total"]++;
                                  elseif($days_in_consignment>120):
                                    $modelcount[$chkthesi]["older"]++;
                                    $modelcount[$chkthesi]["total"]++;
                                  endif;
                        endif;
             
            
                
                
                
                    
                }
                
           
                //return view('current_stock')->with('current_stock', $modelcount); 
            return view('aged_consignement_models')->with('modelcount',$modelcount);

}

public function fetch_aged_consign_model_cust(Request $request){
           
            $modelid = intval($request->modelid);
            $periodclass = intval($request->periodclass);
            $now = date('y:m:d');

switch ($periodclass) {
                case 1:
                    $datemin = date('Y-m-d', strtotime($now. ' - 30 days'));
                    $datemax = date('Y-m-d', strtotime($now. ' - 0 days'));
                  break;
                case "31":
                    $datemin = date('Y-m-d', strtotime($now. ' - 60 days'));
                    $datemax = date('Y-m-d', strtotime($now. ' - 31 days'));
                  break;
                case "61":
                    $datemin = date('Y-m-d', strtotime($now. ' - 90 days'));
                    $datemax = date('Y-m-d', strtotime($now. ' - 61 days'));
                  break;
                  case "91":
                    $datemin = date('Y-m-d', strtotime($now. ' - 120 days'));
                    $datemax = date('Y-m-d', strtotime($now. ' - 91 days'));
                    break;
                    case "121":
                        $datemin = date('Y-m-d', strtotime($now. ' - 8000 days'));
                        $datemax = date('Y-m-d', strtotime($now. ' - 121 days'));
                    break;
                default:
                         $datemin = date('Y-m-d', strtotime($now. ' - 8000 days'));
                         $datemax = date('Y-m-d', strtotime($now. ' - 0 days'));
              }

$url = Config('configva.odoo.production_url');//einai ston config folder
              $db = Config('configva.odoo.production_db');//einai ston config folder
              $username = Config('configva.odoo.user');//einai ston config folder
              $password = Config('configva.odoo.pass');//einai ston config folder
         
            $common = Ripcord::client("$url/xmlrpc/2/common");
            $uid = $common->authenticate($db, $username, $password, array());
            $models = Ripcord::client("$url/xmlrpc/2/object");
           $query_arguments=array('&','&','&','&','&','&','&','&',array('location_id.usage','=','internal'),array('create_date','>=',$datemin),array('create_date','<=',$datemax),array(['location_id'][0],'!=',2075),array(['location_id'][0],'!=',2076),array(['location_id'][0],'!=',1975),array(['location_id'][0],'!=',8),array(['location_id'][0],'!=',9),array(['product_tmpl_id'][0],'=',$modelid),array('lot_id','!=',False));            $limitations=array('fields'=>array('product_tmpl_id','display_name','lot_id','location_id','create_date'));  // Array of wanted fields True, False
            $uii=$models->execute_kw($db, $uid, $password,'stock.quant', 'search_read',array($query_arguments),$limitations);

return view('aged_consign_models_cust')->with('customers_list',$uii);

}

//ayto einai mono gia tous exoterikous

public function models_showcase_no_auth()
    {
       
      $model = 'product.category';
      $query_arguments=array('&','&','&','&','&','&','&','&','&','&','&',array('complete_name','ilike', 'Motorcycles'),array('complete_name','not ilike', 'Unpublished'),array('child_id','=', False),array('name','not like', 'Samples'),array('name','not like', 'Used'),array('name','not like', 'Fast1'),array('name','not like', 'Tremor'),array('name','not like', 'Scooty'),array('name','not like', 'vehicle'),array('name','not like', 'Brio'),array('name','not like', 'Duel'),array('name','not like', '4Fast'),array('name','not like', 'Drag-b')); // Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
      // $limitations=array('limit'=>2);
     // $limitations=array('fields'=>array('location_id','product_id','inventory_quantity','quantity','reserved_quantity','product_tmpl_id','x_product_category')) ;
      $call=new Odoocall();
      $uii=$call->Odooquery($model,$query_arguments);
     //print_r( $uii);
     //dd( $uii);
      $models = array();
      $pattern = '([/])';
    foreach($uii as $result){

$category_name=$result['name'];
                        $category_id=$result['id']; 
                        $complete_name=$result['complete_name']; //full category
                        $models[$category_name][0]=$category_id;
                        $category_array = preg_split($pattern,  $complete_name);
                       //print_r(count($category_array));

$brand= $category_array[count($category_array)-2];
                       $models[$category_name][1]=str_replace(" ","",$brand);
                    }
                    ksort($models);

//dd( $models);
                    return view('models_showcase')->with('modelscat',$models);

}

//ayto einai mono gia tous exoterikous

public function fetch_current_stock_no_auth(Request $request)
    {
      $categid = intval($request->cat_id);
      $modelname = $request->model_name;
      $modelphotopath=url('/')."/imagesup/".$modelname.".jpg";
      $has_speed_version=$this->has_speed_version($categid);
      $debug =isset($request->debug)? intval($request->debug):0;
      //dd($debug);
      //print_r($modelname);
      $model = 'stock.quant';
     $query_arguments=array('&','&','&','&','&','&','&','&','&','&','&',array('x_isdemo','!=',true),array('product_tmpl_id.categ_id','ilike', 'Motorcycles'),array(['x_product_category'][0],'=', $categid), array('tracking', '=', 'serial'),array(['location_id'][0],'!=',15),array(['location_id'][0],'!=',2975),array(['location_id'][0],'!=',762),array(['location_id'][0],'!=',13),array(['location_id'][0],'!=',16),array(['location_id'][0],'!=',2013),array(['location_id'][0],'!=',5),array(['location_id'][0],'!=',4),array(['location_id'][0],'!=',14)); // Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
     // $limitations=array('limit'=>2);
     $limitations=array('fields'=>array('location_id','product_id','inventory_quantity','quantity','reserved_quantity','product_tmpl_id','x_product_category')) ;
      //$limitations=array('fields'=>array('quantity','reserved_quantity','product_id')) ;
      $call=new Odoocall();
      $uii=$call->Odooquery($model,$query_arguments ,$limitations);
      //print_r($uii);
      //dd("");
      $modelcount = array();
      $category_id=$categid;
    foreach($uii as $result){
                        $currentlocation=$result['location_id'][0];
                        $reserved_v=$result['reserved_quantity'];
                        $product_id=$result['product_id'][0];//$result['product_id'][0];
                        $product_description=$result['product_id'][1];
                        //$product_description=$result['product_id'][1];
                        $product_description=str_replace("(EURO 5) ","",$product_description);
                        //$product_description=str_replace("(no battery)","no battery",$product_description);
                        //$category_id=$result['x_product_category'][0];
                        $category_id=$categid;
                        $category_name=$this->product_category_to_last_child($result['x_product_category'][1]);
                        $color=$this->product_description_to_variant($product_description)[0];
                        $speedversion=isset($this->product_description_to_variant($product_description)[1])?$this->product_description_to_variant($product_description)[1]:"N/A";
                       $isinmol=$this->is_in_WHL($currentlocation);
                        
                        if($reserved_v==0 and $this->is_in_WH($currentlocation))
                        {

if(isset($modelcount[$product_id]))
                                        {
                                                            $modelcount[$product_id]['WH']+=1;
                                                            if($isinmol){$modelcount[$product_id]['WHL']+=1;}

}
                                    else
                                        {
                                                            $modelcount[$product_id]['category_name']= $category_name;
                                                            $modelcount[$product_id]['color']= $color;
                                                            $modelcount[$product_id]['speed']= $speedversion;
                                                            $modelcount[$product_id]['reserv']=0;
                                                            $modelcount[$product_id]['demands']=0;
                                                            $modelcount[$product_id]['ncrdemands']=0;
                                                            $modelcount[$product_id]['cat_id']=$category_id;
                                                            $modelcount[$product_id]['WH']=1;
                                                            $modelcount[$product_id]['WHL']=$isinmol?1:0;
                                                            $modelcount[$product_id]['WHLn']=0;
                                                            $modelcount[$product_id]['purchased_from_nipponia']=0;
                                                            $modelcount[$product_id]['nonWH']=0;
                                                            $modelcount[$product_id]['soon']=0;
                                                            $modelcount[$product_id]['eta']="";
                                                            $modelcount[$product_id]['origind']="";
                                                            $modelcount[$product_id]['originr']="";
                                                    
                                        }
                            }
                            elseif($reserved_v==0 and $this->is_in_consignement($currentlocation))
                            
                            {

if(isset($modelcount[$product_id]))
                                                    {
                                                                        $modelcount[$product_id]['nonWH']+=1;
                                                    }
                                                else
                                                    {
                                                                        $modelcount[$product_id]['category_name']= $category_name;
                                                                        $modelcount[$product_id]['color']= $color;
                                                                        $modelcount[$product_id]['speed']= $speedversion;
                                                                        $modelcount[$product_id]['reserv']=0;
                                                                        $modelcount[$product_id]['demands']=0;
                                                                        $modelcount[$product_id]['ncrdemands']=0;
                                                                        $modelcount[$product_id]['cat_id']=$category_id;
                                                                        $modelcount[$product_id]['WH']=0;
                                                                        $modelcount[$product_id]['WHL']=0;
                                                                        $modelcount[$product_id]['WHLn']=0;
                                                                        $modelcount[$product_id]['purchased_from_nipponia']=0;
                                                                        $modelcount[$product_id]['nonWH']=1;
                                                                        $modelcount[$product_id]['soon']=0;
                                                                        $modelcount[$product_id]['eta']="";
                                                                        $modelcount[$product_id]['origind']="";
                                                                        $modelcount[$product_id]['originr']="";
                                                                
                                                    }

}

//who demands what call
$model = 'stock.move';
$query_arguments=array('&' ,'&' , array('state', '=', 'confirmed'),array('product_tmpl_id.tracking','=','serial'),array(['x_product_category'][0],'=', $categid),array('origin','!=', false));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
$limitations=array('fields'=>array('product_uom_qty','x_product_category','origin','product_id','location_id'));
$call=new Odoocall();
$uii=$call->Odooquery($model,$query_arguments,$limitations);
//print_r($uii);
foreach($uii as $result){
   
    //$category_id=$result['x_product_category'][0];
    $category_name=$this->product_category_to_last_child($result['x_product_category'][1]);
    $product_id=$result['product_id'][0];//$result['product_id'][0];
    $product_description=$result['product_id'][1];
    $product_description=str_replace("(EURO 5) ","",$product_description);
    //$product_description=str_replace("(no battery)","no battery",$product_description);
    $color=$this->product_description_to_variant($product_description)[0];
    $speedversion=isset($this->product_description_to_variant($product_description)[1])?$this->product_description_to_variant($product_description)[1]:"N/A";
    $ncr=($result['location_id'][0]==2952); // [0] => 2952 [1] => NCR/No Credit Requests

if(isset($modelcount[$product_id])){

if(!$ncr){
        $modelcount[$product_id]['demands']+=$result['product_uom_qty'];
        $modelcount[$product_id]['origind']=$modelcount[$product_id]['origind'].$result['origin'].",";}
else{
    $modelcount[$product_id]['ncrdemands']+=$result['product_uom_qty'];

}

}
    else
    {

$modelcount[$product_id]['category_name']= $category_name;
        $modelcount[$product_id]['color']= $color;
        $modelcount[$product_id]['speed']= $speedversion;
        $modelcount[$product_id]['reserv']=0;
        $modelcount[$product_id]['demands']=$ncr?0:$result['product_uom_qty'];
        $modelcount[$product_id]['ncrdemands']=$ncr?$result['product_uom_qty']:0;
        $modelcount[$product_id]['cat_id']=$category_id;
        $modelcount[$product_id]['WH']=0;
        $modelcount[$product_id]['WHL']=0;
        $modelcount[$product_id]['WHLn']=0;
        $modelcount[$product_id]['purchased_from_nipponia']=0;
        $modelcount[$product_id]['nonWH']=0;
        $modelcount[$product_id]['soon']=0;
        $modelcount[$product_id]['eta']="";
        $modelcount[$product_id]['origind']="";
        $modelcount[$product_id]['originr']="";
          }

}

//who demands what call
//dd($modelcount);
//dd( $color);

//who reserves what call
$model = 'stock.move';
//$query_arguments=array('&' ,'&' ,array('picking_code','=','outgoing'), array('state','in',array('assigned','partially_available')),array('product_tmpl_id.tracking','=','serial'));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ]         
$query_arguments=array('&' ,'&','&' ,array('picking_code','=','outgoing'), array('state','in',array('assigned','partially_available')) ,array('product_tmpl_id.tracking','=','serial'),array(['x_product_category'][0],'=', $categid),array('origin','!=', false));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
$limitations=array('fields'=>array('product_uom_qty','x_product_category','origin','product_id'));
$call=new Odoocall();
$uii=$call->Odooquery($model,$query_arguments,$limitations);

foreach($uii as $result){
    //$category_id=$result['x_product_category'][0];
    $category_name=$this->product_category_to_last_child($result['x_product_category'][1]);
    $product_id=$result['product_id'][0];//$result['product_id'][0];
    $product_description=$result['product_id'][1];
    $product_description=str_replace("(EURO 5) ","",$product_description);
    //$product_description=str_replace("(no battery)","no battery",$product_description);
    $color=$this->product_description_to_variant($product_description)[0];
    $speedversion=isset($this->product_description_to_variant($product_description)[1])?$this->product_description_to_variant($product_description)[1]:"N/A";

if(isset($modelcount[$product_id])){

$modelcount[$product_id]['reserv']+=$result['product_uom_qty'];
        $modelcount[$product_id]['originr']=$modelcount[$product_id]['originr'].$result['origin'].",";
    }
    else
    {
        $modelcount[$product_id]['category_name']= $category_name;
        $modelcount[$product_id]['color']= $color;
        $modelcount[$product_id]['speed']= $speedversion;
        $modelcount[$product_id]['reserv']=$result['product_uom_qty'];
        $modelcount[$product_id]['demands']=0;
        $modelcount[$product_id]['ncrdemands']=0;
        $modelcount[$product_id]['cat_id']=$category_id;
        $modelcount[$product_id]['WH']=0;
        $modelcount[$product_id]['WHL']=0;
        $modelcount[$product_id]['WHLn']=0;
        $modelcount[$product_id]['purchased_from_nipponia']=0;
        $modelcount[$product_id]['nonWH']=0;
        $modelcount[$product_id]['soon']=0;
        $modelcount[$product_id]['eta']="";
        $modelcount[$product_id]['origind']="";
        $modelcount[$product_id]['originr']="";

}

//who reserves what call

//varriants
//$model = 'product.product';
//$query_arguments=array(array('categ_id','=',$category_id));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
//$limitations=array('fields'=>array('product_tmpl_id','product_variant_id'));
//$call=new Odoocall();
//$uii=$call->Odooquery($model,$query_arguments,$limitations);
//print_r($uii);

//dd($modelcount);

//forecasted quantity
$model = 'stock.move';
$nowdatetime =  date("Y-m-d h:i:sa");
//print_r($nowdatetime );

//$query_arguments=array('&' ,'&' ,array('picking_code','=','incoming ), array('state','in',array('assigned','partially_available')),array('product_tmpl_id.tracking','=','serial'));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ]         
$query_arguments=array('&' ,'&','&','&',array('date_expected','>',$nowdatetime),array('picking_code','=','incoming'), array('product_tmpl_id.tracking','=','serial'),array(['x_product_category'][0],'=', $categid),array('origin','!=', false));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
$limitations=array('fields'=>array('product_uom_qty','x_product_category','origin','product_id','date_expected','product_qty'));
$call=new Odoocall();
$uii=$call->Odooquery($model,$query_arguments,$limitations);
//dd($uii);
//print_r($uii);

foreach($uii as $result){
    //$category_id=$result['x_product_category'][0];
    $category_name=$this->product_category_to_last_child($result['x_product_category'][1]);
    $product_id=$result['product_id'][0];//$result['product_id'][0];
    $product_description=$result['product_id'][1];
    $date_expected=Carbon::createFromFormat('Y-m-d H:i:s', $result['date_expected'])->addWeeks(1);
    $date_expected =  $date_expected->format('Y-m-d');
    $product_description=str_replace("(EURO 5) ","",$product_description);
    //$product_description=str_replace("(no battery)","no battery",$product_description);
    $color=$this->product_description_to_variant($product_description)[0];
    $speedversion=isset($this->product_description_to_variant($product_description)[1])?$this->product_description_to_variant($product_description)[1]:"N/A";

if(isset($modelcount[$product_id])){

$modelcount[$product_id]['soon']+=$result['product_qty'];
        $modelcount[$product_id]['eta']=$modelcount[$product_id]['eta'].", ". $date_expected.",";
    }
    else
    {
        $modelcount[$product_id]['category_name']= $category_name;
        $modelcount[$product_id]['color']= $color;
        $modelcount[$product_id]['speed']= $speedversion;
        $modelcount[$product_id]['reserv']=0;
        $modelcount[$product_id]['demands']=0;
        $modelcount[$product_id]['ncrdemands']=0;
        $modelcount[$product_id]['cat_id']=$category_id;
        $modelcount[$product_id]['WH']=0;
        $modelcount[$product_id]['WHL']=0;
        $modelcount[$product_id]['WHLn']=0;
        $modelcount[$product_id]['purchased_from_nipponia']=0;
        $modelcount[$product_id]['nonWH']=0;
        $modelcount[$product_id]['soon']=$result['product_qty'];
        $modelcount[$product_id]['eta']= $date_expected;
        $modelcount[$product_id]['origind']="";
        $modelcount[$product_id]['originr']="";

}

//forecasted quantity

//added stock

$stock_for_cat=DB::select(DB::raw('SELECT * FROM `added_stock`  WHERE `cat_id`='.$category_id.';'));

if(count($stock_for_cat)!=0)
{ //start nipponia stock

foreach($stock_for_cat as $result){
    //$category_id=$result->cat_id;
    $category_name=$this->product_category_to_last_child($result->cat_name);
    $product_id=$result->product_id;//$result['product_id'][0];
    $product_description=$result->product_name;
    $validation_date=$result->added_on; //ayto prepei na einai to idio gia olo ton pinaka, allios proiotna me diaforetika dates apo thn idia kathgoria tha ypologistoyn lathos
    $date_expected=Carbon::createFromFormat('Y-m-d H:i:s', $result->eta)->addWeeks(1);
    $date_expected =  $date_expected->format('Y-m-d');
    $nowdatetime=date("Y-m-d");
    $hasarrived=$nowdatetime>$date_expected?true:false;
  
    //print_r($nowdatetime);
    //print_r($hasarrived);
    //print_r($date_expected);
    $product_description=str_replace("(EURO 5) ","",$product_description);
    //$product_description=str_replace("(no battery)","no battery",$product_description);
    $color=$this->product_description_to_variant($product_description)[0];
    $speedversion=isset($this->product_description_to_variant($product_description)[1])?$this->product_description_to_variant($product_description)[1]:"N/A";

if(isset($modelcount[$product_id])){

if($hasarrived)
                                    {
                                    $modelcount[$product_id]['WHLn']+=$result->qty;
                                    }
                            else
                                {
                                    $modelcount[$product_id]['soon']+=$result->qty;
                                    $modelcount[$product_id]['eta']=$modelcount[$product_id]['eta']. $date_expected.",";//edo den xexorizo ta mellontika eiserxomena
                                //print_r( $modelcount[$product_id]['eta']);
                                
                                
                                
                                }

if($hasarrived)
            {
                $modelcount[$product_id]['WHLn']=$result->qty;
                $modelcount[$product_id]['soon']=0;
                $modelcount[$product_id]['eta']="";//edo den xexorizo ta mellontika eiserxomena
            }
        else
            {
                $modelcount[$product_id]['soon']=$result->qty;
                $modelcount[$product_id]['eta']= $date_expected.",";//edo den xexorizo ta mellontika eiserxomena
                $modelcount[$product_id]['WHLn']=0;
            }

}

//added stock

//purchase from Nipponia
$model = 'purchase.report';
$nowdatetime =  date("m/d/y H:i:sa");
$validation_date=isset($validation_date)?$validation_date:$nowdatetime ;
//print_r($validation_date );

//$input = '05/10/2022 15:00:02';
//$date = strtotime($input);
//$query_arguments=array('&' ,'&' ,array('picking_code','=','incoming ), array('state','in',array('assigned','partially_available')),array('product_tmpl_id.tracking','=','serial'));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ]         
$query_arguments=array('&' ,'&' , array(['partner_id'][0],'=', 2097),array('date_order','>',$validation_date),array('category_id','=', $categid));// Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
$limitations=array('fields'=>array('category_id','product_id','qty_received'));
$call=new Odoocall();
$uii=$call->Odooquery($model,$query_arguments);
//print_r($uii);
//dd("");

foreach($uii as $result){
    //$category_id=$result['category_id'][0];
    $category_name=$this->product_category_to_last_child($result['category_id'][1]);
    $product_id=$result['product_id'][0];//$result['product_id'][0];
    $product_description=$result['product_id'][1];
    $product_description=str_replace("(EURO 5) ","",$product_description);
    //$product_description=str_replace("(no battery)","no battery",$product_description);
    $color=$this->product_description_to_variant($product_description)[0];
    $speedversion=isset($this->product_description_to_variant($product_description)[1])?$this->product_description_to_variant($product_description)[1]:"N/A";

if(isset($modelcount[$product_id])){

$modelcount[$product_id]['purchased_from_nipponia']+=$result['qty_received'];
      
    }
    else
    {
        $modelcount[$product_id]['category_name']= $category_name;
        $modelcount[$product_id]['color']= $color;
        $modelcount[$product_id]['speed']= $speedversion;
        $modelcount[$product_id]['reserv']=0;
        $modelcount[$product_id]['demands']=0;
        $modelcount[$product_id]['ncrdemands']=0;
        $modelcount[$product_id]['cat_id']=$category_id;
        $modelcount[$product_id]['WH']=0;
        $modelcount[$product_id]['WHL']=0;
        $modelcount[$product_id]['WHLn']=0;
        $modelcount[$product_id]['purchased_from_nipponia']=$result['qty_received'];
        $modelcount[$product_id]['nonWH']=0;
        $modelcount[$product_id]['soon']=0;
        $modelcount[$product_id]['eta']= "";
        $modelcount[$product_id]['origind']="";
        $modelcount[$product_id]['originr']="";

}

//purchased from Nipponia

} //end nipponia stock

if(isset($modelcount[4097]))
{
    $modelcount[4097]['WH']=$modelcount[4097]['WH']-1;  //afairesi ena apo aspro e-rex
}
//print_r($modelcount);

//merge 2 variants;
//if($categid===392) {
//$productid1=14534; //red
//$productid2=4139; //matred
//$modelcount=$this->merge_2variant_prdcts($modelcount,$productid1,$productid2);
//}
//merge 2 variants;

//print_r($modelcount);

if(!$has_speed_version)
{
$modelcount=$this->merge_speedversions($modelcount);
}

return view('odoo_stock')->with('modelcount',$modelcount)->with('modelname',$modelname)->with('catid',$category_id)->with('modelphotopath',$modelphotopath)->with('has_speed_version',$has_speed_version)->with('debug',$debug);
    }

//..........................................................................

public function product_description_to_variant($product_description)
{
    $clear1=isset(explode("(",$product_description)[1])?explode("(",$product_description)[1]:"NA,NA";//Mat Black, 25KM)
    $clear=substr($clear1, 0, -1);//Mat Black, 25KM
    $attr=explode(",", $clear);
    return $attr;
}

public function product_category_to_last_child($category_full_name)
{

$category_name_potition=strrpos($category_full_name," / ")+3;
    $category_name=substr($category_full_name,$category_name_potition);
    return $category_name;
}

public function is_in_WH($currentlocation)
{

$warehouse=($currentlocation==8 or $currentlocation==2075 or $currentlocation==1975);
    return $warehouse;
}

public function is_in_WHL($currentlocation)
{

$warehouse=($currentlocation==2075);
    return $warehouse;
}

//15->Production
            //2075 -> Mol
            //2076 ->Mol Input (sthn ousia einai pali Partner Locations/Customers/Input)
            //1975->WH/Trade & Traffic Plus BV/Heerde
            //8-> WH/Trade & Traffic Plus BV
            //9-> Partner Locations/Customers/Input
            //4-> "Partner Locations/Vendors" 
            //5->Partner Locations/Customers poulimeno
            //13->"Physical Locations/Trade & Traffic Plus BV: Transit Location"
            //14->"Virtual Locations/Trade & Traffic Plus BV: Inventory adjustment"
            //762->Virtual Locations/Trade and Traffic Plus BV: Missing
            //2013->Virtual Locations/Trade and Traffic Plus BV: Disassembled
            //16->Virtual Locations/Trade & Traffic Plus BV: Scrap
            //2960 ->Requested

public function merge_speedversions($modelcount)
{

$modelcountnew=array();
    foreach($modelcount as $result){
        $category_id=$result['cat_id'];
        $color=$result['color'];
$isinposition=$this->search_for_catid_color($category_id,$color,$modelcountnew);
        if (!isset($isinposition))
        
        {
            array_push($modelcountnew,$result);

}else{

$modelcountnew[$isinposition]['reserv']=$modelcountnew[$isinposition]['reserv']+$result['reserv'];
        $modelcountnew[$isinposition]['demands']=$modelcountnew[$isinposition]['demands']+$result['demands'];
        $modelcountnew[$isinposition]['ncrdemands']=$modelcountnew[$isinposition]['ncrdemands']+$result['ncrdemands'];
        $modelcountnew[$isinposition]['WH']=$modelcountnew[$isinposition]['WH']+$result['WH'];
        $modelcountnew[$isinposition]['nonWH']=$modelcountnew[$isinposition]['nonWH']+$result['nonWH'];
        $modelcountnew[$isinposition]['soon']=$modelcountnew[$isinposition]['soon']+$result['soon'];
        $modelcountnew[$isinposition]['WHLn']=$modelcountnew[$isinposition]['WHLn']+$result['WHLn'];
        $modelcountnew[$isinposition]['purchased_from_nipponia']=$modelcountnew[$isinposition]['purchased_from_nipponia']+$result['purchased_from_nipponia'];
                    
        
        if($result['eta']!="" and !str_contains($result['eta'],$modelcountnew[$isinposition]['eta']))
        {
        $modelcountnew[$isinposition]['eta']=$modelcountnew[$isinposition]['eta'];

}
        elseif($result['eta']!="" and !str_contains($modelcountnew[$isinposition]['eta'],$result['eta']))
        {

$modelcountnew[$isinposition]['eta']=$result['eta'];

}

$modelcountnew[$isinposition]['WHL']=$modelcountnew[$isinposition]['WHL']+$result['WHL'];
      }

}
    return $modelcountnew;
}

public function merge_2variant_prdcts($modelcount,$productid1,$productid2) //$productid2 is merged to $productid1
{

if (!isset($productid1) or !isset($productid2))
        
    {
        return $modelcount;

}else{

$modelcount[$productid1]['reserv']+=$modelcount[$productid2]['reserv'];
        $modelcount[$productid1]['demands']+=$modelcount[$productid2]['demands'];
        $modelcount[$productid1]['ncrdemands']+=$modelcount[$productid2]['ncrdemands'];
        $modelcount[$productid1]['WH']+=$modelcount[$productid2]['WH'];
        $modelcount[$productid1]['nonWH']+=$modelcount[$productid2]['nonWH'];
        $modelcount[$productid1]['soon']+=$modelcount[$productid2]['soon'];
        $modelcount[$productid1]['WHLn']+=$modelcount[$productid2]['WHLn'];
        $modelcount[$productid1]['purchased_from_nipponia']+=$modelcount[$productid2]['purchased_from_nipponia'];
        $modelcount[$productid1]['WHL']+=$modelcount[$productid2]['WHL'];

if($modelcount[$productid1]['eta']!="" and !str_contains($modelcount[$productid1]['eta'],$modelcount[$productid2]['eta']))
        {
        $modelcount[$productid1]['eta']=$modelcount[$productid1]['eta'].",".$modelcount[$productid2]['eta']; 
          
        }

unset($modelcount[$productid2]);

}
    return $modelcount;
}

function search_for_catid_color($catid, $color, $array) {

$n=sizeof($array);

for ($i = 0; $i < $n; $i++) {
        if ($array[$i]['cat_id'] === $catid and $array[$i]['color'] === $color) {
            return $i;
        }
    }
    return null;
 }

public function has_speed_version($category_id)
{

switch ($category_id) {
        case 388 : //E3
            $hassv=false;
        break;
        case 389 : //E4 Bring?
            $hassv=true;
        break;
        case 374  : //Cit-e
            $hassv=true;
        break;
        case 375  : //Drag-e
           $hassv=false;
        break;
        case 377  : //F3
            $hassv=true;
        break;
        case 378  : //F7
            $hassv=true;
        break;
        case 352  : //Volty
           $hassv=false;
        break;
        case 373   : //e-Legance
            $hassv=false;
        break;
        case 372   : //e-Rex
            $hassv=false;
        break;
        case 376   : //e-Viball
           $hassv=false;
        break;
        case 395   : //iLark
            $hassv=true;
        break;
        case 396   : //iTango
           $hassv=true;
        break;
        case 397    : //iTank
            $hassv=true;
        break;
        case 392    : //2Fast
            $hassv=false;
        break;
        case 394    : //Trimo
           $hassv=false;
        break;
        case 383    : //BIQ
            $hassv=false;
        break;
        case 384    : //Diva
           $hassv=false;
        break;
        case 446    : //On-e
            $hassv=false;
         break;
        default:
        $hassv=true;
      } 
    return $hassv;
}

public function is_in_consignement($currentlocation)
{

$warehouse=($currentlocation!=4 and $currentlocation!=5 and $currentlocation!=14 and $currentlocation!=762 and $currentlocation!=13 and $currentlocation!=8 and $currentlocation!=2075 and $currentlocation!=1975);
   
    return $warehouse;
}

public function fetch_custom_odoo_model(){

$model = 'sale.order.line';
   // $query_arguments=array('&',array('complete_name','ilike', 'Motorcycles'),array('complete_name','not ilike', 'Unpublished'),array('child_id','=', False),array('name','not like', 'Samples'),array('name','not like', 'Used'),array('name','not like', 'Fast1'),array('name','not like', 'Tremor'),array('name','not like', 'Scooty'),array('name','not like', 'vehicle'),array('name','not like', 'Brio'),array('name','not like', 'Duel'),array('name','not like', '4Fast'),array('name','not like', 'Pride'),array('name','not like', 'Drag-b')); // Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
 $query_arguments=array('|','|','|',array('product_id','=', 4185),array('product_id','=', 7981),array('product_id','=', 8038),array('product_id','=', 7943)); 
  //$query_arguments=array(array('product_id','>', 4185)); 
   //4185  Parts Snelstart
//7981 PARTS SNELSTART
// 8038 part snelstart
//7943 snelstart

// $limitations=array('limit'=>2);
  $limitations=array('fields'=>array('name','product_id','order_id','price_subtotal','x_invoice_line_total','invoice_status','create_date')) ;
    $call=new Odoocall();
    $uii=$call->Odooquery($model,$query_arguments,$limitations);
//print_r( $uii);
  //dd( "");

return view('odoo_partssnel')->with('uii',$uii);

}

public function non_deliverable_stock()
                  {
                     
                      $model = 'stock.quant';
                      $query_arguments=array('|','&','&','&',
                      array('product_tmpl_id.categ_id','ilike', 'Motorcycles'),
                      array('product_tmpl_id.categ_id','not like', 'Samples'),
                      array('tracking', '=', 'serial'),
                      array(['location_id'][0],'=',2013),
                      array(['location_id'][0],'=',2975)); 
                     $limitations=array('fields'=>array('location_id','product_id','inventory_quantity','quantity','reserved_quantity','product_tmpl_id','x_product_category','x_list_price')) ;
                     $call=new Odoocall();
                     $uii=$call->Odooquery($model,$query_arguments ,$limitations);
        
          //dd($uii);
                   
                      $modelcount = array();
                      foreach($uii as $result)
                     {
          
          
                      $category_full_name=$result['x_product_category'][1];
                      $category_id=$result['x_product_category'][0];
                      $category_name_potition=strrpos($category_full_name," / ")+3;
                      $category_name=substr($category_full_name,$category_name_potition);
          
                         $modelochk=$result['product_tmpl_id'][1];
                         $chkthesi=$this->searchmodelname($modelcount,$modelochk); 
                         $currentlocation=$result['location_id'][0];
                         $reserved_v=$result['reserved_quantity'];
                         $id=$result['product_tmpl_id'][0];//$result['product_id'][0];
                         $list_price=$result['x_list_price'];
 
                             if ($chkthesi==-1):
                                     if($currentlocation==2013):
                                         $pushtobe=['name'=>$modelochk, 'list_price'=>$list_price, 'WH'=> 1,'soon'=> 0, 'nonWH'=> 0, 'reserv'=> 0, 'id'=>$id, 'cat_id'=> $category_id, 'cat_name'=> $category_name];
                                         array_push($modelcount, $pushtobe);
                                     elseif($currentlocation==2975):
                                         $pushtobe=['name'=>$modelochk, 'list_price'=>$list_price, 'WH'=> 0, 'soon'=> 1, 'nonWH'=> 0, 'reserv'=> 0, 'id'=>$id,  'cat_id'=> $category_id, 'cat_name'=> $category_name];	
                                         array_push($modelcount, $pushtobe);
                                     endif;
                                     
                             else:
                                     if($currentlocation==2013):
                                         $modelcount[$chkthesi]["WH"]++;
                                 elseif($currentlocation==2975):
                                         $modelcount[$chkthesi]["soon"]++;
                                   endif;
                             endif;
                 
                     
                     }
          //dd($modelcount);
          //change array to category friendly array
                       $modelcountnew = array();
                       foreach($modelcount as $model2){
          
          
                          if(isset($modelcountnew[$model2['cat_id']])){
          
                              $modelcountnew[$model2['cat_id']]['WH']+=$model2['WH'];
                              $modelcountnew[$model2['cat_id']]['nonWH']+=$model2['nonWH'];
                              //$modelcountnew[$model2['cat_id']]['reserv']+=$model2['reserv'];
                              $modelcountnew[$model2['cat_id']]['soon']+=$model2['soon'];
                              $modelcountnew[$model2['cat_id']]['id']=$modelcountnew[$model2['cat_id']]['id'].'*'.$model2['id'];
                          }
                          else
                          {$modelcountnew[$model2['cat_id']]['category_name']=$model2['cat_name'];
                              $modelcountnew[$model2['cat_id']]['WH']=$model2['WH'];
                              $modelcountnew[$model2['cat_id']]['nonWH']=$model2['nonWH'];
                              $modelcountnew[$model2['cat_id']]['reserv']=0;
                              $modelcountnew[$model2['cat_id']]['demands']=0;
                              $modelcountnew[$model2['cat_id']]['soon']=$model2['soon'];
                              $modelcountnew[$model2['cat_id']]['id']=$model2['id'];
                              $modelcountnew[$model2['cat_id']]['cat_id']=$model2['cat_id'];
                              $modelcountnew[$model2['cat_id']]['origind']="";
                              $modelcountnew[$model2['cat_id']]['originr']="";
                              $modelcountnew[$model2['cat_id']]['list_price']=$model2['list_price'];
          
                          }
          
                       }
          
          
                      
                      //dd($modelcountnew);
          
          
         
          
                  return view('non_deliverable_stock')->with('modelcount',$modelcountnew)->with('uii', $uii);
                  }

public function fetch_current_stock_model_nd(Request $request){
           
                    $catid = intval($request->catid);
                    $model = 'stock.quant';
                    //  $query_arguments=array('&','&','&','&','&','&','&','&',array('location_id.usage','=','internal'),array('create_date','>=',$datemin),array('create_date','<=',$datemax),array(['location_id'][0],'!=',2075),array(['location_id'][0],'!=',2076),array(['location_id'][0],'!=',1975),array(['location_id'][0],'!=',8),array(['location_id'][0],'!=',9),array(['product_tmpl_id'][0],'=',$modelid),array('lot_id','!=',False));            
                    $limitations=array('fields'=>array('product_tmpl_id','display_name','lot_id','location_id','create_date'));  // Array of wanted fields True, False   
                    // $query_arguments=array('&','&','&',array(['product_tmpl_id'][0],'=',$modelid),array('tracking', '=', 'serial'),array(['location_id'][0],'!=',5),array(['location_id'][0],'!=',4),array(['location_id'][0],'!=',14)); // Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
                    //$query_arguments=array('&','&','&','&','&','&','&','&',array(['x_product_category'][0],'=',$catid),array(['location_id'][0],'!=',15),array('tracking', '=', 'serial'),array(['location_id'][0],'!=',13),array(['location_id'][0],'!=',762),array(['location_id'][0],'!=',16),array(['location_id'][0],'!=',2013),array(['location_id'][0],'!=',5),array(['location_id'][0],'!=',4),array(['location_id'][0],'!=',14)); // Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ]    
                    $query_arguments=array('&',
                    array(['x_product_category'][0],'=',$catid),'|',
                    array(['location_id'][0],'=',2975),
                    array(['location_id'][0],'=',2013),
                    
                );
                   
                    
                $vin_cost=[];

$call=new Odoocall();
    
                    $uii=$call->Odooquery($model,$query_arguments ,$limitations);
                    //$uii=$call->Odooquery($model,$query_arguments);
                    //dd($uii);
                   // print_r($uii);
            return view('current_stock_model')->with('model_list',$uii)->with('vin_cost',$vin_cost);
    
    
        }

//////////////////////////////////helper functions/////////////////////////
        //ajax requests

public function fetch_cost_per_cat(Request $request)
        {
          
           $year=intval($request->year);
           $month=intval($request->month);
           $warehouses=$year;

$catid = intval($request->catid);
           $model = 'stock.quant';
           //  $query_arguments=array('&','&','&','&','&','&','&','&',array('location_id.usage','=','internal'),array('create_date','>=',$datemin),array('create_date','<=',$datemax),array(['location_id'][0],'!=',2075),array(['location_id'][0],'!=',2076),array(['location_id'][0],'!=',1975),array(['location_id'][0],'!=',8),array(['location_id'][0],'!=',9),array(['product_tmpl_id'][0],'=',$modelid),array('lot_id','!=',False));            
           $limitations=array('fields'=>array('product_tmpl_id','display_name','lot_id','location_id'));  // Array of wanted fields True, False   
           // $query_arguments=array('&','&','&',array(['product_tmpl_id'][0],'=',$modelid),array('tracking', '=', 'serial'),array(['location_id'][0],'!=',5),array(['location_id'][0],'!=',4),array(['location_id'][0],'!=',14)); // Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ] 
           //$query_arguments=array('&','&','&','&','&','&','&','&',array(['x_product_category'][0],'=',$catid),array(['location_id'][0],'!=',15),array('tracking', '=', 'serial'),array(['location_id'][0],'!=',13),array(['location_id'][0],'!=',762),array(['location_id'][0],'!=',16),array(['location_id'][0],'!=',2013),array(['location_id'][0],'!=',5),array(['location_id'][0],'!=',4),array(['location_id'][0],'!=',14)); // Check polish notation in Odoo ( A or B ) AND ( C or D or E )  ginetai [ '&', '|', (A), (B), '|', (C), '|', (D), (E) ]    
           $query_arguments=array('&','&','&','&','&','&','&','&','&','&','&','&',
           array(['x_product_category'][0],'=',$catid),
           array('reserved_quantity','!=',1),
           array(['location_id'][0],'!=',15),
           array('tracking', '=', 'serial'),
           array(['location_id'][0],'!=',13),
           array(['location_id'][0],'!=',762),
           array(['location_id'][0],'!=',16),
           array(['location_id'][0],'!=',2013),
           array(['location_id'][0],'!=',5),
           array(['location_id'][0],'!=',4),
           array(['location_id'][0],'!=',9),
           array(['location_id'][0],'!=',2975),
           array(['location_id'][0],'!=',14));
          
           
          
           $call=new Odoocall();

$uii=$call->Odooquery($model,$query_arguments ,$limitations);
           //$uii=$call->Odooquery($model,$query_arguments);

$vin_cost_etc=DB::select(DB::raw('select VIN,cost,po from costpervins where cat_id="'.$catid.'";'));//DB::table('snelstart_inv_clients')->groupBy('dealerid');
           foreach ($vin_cost_etc as $value) 
               $vin_cost[$value->VIN] = $value->cost;

//dd($vin_cost);
          // print_r($uii);
   return view('current_stock_model')->with('model_list',$uii)->with('vin_cost',$vin_cost);

return response()->json(['data'=>$warehouses]);
         }

//ayto epistrefei json gia na gemisei ta selects sto bodega meta thn epilogh hmerominias

// to update table updated_stock_vins

// public function update_stock_vins(){

public function update_vin_stock_table(){
        DB::table('vins_in_stocks')->delete();    
        $model = 'stock.quant';
        $limitations=array('fields'=>array('lot_id'));  // Array of wanted fields True, False   
        $query_arguments=array('&','&','&','&','&','&','&','&','&','&','&','&',
        array('reserved_quantity','!=',1),
        array(['location_id'][0],'!=',15),
        array('tracking', '=', 'serial'),
        array('lot_id','!=',false),
        array(['location_id'][0],'!=',13),
        array(['location_id'][0],'!=',762),
        array(['location_id'][0],'!=',16),
        array(['location_id'][0],'!=',2013),
        array(['location_id'][0],'!=',5),
        array(['location_id'][0],'!=',4),
        array(['location_id'][0],'!=',9),
        array(['location_id'][0],'!=',2975),
        array(['location_id'][0],'!=',14));
        $call=new Odoocall();
        $uii=$call->Odooquery($model,$query_arguments ,$limitations);
        $datavins = [];
        foreach ($uii as $result) {
            $datavins[] = ['vin'  => $result['lot_id'][1]];
        }
        DB::table('vins_in_stocks')->insert($datavins);

return true;
}

// to update table updated_stock_vins telos

}

[+] ..
[+] Auth
[-] Controller.php [edit]
[-] OdooController batch.php-old [edit]
[-] OdooController copy.php-old [edit]
[-] error_log [edit]
[-] Molcontroller.php [edit]
[-] OdooController_nocalls.php [edit]
[-] HelperController.php [edit]
[-] SalesForecast.php [edit]
[-] OdooController.php [edit]
[-] OdooSparePartsController.php [edit]
[-] HomeController.php [edit]
[-] DelPickForms.php [edit]
[-] .htaccess.disabled [edit]