EMfinanga

Member Since 1 Year Ago

Experience Points
11,220
Total
Experience

3,780 experience to go until the next level!

In case you were wondering, you earn Laracasts experience when you:

  • Complete a lesson — 100pts
  • Create a forum thread — 50pts
  • Reply to a thread — 10pts
  • Leave a reply that is liked — 50pts
  • Receive a "Best Reply" award — 500pts
Lessons Completed
0
Lessons
Completed
Best Reply Awards
0
Best Reply
Awards
  • start your engines Created with Sketch.

    Start Your Engines

    Earned once you have completed your first Laracasts lesson.

  • first-thousand Created with Sketch.

    First Thousand

    Earned once you have earned your first 1000 experience points.

  • 1-year Created with Sketch.

    One Year Member

    Earned when you have been with Laracasts for 1 year.

  • 2-years Created with Sketch.

    Two Year Member

    Earned when you have been with Laracasts for 2 years.

  • 3-years Created with Sketch.

    Three Year Member

    Earned when you have been with Laracasts for 3 years.

  • 4-years Created with Sketch.

    Four Year Member

    Earned when you have been with Laracasts for 4 years.

  • 5-years Created with Sketch.

    Five Year Member

    Earned when you have been with Laracasts for 5 years.

  • school-in-session Created with Sketch.

    School In Session

    Earned when at least one Laracasts series has been fully completed.

  • welcome-newcomer Created with Sketch.

    Welcome To The Community

    Earned after your first post on the Laracasts forum.

  • full-time-student Created with Sketch.

    Full Time Learner

    Earned once 100 Laracasts lessons have been completed.

  • pay-it-forward Created with Sketch.

    Pay It Forward

    Earned once you receive your first "Best Reply" award on the Laracasts forum.

  • subscriber Created with Sketch.

    Subscriber

    Earned if you are a paying Laracasts subscriber.

  • lifer Created with Sketch.

    Lifer

    Earned if you have a lifetime subscription to Laracasts.

  • evangelist Created with Sketch.

    Laracasts Evangelist

    Earned if you share a link to Laracasts on social media. Please email [email protected] with your username and post URL to be awarded this badge.

  • chatty-cathy Created with Sketch.

    Chatty Cathy

    Earned once you have achieved 500 forum replies.

  • lara-veteran Created with Sketch.

    Laracasts Veteran

    Earned once your experience points passes 100,000.

  • 10k-strong Created with Sketch.

    Ten Thousand Strong

    Earned once your experience points hits 10,000.

  • lara-master Created with Sketch.

    Laracasts Master

    Earned once 1000 Laracasts lessons have been completed.

  • laracasts-tutor Created with Sketch.

    Laracasts Tutor

    Earned once your "Best Reply" award count is 100 or more.

  • laracasts-sensei Created with Sketch.

    Laracasts Sensei

    Earned once your experience points passes 1 million.

  • top-50 Created with Sketch.

    Top 50

    Earned once your experience points ranks in the top 50 of all Laracasts users.

  • Community Pillar

    Earned once your experience points ranks in the top 10 of all Laracasts users.

Level 3
11,220 XP
Mar
02
15 hours ago
Activity icon

Replied to Failed To Authenticate On SMTP Server With Username "[email protected]" Using 2 Possible Authenticators

@wazirhashmi@yahoo.com , where did i get my app password because am using gmail

Feb
25
5 days ago
Activity icon

Started a new Conversation How To Get Collection Without Duplicates In Laravel

how can i select my collection without duplication data

        $data = DB::table('sales')
               ->select('users.name as nametag','teams.*','locations.*','sales.*','devices.*',\DB::raw("group_concat(devices2.Devicenumber SEPARATOR '\n') as slavename"),'sales.created_at as created_at_sale',\DB::raw('COUNT(slave_id )   as totalslave'))
                                   // ->leftJoin('customers','customers.id','=','sales.client_id')
                                   ->leftjoin('teams','teams.id','=','sales.tag_id')
                                         ->leftJoin('users','users.id','=','sales.user_id')

                                   ->leftjoin('locations','locations.id','=','sales.borderName')
                                   ->leftjoin('devices','devices.id','=','sales.unit_issue_id')
                                   ->leftjoin("devices as devices2",\DB::raw("FIND_IN_SET(devices2.id,sales.slave_id)"),">",\DB::raw("'0'"))
                                ->where([

                                    ['sales.sale_type',1],
                                    ['sales.tag_id',$team]

                                    ])
                                 ->groupBy('sales.bill_number')
                                       ->orderBy('sales.created_at', 'DESC')
                                       ->DISTINCT()
                                       ->get();

i tried like this but does not works

Devicenumber and other details are duplicate with different bill_number

Feb
22
1 week ago
Activity icon

Replied to Select2 Basic Example Not Working

@guybrush_threepwood i tried but did not works

Activity icon

Started a new Conversation Select2 Basic Example Not Working

js-example-basic-single does not works when i want to add append div, but in html it works well.

        <script type="text/javascript">

            $(document).ready(function() {
                $(".js-example-basic-single").select2();
            });


             $('.addRow').on('click',function(){
              

                addRow();
              });
              function addRow()
              {
                var div=
                     '<div class="form-group ">'+
                        '<div class="input-group">'+
                        '<span class="input-group-addon remove3"><span class="glyphicon glyphicon-minus-sign" aria-hidden="true"></span></span>'+
                        '<select name="slave_ID[]" class="form-control js-example-basic-single" required="" data-live-search="true">'+
                            '<option value=" ">[SELECT SLAVE]</option>'+
                                '@foreach($Slave as $key=>$dt)'+
                                '@if($dt->devicetype ==2)'+
                            '<option value="{{$dt->unit_id}}">{{$dt->Devicenumber}}</option>'+
                            '@endif'+
                            '@endforeach'+

                        '</select>'+
                    '</div>'+
                        '</div>' ;
                $('#slaveID').append(div);
              };
              $('.remove').live('click',function(){
                var last=$('#tdy tr').length;
                if(last==1){
                  alert("you can not remove last row");
                }
                else{
                  $(this).parent().parent().remove();
                }
                
              });

what could be the error here, kindly help me

Feb
19
1 week ago
Activity icon

Replied to How To Show Multiple Selected Data While Editing In Drop Down

@apexleo ,

can we show selected value without to compare it, because this query can not compare with selected value because the unit_id has not found due to its status is 1 while unselected value has the status =0

Feb
16
2 weeks ago
Activity icon

Replied to How To Show Multiple Selected Data While Editing In Drop Down

am get the error

           in_array() expects parameter 2 to be array,
Activity icon

Started a new Conversation How To Show Multiple Selected Data While Editing In Drop Down

I want to display selected items on my edit form, i have tried to on my code below but did not show selected items but i can see unselected items.

My controller.

    $Slave = DB::table('my_stocks')->leftjoin('devices', 'devices.id','=','my_stocks.unit_id')->where('my_stocks.status',0)->get();

   $bill2 = DB::table('sales')->WHERE('sale_type', 1)->WHERE("sales.bill_number", $bill_number)->get();

My blade view

           @if($bill->slave_id)

  @foreach($bill2 as $data)
        <div id="box6" class="form-group col-md-4 ">
            <div class="input-group">
                <span class="input-group-addon">SLAVE</span>
                <select name="slave_ID[]" class="form-control" data-live-search="true" >
                    <option value="" >[SELECT SLAVE]</option>
                     @foreach($Slave as $key=>$dt) 
                   @if($dt->devicetype ==2)
                    
          <option value="{{$dt->unit_id}}" @if($dt->unit_id == $data->slave_id) selected="true" @endif>{{$dt->Devicenumber}}</option>
                    @endif
                 @endforeach

                </select>
            </div>
        </div>
     @endforeach
     @endif
Feb
05
3 weeks ago
Activity icon

Started a new Conversation How To Pass Two Variable To Generate The QrCode

am using the Package to generate the qr code , i want to pass two or more variable to generate it,

this is what am tried but get the error, someone can help me

   file_put_contents(2002503476 2002503326): failed to open stream: No such file or directory (View: C:\xampp\htdocs\equalpoint\resources\views\sales\printreceiptcredit.blade.php)

My blade view

                 <?php $master=$billsale->Devicenumber; $slave=$billsale->slavename;?>
     <td style="text-align: center;"> {!! QrCode::size(70)->generate( $master, $slave); !!}</td>
Activity icon

Replied to How To Generate Qrcode In My Blade

@michaloravec

i tried like this it works when i pass one variable $master but when i put two variable am get this error

     file_put_contents(2002503476 2002503326): failed to open stream: No such file or directory (View: C:\xampp\htdocs\equalpoint\resources\views\sales\printreceiptcredit.blade.php)

my blade code

             <?php $master=$billsale->Devicenumber; $slave=$billsale->slavename;?>
            <td style="text-align: center;"> {!! QrCode::size(70)->generate( $master,$slave ); !!}</td>
Feb
04
3 weeks ago
Activity icon

Started a new Conversation How To Generate Qrcode In My Blade

i have the controller which return data so i want to create Qr code, in my blade view

My controller

         public function print_sales_bill_credit($bill_number){
    // sorry can you wait 1 sec pls

                 $billsale=DB::table('sales')

                                   ->leftJoin('customers','customers.id','=','sales.client_id')
                                   ->leftJoin('teams','teams.id','=','sales.tag_id')
                                     ->leftJoin('users','users.id','=','sales.user_id')

                                   ->leftJoin('locations','locations.id','=','sales.borderName')
                                   ->leftJoin('devices','devices.id','=','sales.unit_issue_id')
                                   ->leftJoin('customer__orders','customer__orders.id','=','sales.TruckNo_id')

                                   ->leftJoin("devices as devices2",\DB::raw("FIND_IN_SET(devices2.id,sales.slave_id)"),">",\DB::raw("'0'"))
                                 ->where([

                                    ['sales.sale_type',2],
                                    ['sales.bill_number',$bill_number]

                                    ])

                                   ->first(['customers.*','users.*','teams.*','locations.*','customer__orders.*','sales.*','devices.*',\DB::raw("group_concat(devices2.Devicenumber SEPARATOR '\n') as slavename"),'sales.created_at as created_at_sale',DB::raw("count(*) as totalslave")]);

            
               // return json_encode(array('data'=>$billsale));
                                   $result_arr = array();
                                   array_push($result_arr, $billsale);
                    return view('sales.printreceiptcredit',compact('result_arr'));
            } 

my blade view

                <table cellspacing="0">
              @if($billsale->slavename ==null)

              <tr>
                <td>Master#</td>
                <td>:</td>
                <td></td>
                <td style="text-align:right"><h4><strong>{{$billsale->Devicenumber}}</strong></h4></td>

              </tr>
              @else
               <tr>
                <td>Master#</td>
                <td>:</td>

                <td style="text-align:right" ><h4><strong>{{$billsale->Devicenumber}}</strong></h4></td>

              </tr>
            <tr>
                <td>Slaves#</td>
                <td>:</td>
               
                <td style="width:12px">*{{$billsale->slavename}}</td>
              
                
              </tr>
            @endif
            </table>

so i want to create my qr code with {{$billsale->slavename}} and {{$billsale->Devicenumber}}

am installed this Packaged in my project but i did not managed to make the qr code.

    composer require simplesoftwareio/simple-qrcode
Jan
31
4 weeks ago
Activity icon

Replied to Pass Data-id Into A Controller

@ep!sode , have you understand ?

Activity icon

Replied to Pass Data-id Into A Controller

@ep!sode yes i mean that

also you can see this line in above code

                    if(data[count].untag_status == "1")

          {
           var received_btn='<button class="btn-xs">RECEIVED</button>';
          }
          else
          {
            received_btn='<a class="btn btn-success btn-xs activate_btn" id="activate_btn" data-id='+data[count].bill_number+' >RECEIVE</a>';
          }
Activity icon

Started a new Conversation Pass Data-id Into A Controller

I have display my data well, but i want to takes data-id and pass to controller , i tried like this but does not works,

Kindly can you help me where i did wrong

$(document).ready(function(){

       fetch_bill_data();



       function fetch_bill_data(query = '') 
       {
        $.ajax({
         url:"{{route('intransit.unit') }}",
         method:"POST",
         data:{query:query,
               _token:'{{ csrf_token() }}'
         
         },
         dataType:'json',
         success:function(data)
         {
          console.log(data);
          var output = '';
          var amount=0;
          var i=1;
          for(var count = 0; count < data.length; count++)
            {
          
                    
          if(data[count].untag_status == "1")

              {
               var received_btn='<button class="btn-xs">RECEIVED</button>';
              }
              else
              {
                received_btn='<a class="btn btn-success btn-xs activate_btn" id="activate_btn" data-id='+data[count].bill_number+' >RECEIVE</a>';
              }

           output += '<tr style="font-size:0.78em;">';
           output += '<td>' + i++ + '</td>';

          output += '<td>'+received_btn+'</td>';
           output += '<td>' +data[count].bill_number  + '</td>';
    
           output += '</tr>';
          }
          $('tbody').html(output);
         }
        });


      }
       $(document).on('keyup', '#searchdata', function(){
        var query = $(this).val();
       // var token = $("meta[name='csrf-token']").attr("content");

        fetch_bill_data(query);
       });

      });

      

i call my data-id like this but does not works

              $("#receive_btn").click(function (e) {

                     if(!confirm("Do you want to Received this?")) {
                             return false;

                           }
                           
                  e.preventDefault();

                  var billnumber= $(this).data("id");

                  // alert(id);

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

                  $.ajax({
                      url: "/ack_unit/" + billnumber,
                      type: "POST",

                      data: {
                         'billnumber': billnumber,
                          "_token": token,
                      },
                      dataType: "json",
                      success: function (data) {
                          console.log('SUCCESS: ', data);
                          // alert("Added successfully");
                          location.reload();
                          return false;
                      },
                      error: function (data) {
                          console.log("ERROR: ", data);
                          location.reload();
                          return false;
                      },
                  });
              });
Jan
28
1 month ago
Activity icon

Replied to Htmlspecialchars() Expects Parameter 1 To Be String, Object Given

No error now am set like this

                        	</div>
                        	<div id=""  class="form-group col-md-4">
                        		<div class="input-group">
                        		<span class="input-group-addon">{{$editbillinfo->deviceNumb->Devicenumber}}</span>
                        			<select name="unit_id" class=" form-control js-example-basic-single" data-live-search="true"  >

                        					@foreach($master as $key=>$dt)
                        				
                        			    <option value="{{$key}}" @if($key == $bill->unit_issue_id) selected @endif>{{$key}}</option>
                        			
                        				@endforeach

                        			</select>
                        		</div>
                        </div>
                        </div>

                   
                   
                     
                         <div class="row">
                        
                         
                        	<div   class="form-group col-md-4">
                        		<div class="input-group">
                        		<span class="input-group-addon"></span>
                        			<select  name="slave_ID[]" class=" form-control js-example-basic-single">
                                        <option value="">[SELECT SLAVE]</option>
                        			
                        					@foreach($Slave as $key=>$dt)
                        					
                                           <option value="{{$key}}" @if($key == $bill->slave_id) selected @endif>{{$dt}}</option>

                        			
                        				@endforeach

                        			</select>
                        		</div>
                        </div>

                         </div>

controller

              public function refercancellbill_credit($bill_number)
            {
                //
               $team=Auth::user()->team_id;
               $editbillinfo=Sales::with('deviceNumb')->where('bill_number',$bill_number)->first();

               $countslave=Sales::select(DB::raw('COUNT(slave_id )   as totalslave'))->where('bill_number',$bill_number)->first();
               
                $bill = DB::table('sales')->WHERE("sales.bill_number", $bill_number)->first();


               

            
                $Slave=DB::table('my_stocks')->leftjoin('devices', 'devices.id','=','my_stocks.unit_id')->where('my_stocks.status',0)

                  ->where('devices.devicetype',2)
                   ->pluck('Devicenumber','unit_id');

                   $master=DB::table('my_stocks')->leftjoin('devices', 'devices.id','=','my_stocks.unit_id')->where('my_stocks.status',0)

                  ->where('devices.devicetype',1)
                   ->pluck('Devicenumber','unit_id');

           return view('sales.referbillcredit',compact('editbillinfo','bill','master','Location','Slave','countslave'));

}

it display the new instead of old value which is found in database

i want to display and have the new one to change it

Activity icon

Started a new Conversation Htmlspecialchars() Expects Parameter 1 To Be String, Object Given

I tried to create my edit form and update the data when i want to display the value am get this error in my edit form

My controller

         public function refercancellbill_credit($bill_number)
            {
                //
               $team=Auth::user()->team_id;
               $editbillinfo=Sales::with('deviceNumb')->where('bill_number',$bill_number)->first();


                $Location=Location::pluck('Lname','id');
                $Slave=DB::table('my_stocks')->leftjoin('devices', 'devices.id','=','my_stocks.unit_id')->where('my_stocks.status',0)->get();
               
            
                $customer_name=Customer::pluck('compy_name','id');

                return view('sales.referbillcredit',compact('editbillinfo','customer_name','Location','Slave','countslave'));
            }

My blade view

               	<div id=""  class="form-group col-md-4">
                        		<div class="input-group">
                        		<span class="input-group-addon">{{$editbillinfo->deviceNumb->Devicenumber}}</span>
                        			<select name="unit_id" class=" form-control js-example-basic-single" data-live-search="true"  >

                        					@foreach($Slave as $key=>$dt)
                        					@if($dt->devicetype ==1)
                        			    <option value="{{$key}}" @if($key == $editbillinfo->unit_issue_id) selected @endif>{{$dt}}</option>
                        				@endif
                        				@endforeach

                        			</select>
                        		</div>
                        </div>

                        
                        	<div   class="form-group col-md-4">
                        		<div class="input-group">
                        		<span class="input-group-addon"></span>
                        			<select  name="slave_ID[]" class=" form-control js-example-basic-single">
                                        <option value="">[SELECT SLAVE]</option>
                        			
                        					@foreach($Slave as $key=>$dt)
                        					@if($dt->devicetype ==2)
                                             <option value="{{$key}}" @if($key == $bill->slave_id) selected @endif></option>

                        				@endif
                        				@endforeach

                        			</select>
                        		</div>
                        </div>

Kindly assist me where i did wrong

Jan
25
1 month ago
Activity icon

Replied to Laravel Redirect With Post Method

@automica , i need to get the alert on the same route to show successfully

Activity icon

Replied to Laravel Redirect With Post Method

the button

                         <td> <button class="btn  btn-succes audit" data-id="{{$dt->bill_number}}">AUDIT BILL</button></td>



          $(document).ready(function(){
    $(".audit").click(function (e) {
      var bill_number = $(this).data("id");

       if(!confirm("Do you really want to Audit this?")) {
                   return false;

                 }

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

        $.ajax({
            url: "/audit_bill/"+bill_number,
            type: "POST",

             data:{bill_number:bill_number,
               token:token,
                },
            dataType: "json",
            success: function (data) {
                console.log('SUCCESS: ', data);
                // location.reload();
                return false;
            },
            error: function (data) {
                console.log("ERROR: ", data);
                // location.reload();
                return false;
            },
        });
    });
     });
Activity icon

Started a new Conversation Laravel Redirect With Post Method

i have the route which fetch the data when i send the request,

with that data in the blade view i have the button to select the ID and update

it update well but am get this error

          The GET method is not supported for this route. Supported methods: POST

In my web

       //fetch data 
   Route::post('sales_reports_by_team','[email protected]')->name('reports.team');

  //select bill_number and update the status=1
 Route::post('/audit_bill/{bill_number}','[email protected]')->name('audit.bill');

My controller

             public function auditbillnumber(Request $request,$bill_number)
           {
 

            DB::table('sales')->where('sales.bill_number', $bill_number)->update(['audit_status'=>1]);
           return redirect()->back()->with('alert','Bill has been updated Successfully');

            }
Jan
21
1 month ago
Activity icon

Replied to Avoid Duplication

i was tried this sir but still the same i don't know where i did wrong when i using firstOrCreate

Activity icon

Replied to Avoid Duplication

yes your correct @michaloravec , how can i avoid that bill_number to increment with the same request

because we will have many duplicate data

Activity icon

Replied to Avoid Duplication

@michaloravec , it create data well, but when i refresh the browser it create new request with new bill_number, and the same request

Activity icon

Replied to Avoid Duplication

if you want to see in my pc this is anydesk id 123 594 911 to connect

Activity icon

Replied to Avoid Duplication

@michaloravec

                 public function store(Request $request)
              {

          $now = now();
          $bill_no = DB::table('sales')
              ->selectRaw('max(right(bill_number, 4)) as bill_no')
              ->whereDate('updated_at', $now->format('Y-m-d'))
              ->value('bill_no');

          foreach (Arr::wrap($request->slave_ID ?? 'no_slave_id') as $value) {
              Sales::create($request->only([
                  'customer_agent', 'payment_method', 'borderName', 'tag_area', 
                  'cargo_type', 'chasisNo', 'ITNo', 'driverName', 'License', 
                  'driverPhone', 'subT1', 'TruckNo', 'amount', 'discount', 
                  'sale_type', 'currency'
              ]) + [
                  'bill_number' => $bill_number = "E{$now->format('dmy')}".Str::padLeft($bill_no, 4, '0'),
                  'user_id' => Auth::user()->id,
                  'tag_id' => Auth::user()->team_id,
                  'unit_issue_id' => $request->unit_id,
                  'TrailerNo' => $request->trailerNo,
                  'container_no' => $request->containerNo,
                  'comments' => $request->comment,
                  'created_at' => $request->backdate ?? now()->format('Y-m-d H:i:s'),
                  'slave_id' => $value == 'no_slave_id' ? null : $value
              ]);
          }


                    Mystock::where('unit_id',$request->unit_id)
                                          ->update([
                                                "status"=>1,
                                          ]);

                if($request->slave_ID){


                          Mystock::whereIn('unit_id',$request->slave_ID)
                                          ->update([
                                                "status"=>1,
                                          ]);
                }
                
                          
          return $this->print_sales_bill_cash($bill_number); //here to h..


              }
Activity icon

Replied to Avoid Duplication

Oky thanks and how can i use in public function?

Do you think can not duplicate

Activity icon

Replied to Avoid Duplication

@michaloravec

Yes i changed, but the it duplicate the slave_id and the bill_no does not increment

Bill is the same but slaveId is duplicated, but if i there is not slaveId it does not duplicate unit_id

Activity icon

Replied to Avoid Duplication

ok seen, but

        Call to a member function value() on array

on this

         $bill_no = (int) DB::select("SELECT max(right(bill_number, 4)) as bill_no from sales WHERE date(updated_at) = '{$now->format('Y-m-d')}'")->value('bill_no') + 1;
Activity icon

Replied to Avoid Duplication

am get this error

     Trying to get property 'bill_no' of non-object

on this line 'bill_number' => $bill_number = "E{$now->format('dmy')}".Str::padLeft((int) $no->bill_no + 1, 4, '0'),

Activity icon

Replied to Avoid Duplication

Both, if test with slave it duplicate and if i did attached slave it duplicate when i refresh the page

Activity icon

Replied to Avoid Duplication

From here am checks if the request has slave_ID then it will save with slave_id

And if not it will save on slave_id as null

That is my logic

Activity icon

Replied to Avoid Duplication

my request is created well with this code good

    array:22 [▼
          "_token" => "eMicRSunxukf6D5as37h43Impw4mwNqBFF76Ls7D"
          "unit_id" => "6"
          "sale_type" => "1"
          "backdate" => null
          "customer_agent" => "ABCG"
          "payment_method" => "1"
          "currency" => "1"
          "amount" => "70"
          "discount" => "7"
          "tag_area" => "DEPOT DALBIT"
          "borderName" => "1"
          "cargo_type" => "2"
          "TruckNo" => "T678 TTY"
          "trailerNo" => "T 566 ABD"
          "chasisNo" => null
          "ITNo" => null
          "container_no" => "TTGHBRT6564"
          "driverName" => "FEKRR"
          "License" => "4000231136"
          "driverPhone" => "0754262956"
          "subT1" => "TZS466676767"
          "comment" => "OK"
          ]

when i refresh the page the same data is created again with new bill_number

i tested the changes of bill_number but it created the same.

this bill_number has the same data when i refresh it

    E2101217422
    E2101217425
Activity icon

Replied to Avoid Duplication

ok @tray2 , so the code will be like this?

           $no = DB::select("SELECT max(right(bill_number,4)) as bill_no from sales WHERE date(updated_at)='$tgl'");
            foreach ($no as $idnx) {
                $noo = (int) $idnx->bill_no;
            }

            $tambah = $noo + 1;
    $bill_number = 'E' . Carbon::now()->format('dmy') . str_pad($tambah, 4, '0', STR_PAD_LEFT);
Activity icon

Replied to Avoid Duplication

@tray2 i tested it still duplicate,

the problem here is bill_number after save the data, when i refresh the page, its takes the same and save as new data with new bill_number

I think that the billnumber is create as new because it check the last and create new one as the same data

Activity icon

Replied to Avoid Duplication

@tray2, ok let me test it

Activity icon

Replied to Avoid Duplication

@tray2, this $data or $date ?

Check this line

    $date['slave_id'] =$request->slave_ID[$key],
    Sales::create($data);
Jan
20
1 month ago
Activity icon

Replied to Avoid Duplication

Am using switch

switch(true) { case $tambah < 10: $bill_number = "E" . Carbon::now()->format('dmy') . "000" . $tambah; break; case $tambah < 100: $bill_number = "E" . Carbon::now()->format('dmy') . "00" . $tambah; break; case $tambah < 1000: $bill_number = "E" . Carbon::now()->format('dmy') . "0" . $tambah; break; case $tambah < 10000: $bill_number = "E" . Carbon::now()->format('dmy') . $tambah; break; default: $bill_number = 'severe'; break; }

Activity icon

Replied to Avoid Duplication

@prasadchinwal5

i want try like this

                    $date = $request->filled('backdate') ? request('backdate') : Carbon::now()->format('Y-m-d H:i:s');
               // if($request->filled('backdate')) {
               //                $date = request('backdate');
               //            } else {
               //                $date = Carbon::now()->format('Y-m-d H:i:s');
               //            }
              if ($request->slave_ID) {
                         foreach ($request->slave_ID as $key => $value) {
                          Sales::updateOrCreate(
                            ['bill_number'       =>     $bill_number,'customer_agent'      =>    $request->customer_agent],
                            ['tag_id'      =>    Auth::user()->team_id ],[
                         'bill_number'       =>     $bill_number,
                         'user_id'     =>    Auth::user()->id,
                          'unit_issue_id'     =>    $request->unit_id,
                          'payment_method'      =>    $request->payment_method,
                          'borderName'      =>    $request->borderName,
                          'tag_area'      =>    $request->tag_area,
                          'cargo_type'      =>    $request->cargo_type,
                          'chasisNo'      =>    $request->chasisNo,
                          'ITNo'      =>    $request->ITNo,
                          'driverName'      =>    $request->driverName,
                          'License'     =>    $request->License,
                          'driverPhone'     =>    $request->driverPhone,
                          'subT1'     =>    $request->subT1,
                          'TruckNo'     =>    $request->TruckNo,
                          'TrailerNo'     =>    $request->trailerNo,
                          'container_no'      =>    $request->containerNo,
                          'comments'      =>    $request->comment,
                          'amount'      =>    $request->amount,
                          'discount'      =>    $request->discount,
                          'sale_type'     =>    $request->sale_type,
                          'currency'      =>    $request->currency,
                           'created_at'=>$date,
                           'slave_id'=>$request->slave_ID[$key],
                            
                        ]);              // Sales::create($data); 
              }

              }else{

                Sales::updateOrCreate(
                            ['bill_number'       =>     $bill_number,'customer_agent'      =>    $request->customer_agent],
                            ['tag_id'      =>    Auth::user()->team_id ],[
                          // 'tag_id'      =>    Auth::user()->team_id,
                         

                          'unit_issue_id'     =>    $request->unit_id,
                          // 'customer_agent'      =>    $request->customer_agent,
                          'payment_method'      =>    $request->payment_method,
                          'borderName'      =>    $request->borderName,
                          'tag_area'      =>    $request->tag_area,
                          'cargo_type'      =>    $request->cargo_type,
                          'chasisNo'      =>    $request->chasisNo,
                          'ITNo'      =>    $request->ITNo,
                          'driverName'      =>    $request->driverName,
                          'License'     =>    $request->License,
                          'driverPhone'     =>    $request->driverPhone,
                          'subT1'     =>    $request->subT1,
                          'TruckNo'     =>    $request->TruckNo,
                          'TrailerNo'     =>    $request->trailerNo,
                          'container_no'      =>    $request->containerNo,
                          'comments'      =>    $request->comment,
                          'amount'      =>    $request->amount,
                          'discount'      =>    $request->discount,
                          'sale_type'     =>    $request->sale_type,
                          'currency'      =>    $request->currency,
                           'created_at'=>$date,

                          'slave_id'=> ($request->has('slave_ID') && count($request->slave_ID) > 0)? count($request->slave_ID) : null,
                        ]);


                 

                             // Sales::create($data2); 
              }

am get this error

             Trying to get property 'bill_number' of non-object
Activity icon

Replied to Avoid Duplication

@ankush981

how can be in my code, kindly can you help on that

Activity icon

Replied to Avoid Duplication

Oky let me try,

And how about create($data) to avoid duplicate

Can i use this bill_number as to check and updateOrCreate

Help me on this @prasadchinwal5

Jan
19
1 month ago
Activity icon

Replied to Avoid Duplication

@prasadchinwal5 ,

how can i write switch there?

and how can i avoid that duplication because am using bill_number as unique

Jan
17
1 month ago
Activity icon

Started a new Conversation Avoid Duplication

Hello ,

How can i avoid duplication here?

            $tgl = Carbon::now()->format('Y-m-d');
                $no = DB::select("SELECT max(right(bill_number,4)) as bill_no from sales WHERE date(updated_at)='$tgl'");
                foreach ($no as $idnx) {
                    $noo = (int) $idnx->bill_no;
                }

                $tambah = $noo + 1;

                if ($tambah < 10) {
                    $bill_number = "E" . Carbon::now()->format('dmy') . "000" . $tambah;
                } else if ($tambah < 100) {
                    $bill_number = "E" . Carbon::now()->format('dmy') . "00" . $tambah;
                } else if ($tambah < 1000) {
                    $bill_number = "E" . Carbon::now()->format('dmy') . "0" . $tambah;
                } else if ($tambah < 10000) {
                    $bill_number = "E" . Carbon::now()->format('dmy') . $tambah;
                }



               if($request->filled('backdate')) {
                              $date = request('backdate');
                          } else {
                              $date = Carbon::now()->format('Y-m-d H:i:s');
                          }
              if ($request->slave_ID) {
                         foreach ($request->slave_ID as $key => $value) {
                      $data =[

                          'bill_number'       =>     $bill_number,
                          'user_id'     =>    Auth::user()->id,
                          'tag_id'      =>    Auth::user()->team_id,
                          'unit_issue_id'     =>    $request->unit_id,
                          'customer_agent'      =>    $request->customer_agent,
                          'payment_method'      =>    $request->payment_method,
                          'borderName'      =>    $request->borderName,
                          'tag_area'      =>    $request->tag_area,
                          'cargo_type'      =>    $request->cargo_type,
                          'chasisNo'      =>    $request->chasisNo,
                          'ITNo'      =>    $request->ITNo,
                          'driverName'      =>    $request->driverName,
                          'License'     =>    $request->License,
                          'driverPhone'     =>    $request->driverPhone,
                          'subT1'     =>    $request->subT1,
                          'TruckNo'     =>    $request->TruckNo,
                          'TrailerNo'     =>    $request->trailerNo,
                          'container_no'      =>    $request->containerNo,
                          'comments'      =>    $request->comment,
                          'amount'      =>    $request->amount,
                          'discount'      =>    $request->discount,
                          'sale_type'     =>    $request->sale_type,
                          'currency'      =>    $request->currency,
                           'created_at'=>$date,
                           'slave_id'=>$request->slave_ID[$key],
                            
                        ];


                 

                             Sales::create($data); 
              }

              }else{


                        $data2 =[

                          'bill_number'       =>     $bill_number,
                          'user_id'     =>    Auth::user()->id,
                          'tag_id'      =>    Auth::user()->team_id,
                          'unit_issue_id'     =>    $request->unit_id,
                          'customer_agent'      =>    $request->customer_agent,
                          'payment_method'      =>    $request->payment_method,
                          'borderName'      =>    $request->borderName,
                          'tag_area'      =>    $request->tag_area,
                          'cargo_type'      =>    $request->cargo_type,
                          'chasisNo'      =>    $request->chasisNo,
                          'ITNo'      =>    $request->ITNo,
                          'driverName'      =>    $request->driverName,
                          'License'     =>    $request->License,
                          'driverPhone'     =>    $request->driverPhone,
                          'subT1'     =>    $request->subT1,
                          'TruckNo'     =>    $request->TruckNo,
                          'TrailerNo'     =>    $request->trailerNo,
                          'container_no'      =>    $request->containerNo,
                          'comments'      =>    $request->comment,
                          'amount'      =>    $request->amount,
                          'discount'      =>    $request->discount,
                          'sale_type'     =>    $request->sale_type,
                          'currency'      =>    $request->currency,
                           'created_at'=>$date,

                          'slave_id'=> ($request->has('slave_ID') && count($request->slave_ID) > 0)? count($request->slave_ID) : null,
                        ];


                 

                             Sales::create($data2); 
              }
          return $this->print_sales_bill_cash($bill_number);
  

My code is works file to create but when i refresh the page it duplicate the data with new bil_number

Activity icon

Replied to Count Days From Created_at In The Blade View

am set like this

                  <?php $now = Carbon::now();?>

              @foreach($iddleintransit as $key=>$dt)
            <?php $days_count = $dt->created_at_sale->diffInDays($now); ?> 

              <tr>
                 <td>{{++$key}}</td>
                 <td>{{$dt->bill_number}}</td>
                 <td>{{$dt->Devicenumber}}</td>
                 <td>[{{$dt->totalslave}}]={{$dt->slavename}}</td>
                 <td>{{$dt->Lname}}</td>
                 <td>{{$dt->created_at_sale}}</td>
                 <td>$days_count</td>
               
              </tr>
              @endforeach

am get this error

          Class 'Carbon' not found
Activity icon

Started a new Conversation Count Days From Created_at In The Blade View

i want to count the day/ to show the date from created_date

this is my blade

          <td>{{$dt->created_at_sale}}</td> //	2021-01-14 12:32:22

so i want to count that date till now is how many days

How can i do here

Jan
12
1 month ago
Activity icon

Replied to Count In Collection

yes, how can i get the result like that

Activity icon

Replied to Count In Collection

@tray2

I have the sql query like this but return

               $data=DB::select(
                  DB::raw("SELECT
                (select count(*) from devices where devices.id=issue_to_sales.unit_id and devicetype=1) as master,
                (select count(*) from devices where devices.id=issue_to_sales.unit_id and devicetype=2) as slave
                FROM issue_to_sales where issue_no='$issue_no'"));

dd()

          array:3 [▼
          0 => {#1454 ▼
            +"master": 1
            +"slave": 0
          }
          1 => {#1451 ▼
            +"master": 0
            +"slave": 1
          }
          2 => {#1447 ▼
            +"master": 1
            +"slave": 0
          }
        ]
Activity icon

Started a new Conversation Count In Collection

My query does not count correect, in the device table i have column devicetype which differentiate unit_id

so i want to count unit_id from issue_to_sale table so in this issue_no=IBCH2112200002 it contain slave=1 and master=2 but on the dd(data1) return wrong

result after dd()

         #items: array:1 [▼
0 => {#1479 ▼
  +"issue_no": "IBCH2112200002"
  +"team_name": "TEAM IT"
  +"req_by": "Innocent Lema"
  +"TotalALL": 3
  +"master": 3
  +"slave": null
}

]

my controller

       $data1=DB::table('issue_to_sales')
                                        ->SELECT('issue_no','teams.team_name as team_name','users.name as req_by',DB::raw('count(unit_id) as TotalALL'),DB::raw('(select count(unit_id) from devices where devices.id=issue_to_sales.unit_id and devicetype=1) as master'),DB::raw('(select count(unit_id) from devices where devices.id=issue_to_sales.unit_id and devicetype=2) as slave'))
                                        ->leftJoin("teams", "teams.id","=","issue_to_sales.team_id")
                                        ->leftJoin("users", "users.id","=","issue_to_sales.req_by")
                                        ->leftJoin("devices", "devices.id","=","issue_to_sales.unit_id")
                                           ->where('issue_no',$issue_no)
                                              ->groupBy('issue_no')
                                           ->get();

how can get this result

          +"issue_no": "IBCH2112200002"
  +"team_name": "TEAM IT"
  +"req_by": "Innocent Lema"
  +"TotalALL": 3
  +"master": 2
  +"slave": 1
Jan
11
1 month ago
Activity icon

Replied to How To Avoid Duplicates Entry

yes,it works now i was forget to add user_id to model thanks

Activity icon

Replied to How To Avoid Duplicates Entry

sorry both are return $userId=Auth::user()->id; = 7 ,

               dd($request->user()->id); = 7