Conditionally sorting for an even distribution of records

See also questions close to this topic

• web app to mobile app using react native?

  im trying to develope a delivery web application with bootstrap in frontend side and laravel in backend side. at last i must have a mobile app for ios and android . its not a complicated program . can I do it using react native?
• How to define name for slug?

  Look at my codes.

  web.php

  Route::get('/{pageSlug}', 'PageController@about')->name('about');
  

  RouteServiceProvider.php

  public function boot()
  {
      Route::bind('pageSlug', function ($value) {
          return Page::whereSlug($value)->firstOrFail();
      });
      parent::boot();
  }
  

  blade

  <a class="nav-link" href="{{ route('about') }}">About</a>
  

  I see this error

  Missing required parameters for [Route: about] [URI: pageSlug}]. (View: C:\xampp3\htdocs\projects\resources\views\Home\layouts\header.blade.
• How to show date-time in laravel field?

  Technology - Laravel8 How can I show value date-time in field?

  I tried to do this in this way, but it wasn't successfull.

  {!! Form::input('datetime-local', 'startdatetime', $auction->startdatetime, array('class' => 'form-control')) !!}

  Example on value of ($auction->startdatetime) => "2021-01-24 08:00:00"
• How to sort Dictionary with Vector3 keys?

  

  I am recreating a edge-link system from the game "Rimworld".

  The purple squares are individual squares that need to form "links", in the direction the arrows are drawn in, with that exact length.

  Currently, I don't know how to do this better than by placing all of those squares in a dictionary where I mark a square's position and its direction (which can be UP or RIGHT), like this:

  Dictionary<Vector3Int, bool> linkSquares;

  I want to sort this dictionary so that the KV pairs that come first are the ones where the Vector3Int.x is lowest and then where the Vector3Int.y is lowest.

  That way, I could always start at those squares (marked with numbers 1-4 on the picture) and go in the appropriate arrow direction, removing those squares as I go, which would only leave other starting squares.

  I've read that dictionaries can't be sorted, but I don't know how I would use a SortedDictionary for this case. This whole system seems overly dirty but I don't know how else I would achieve my goal here, so any design change suggestions are highly appreciated.
• Laravel collections order and sort works locally but not on server

  I’ve 2 collections in which first one has order by receipt number and merged this with transactions collection. And applied sortBy transaction date for the whole new collection. This works perfectly in my local but doesn’t work in prod server. Anyone ideas please?

  $payments = [];
  $transactions = Transaction::whereBetween('transaction_date', $date_range)
      ->forBranch($this->user->branch);
  if ($transaction_type != 'both') {
      $transactions->where('transaction_type', $transaction_type);
  }
  if ($transaction_type != 'expense') {
      $payments = StudentPayment::whereBetween('receipt_date', $date_range)
          ->forBranch($this->user->branch)
          ->orderBy('receipt_number')
          ->get()
          ->map(function ($payment) {
              return [
                  'id'                => $payment->id,
                  'transaction_type'  => 'income',
                  'amount'            => $payment->paid_amount,
                  'purpose'           => 'Receipt #' . $payment->receipt_number,
                  'transaction_date'  => $payment->receipt_date,
                  'tag'               => 'all'
              ];
          });
  }
  $transactions = collect($payments)
      ->merge(collect($transactions->get()))
      ->sortBy('transaction_date')      // If I remove this, it sorts perfectly in server also but I need to sort by transaction date
      ->values();
  
• How to add up repetitive values from input in C?

  i'm kinda new to C. i am trying to make a shopping cart application program that reads data from a txt file that contains a product and a price, seperated by whitespace. Then in a new line another product is put and a price(also seperated by whitespace). then outputs the bill in another "bill.txt" text file. example:

  input taken from file (products.txt):

  Bread 2.78
  cheese 4.59
  vegetables 1.99
  bread 1.99
  Milk 0.56
  cheese 2.79
  

  output written in another file(bill.txt):

  bread : 4.77 , 2 products, average-price: 2.38
  cheese: 7.38 , 2 products, average-price: 3.69
  milk: 0.56 , 1 products, average-price: 0.56
  vegetables: 1.99 , 1 products, average-price: 1.99
  total : 14.70
  

  my main problem is that i am confused about how to add up the sum of the repetitive products like bread from the text file and add them as a quantity instead! The bread is written twice in input but a qty of 2 is written instead.

  usually in a language like java i would have used an ArrayList and solved it easily, but since C doesn't have Arraylists, what to do?

  here is my code:

   #include <stdio.h>
  #include <stdlib.h>
  
  int count;
  struct Product
  {
      char productName[30];
      double price;
  };
  
   struct Product p1;
  
  int main()
  {
      double total = 0;
  
      //input file
       FILE *fp;
      fp = fopen("products.txt","r");
      //output file
      FILE *fp1 = fopen("bill.txt","w");
      if (fp == NULL || fp1 ==NULL)
      {
          perror("files didn't open");
      }
      printf("this input was written in file:\n");
      while(1)
      {
          fscanf(fp,"%s %d",&p1.productName,&p1.price);
          total = total + p1.price;
          fprintf(fp1,"%s:\t%d,  \n",p1.productName,p1.price);
          printf("%s:\t%d,  \n",p1.productName,p1.price);
          if (feof(fp))
          {
              fprintf(fp1,"Total: %d",total);
              break;
          }
  }
  printf("total: %d", total);
  return 0;
  }
  

  Any ideas?
• How to group retrieved rows by months?

  I working on an app that involves grouping selected rows by month. How do I go about it?

    $data = Medicals::where("patient_referral.referred_by", "like", "%" .  $searchitem . "%")
          ->leftJoin("patients", "medicals.patients_id", "=", "patients.id")
          ->join("patient_referral", "medicals.trx_id", "=", "patient_referral.trx_id")
          ->join("tests", "medicals.tests_id", "=", "tests.id")
          ->groupBy(function (Medicals $item) {
              return $item->created_at->format('Y-m');
          })
          ->get();
  

  This is the error am getting

  ErrorException stripos() expects parameter 1 to be string, object given
• Laravel 8.X select all record with latest status

  I have 2 model in relationship

  Tickets model

  public function status(){ return $this->hasMany(Status::class); }
  public function latestStatus(){ return $this->hasOne(Status::class)->latest();}
  

  Status model

  public function tickets(){ $this->belongsTo(Ticket::class);}
  

  I am trying to get the latest status of each tickets using this code

  public function scopeFilteredStatus($query){ 
   return $query->whereHas('latestStatus',function($status){ 
    $status->whereIn('status', ['status1,'status3','status6']);
  })->get(); }
  

  what ive got

  Illuminate\Database\Eloquent\Collection {#1609 ▼
    #items: array:302 [▶]
  }
  

  was expecting a fewer result

  id --- user_id --- ticket_id --- status --- created_at
  xx --- 10001   --- 3100      --- status1 --- 2020-01-13
  xx --- 10001   --- 3200      --- status3 --- 2020-01-09
  xx --- 10004   --- 2900      --- status6 --- 2020-01-20
  and more...
  
• errno: 150 "Foreign key constraint is incorrectly formed - Laravel 8

  Hola comunidad estoy intentando hacer la relación a nivel de base de datos y según la documentación de Laravel 8 tengo que agregarle la clave foranea, pero sin embargo me da error de clave mal formada, ¿cual sería mi error?:

  Schema::create('educactions', function (Blueprint $table) {
              $table->id();
              $table->string('institution');
              $table->string('comment');
              $table->unsignedBigInteger('cities_id');
              $table->foreign('cities_id')->references('id')->on('cities');
              $table->timestamps();
          });
  
  Schema::create('cities', function (Blueprint $table) {
              $table->id();
              $table->string('description');
              $table->timestamps();
          });
  

  También le agregué la relaciones en los modelos:

  // En el modelo City
      public function educations(){
          return $this->hasMany(Education::class);
       }
  
  //En el modelo Education
      public function city(){
          return $this->belongTo(City::class);
      }
  

  Detalle del error:

  SQLSTATE[HY000]: General error: 1005 Can't create table db_XXXX.educactions (errno: 150 "Foreign key constraint is incorrectly formed") (SQL: alter table educactions add constraint educactions_cities_id_foreign foreign key (cities_id) references cities (id))

  Tendría que poner el nombres de la tabla en singular o como podría solucionarlo
• automatic login from controller in laravel 8

  I need to make login exactly as laravel Auth Facades does in the following way. I will have some url say "HOST/makeLogin?someToken=xxtrypturan";

  Now in controller I have a function as follow:

      $creatorOfTheShop = $user->find($request->get('someToken')); //this will give user from db
      Auth::login($creatorOfTheShop);
  

  Now I want this login to create web session as laravel does in default login. How can I do so, so that I can use auth guards in routes. I wont have any login page, so I am adopting this approach. Thanks
• Laravel 8.x - Cache query using with() method

  1) A simple code that I use to cache an expensive query is something like:

  $query = User::where('id', '=', 3);
  $cacheKey = md5($query->toSql()); // It is: "SELECT * FROM users WHERE id=3;"
  $users = Cache::remember($cacheKey, 120, function () use ($query) {
          return $query->get();
      });
  

  the query executed is:

  SELECT * FROM users WHERE id=3;
  

  2) Now, when I use the with() method, the code will be:

  $query = User::with('car')->where('id', '=', 3);
  $cacheKey = md5($query->toSql()); // It is ALWAYS: "SELECT * FROM users WHERE id=3;"
  $users = Cache::remember($cacheKey, 120, function () use ($query) {
          return $query->get();
      });
  

  the query executed are:

  SELECT * FROM users WHERE id=3;
  SELECT * FROM cars where cars.id in (1, 2, 3, 4, 5, ...);
  

  The problem is that the $cacheKey (equal to: $query->toSql()) doesn't consider the all the Eager Loading queries... and when the with() changes, the output is the same.

  For example, If I run:

  $query = User::with('bike')->where('id', '=', 3);
  $cacheKey = md5($query->toSql()); // It is ALWAYS: "SELECT * FROM users WHERE id=3;"
  $users = Cache::remember($cacheKey, 120, function () use ($query) {
          return $query->get();
      });
  

  the cache exists and return a incorrect output.

  What is the best practice to cache quark using with() method?

  Thank you,
• credentials do not match our records

  I am currently working on POS in laravel 8. I am having an error when I login in that "credentials do not match our records" When I login in through the default Register page than it works fine but when I register through internal panel than the data goes to the database but I face error when I log in.

          code for registration through panel:
          public function store(Request $request)
          {
           $users = new User;
           $users->name = $request->name;
           $users->email = $request->email;
           $users->password =  Hash::make($request->name);
           // $users->password =  bcrypt($request->name);
  
           $users->is_admin = $request->is_admin;
           $users->save();
  
  
           if($users){
           return redirect()->back()->with('User Created Successfully');
           }
           return redirect()->back()->with('User Failed Created');
            }
  
  
        default register code:
         protected function create(array $data)
          {
          return User::create([
            'name' => $data['name'],
            'email' => $data['email'],
            'password' => Hash::make($data['password']),
               ]);
              }