EMfinanga

@tykus you may check now, if you need the explanation you can email me

@tykus , ok will do this right now

i think, will stack much, so that why i need to show you what i have done, or we can use Zoom no worries @tykus

Then will share the result here as best answer

@tykus , thank you sorry may i show my code in my side please, emma4082@gmail.com

am not using JS framework, may be we can use one of them its ok for me

@tykus

how can I use in the blade view?, because i want to get a list of users when i select the team name

               <label>Team</label>
          <select class="form-control select2"  data-placeholder="Select a State"
          style="width: 100%;">
          <option>[SELECT]</option>
        @foreach($teamlist as $key=>$type)
       <option value="{{$key}}">{{$type}}</option>
        @endforeach
        </select>
      </div>

    </div>

    <div class="col-md-6">
      <div class="form-group">
        <label>Requested By:</label>
        <select class="form-control select2"  data-placeholder="Select a State"
        style="width: 100%;">
        <option>[SELECT USERS]</option>
       
      </select>
    </div>

I have a table of users and each users has specific team such as team 1, team 2 .... so i want when i select team 1 i can get the users which are in team 1.

How can i write this in controller,

@snapey how can i make autocomplete search from two table if you have a list of numbers

I want to search a list of numbers like 123 345 787 0998 From a two different table,

supposed the Tb 1 has number 123 345 Tb 2 has number 787 0998

How can i do this in my input search form,

@van1310 done

thanks i sorted

yes Sir @snapey , how can do it in controller and blade

I want to count a time example 3 hrs after created data, then to allow user within a three hours he can able to cancelled the bill,

kindly advice me the base way how i can do this

@van1310 , i used above replied and resolve my problem,

Thank bro very much

@van1310 , I know where id the error i takes the unit_number instead of unit_id

                         DB::table("issued_uploads")->whereIn('unit_id', $unitIssued)->delete();

array:2 [▼ 0 => "7200408112" 1 => "7200408003" ]

on my code the delete query does not delete the data, someone can help me where i did wrong

      public function issuedto(Request $request){

         $unit_id = $request->unit_id;
        // dd($request);

                    $unitIssued=store::whereIn('unit_id',$request->unit_id)->pluck('id');

                        
            $i=0;
                    foreach ($unitIssued as $value) {

                    IssuedUnit::create([
                        'unit_id' => $unitIssued[$i],
                        'issued_by' => Auth::user()->id,
                        'issued_to' => $request->selectTeam,
                        'req_by' => $request->inputSelect,
                       
                    ]);

                 //delete multiple data
                  DB::table("issued_uploads")->whereIn('unit_id', $unit_id)->delete(); 
            $i++;
            

        }

          return redirect()->back()
                                ->with('success',' Updated successfully.');

Actualy both is answer

I have the ajax, which pass the id like this 1,2,3

but when i create it, it save all id in one row, so what can i do to insert those list id

my controller

public function addMultipleUnit(Request $request){

        $ids = $request->ids;
       // $idsList=explode(",",$ids);
      // dd($ids);
 
  
            foreach ($ids as  $key=> $value) {
            IssuedUpload::create([
                'unit_id' => $ids[$key],
            
                ]);


               }   

           return response()->json(['status'=>true,'message'=>"added successfully."]);   

          // }
         }

thank you @ltroya

@van1310 this code is works but how can i add another condition to search all if the status=0

      $string = $request->UnitIdList;


        // split on 1+ whitespace & ignore empty (eg. trailing space)
        $searchValues = preg_split('/\s+/', $string, -1, PREG_SPLIT_NO_EMPTY); 

        $unitList = store::where(function ($q) use ($searchValues) {
          foreach ($searchValues as $value) {
            $q->orWhere('unit_id', 'LIKE', '%' .$value. '%');
          }
        })->get();

where i can add status=0

thanks brother, you make my day

@van1310 , this code it handle single input?, not many input 12334 23445 87878 77878 34455 as you can see here the data is seperated by space

I want to search a list of data like : 12334 23445 87878 77878 34455 which i copied from excel and paste it on my search form, then will get that data

kindly advice me the best way and example how i can archieve this

@michaloravec , Thanks you once again, for your support

@michaloravec , i would like to ask something am a new in Javascript

I want to put validation here id this id has alread created no need to add again

I tried like this

   public function addUnit_to_issued(Request $request,$id){

            // echo $id;

            $check=IssuedUpload::where('id',$id);
            // dd($check);

            if(!$check){

                IssuedUpload::create([
                    'unit_id' => $id,

                ]); 

            }
            else{
                return redirect()->back()
                ->with(error('Error','not added successfully.'));

            }
            if ($request->wantsJson()) {

                return response()->json([
                    'success' => 'added successfully.'
                ]);
            }

@michaloravec , thanks much

am get

 		SUCCESS:  
     {success: "Updated successfully."}
      success: "Updated successfully."

i want to store/create this id to another table, kindly can you show me how i can add there

controller

          public function addUnit_to_issued(Request $request,$id){
              echo $id;

            $id = $request->id;

            dd($id);
                      

            return redirect()->back()
                            ->with('success',' Updated successfully.');
            }

route

          Route::post('addUnit/{id}','[email protected]_to_issued');

@michaloravec i tried to change but get the same error

@jlrdw am get the id after alert it

I want to pass id from my blade form and store that id to another table,

am try like this but get this error

my blade form

                 <td>
                  <meta name="csrf-token" content="{{ csrf_token() }}">
                  <a href="#" data-id="{{$dt->id}}" id="add_btn" class="btn btn-sm btn-default add_btn ">Issue</i> 
                  </a> </td>
              </tr>
              @endforeach
           </tbody>

my ajax

           $(".add_btn").click(function(e){

               e.preventDefault();
     
              var id = $(this).data("id");

                 var token = $("meta[name='csrf-token']").attr("content");
           

                     $.ajax(
                     {
                      url: "addUnit/"+id, 
                  type: 'POST',
          
                  data: {
                    "id": id,
                    "_token": token,
                  },
                 dataType: 'json',
                    success: function(data) {
                        console.log('SUCCESS: ', data);
                    },
                    error: function(data) {
                        console.log('ERROR: ', data);
                    },
               });
            });

my controller public function addUnit_to_issued(Request $request){

             $id = $request->input('id');
            // store id data to another table here

              dd($id);
                      

            return redirect()->back()
                            ->with('success',' Updated successfully.');
              }

error

             ERROR:  {readyState: 4, setRequestHeader: ƒ, getAllResponseHeaders: ƒ, getResponseHeader: ƒ, 
             overrideMimeType: ƒ, …}

             POST http://127.0.0.1:8000/store/addUnit/1 404 (Not Found)

or can I upload excel file, and search ?

@deepu07 there is no way i can copy and paste those number in once and comes in table row in all at once?

Hello, How can I search a list of number from one input form,

Example i have this list 12334 23457 3555 6666 7777 separated by space i want to paste on my search input form and and click search button to get those number

Keep in mind that those number are found in one table from DB

Someone can help me

you can try this https://adminlte.io/themes/AdminLTE/index2.html, is good

this is works

              $stockcount= count($stocks);
            $totalPid = count($data['pid']);
            $totalQty = count($data['qty']);
            $totalTruckNumber = count($data['truckNumber']);

            $remain=$totalPid-$stockcount;
    // dd($remain);

            for($i=$stockcount; $i<$totalPid; $i++){      
                Stock::create([
                    'pid' => $request->pid[$i],
                    'qty' => $request->qty[$i],
                    'inv_no' => $request->inv_no,
                    'user_id' => Auth::user()->id,
                    'Indate'=>$date,
                    'supplierName' => $request->supplierName,
                    'receiptNumber' => $request->receiptNumber,
                    'truckNumber' => $request->truckNumber[$i],
                    'driverName' => $request->driverName,
                    'remark' => $request->remark,
                ]);
            }

No, i like to pass the massage in blade view

this is works

              $stockcount= count($stocks);
            $totalPid = count($data['pid']);
            $totalQty = count($data['qty']);
            $totalTruckNumber = count($data['truckNumber']);

            $remain=$totalPid-$stockcount;
    // dd($remain);

            for($i=$stockcount; $i<$totalPid; $i++){      
                Stock::create([
                    'pid' => $request->pid[$i],
                    'qty' => $request->qty[$i],
                    'inv_no' => $request->inv_no,
                    'user_id' => Auth::user()->id,
                    'Indate'=>$date,
                    'supplierName' => $request->supplierName,
                    'receiptNumber' => $request->receiptNumber,
                    'truckNumber' => $request->truckNumber[$i],
                    'driverName' => $request->driverName,
                    'remark' => $request->remark,
                ]);
            }

how sir @snapey

this is like id so there is the invoice number i passed there

       	Route::get('stock/show/{inv_no}', '[email protected]');

This return is works but the massage success does not display, what can i change

            return  $this->show($inv_no)->with('success', 'GRN  Edited Successfully ');

@bobbybouwmann array[0,1,2] are in DB, but array[3,4] i want to added in DB

So my logic is the exist array can updated and additional array can be added

            array:10 [▼
              "_token" => "GBMOuQQrICXXO8DvV8FoV35VFKWuJXEok1TlF1o7"
              "inv_no" => "GRN3105200005"
              "supplierName" => "dar"
              "receiptNumber" => "98799x"
              "driverName" => "DD"
              "remark" => "OK"
              "Indate" => "2020-05-31"
              "pid" => array:5 [▼
                0 => "1"
                1 => "2"
                2 => "3"
                3 => "4"
                4 => "5"
              ]
              "truckNumber" => array:5 [▼
                0 => "T 640"
                1 => "T 678"
                2 => "T 220 DRS"
                3 => "T 155"
                4 => "T 640"
              ]
              "qty" => array:5 [▼
                0 => "60"
                1 => "55"
                2 => "40"
                3 => "4"
                4 => "5"
              ]
            ]

ok @bobbybouwmann

Join Zoom Meeting https://zoom.us/j/91275984788?pwd=MG5VeVZLbFNGdHJSVFlLekRZYzdkZz09

Meeting ID: 912 7598 4788 Password: 1jcLBM

click that link to join sir

@bobbybouwmann no am just share the link for zoom here to connect in my pc and to show you

@bobbybouwmann may i show the my how it works in my end ?

I can share on my zoom

@bobbybouwmann am tried to use count but it update existing data and save one row while i have added more than one rows.

But if i loop i think it can duplicate the data ?

I have an invoice form so I want to Edit/update row which are exist and add new rows of the same invoice number

this code is update existing one and add one row , but if i add more than one rows does not added all its update exist and add new one .

so i want to update exist and add new all rows which is additional

          public function update(Request $request, $inv_no)
      {

   $data = $request->all();

    $date = date ("Y-m-d",  strtotime($request->Indate));

   $stocks = Stock::where('inv_no', $inv_no)->get();
    $i = 0;

      foreach ($stocks as $stock) { 
      Stock::where('inv_no', $inv_no)
        ->where('id', $stock->id)
        ->update([
            'pid' => $request->pid[$i],
            'qty' => $request->qty[$i],
            'user_id' => Auth::user()->id,
            'Indate'=>$date ,
            'supplierName' => $request->supplierName,
            'receiptNumber' => $request->receiptNumber,
            'truckNumber' => $request->truckNumber[$i],
            'driverName' => $request->driverName,
            'remark' => $request->remark,
        ]);

             $i++;
    }

    $stockcount= count($stocks);
    $totalPid = count($data['pid']);
    $totalQty = count($data['qty']);
    $totalTruckNumber = count($data['truckNumber']);
   // dd($request->pid[$totalPid-1]);

     if ($stockcount < $totalPid ) {

       
        Stock::create([
            'pid' => $request->pid[$totalPid-1],
            'qty' => $request->qty[$totalQty-1],
            'inv_no' => $request->inv_no,
            'user_id' => Auth::user()->id,
            'Indate'=>$date,
            'supplierName' => $request->supplierName,
            'receiptNumber' => $request->receiptNumber,
            'truckNumber' => $request->truckNumber[$totalTruckNumber-1],
            'driverName' => $request->driverName,
            'remark' => $request->remark,
        ]);
     
       }

Mobile app