Returning multiple models to view

See also questions close to this topic

• PHP 2 Select Option Always Sync with table row in database

  I have 2 SelectOption where if Select 1 is selected, then Select 2 automatically synchronizes with Select 1

  all SelectOptions contents retrieve from a database table.

  SELECT 1 & 2 scripts:

  <select  name="leavetype" autocomplete="off">
  <option value="">Choose Leave Type</option>
  <?php $sql = "SELECT LeaveType from tblleavetype";
  $query = $dbh -> prepare($sql);
  $query->execute();
  $results=$query->fetchAll(PDO::FETCH_OBJ);
  $cnt=1;
  if($query->rowCount() > 0)
  {
  foreach($results as $result)
  {   ?>                                            
  <option value="<?php echo htmlentities($result->LeaveType);?>"><?php echo htmlentities($result->LeaveType);?></option>
  <?php }} ?>
  </select>
  
  
  <select  name="rightsgranted" autocomplete="off">
  <option value="">Rights Granted</option>
  <?php $sql = "SELECT RightsGranted from tblleavetype";
  $query = $dbh -> prepare($sql);
  $query->execute();
  $results=$query->fetchAll(PDO::FETCH_OBJ);
  $cnt=1;
  if($query->rowCount() > 0)
  {
  foreach($results as $result)
  {   ?>                                            
  <option value="<?php echo htmlentities($result->RightsGranted);?>"><?php echo htmlentities($result->RightsGranted);?></option>
  <?php }} ?>
  </select>

  example
• Javascript function only works when called within page

  I use this script to hide a infobox when the user clicks outside of it:

  var box = document.getElementById("el_ntf-ib");
  document.addEventListener("click", function(event) {
      if (event.target.closest("#el_ntf-ib") || event.target.closest("#earthSpinner")) return;
      box.style.display = "none";
  });
  

  #el_ntf-ib is the infobox and #earthSpinner is the button that displays the infobox.

  My page consists of blocks that are included using PHP:

  require "p_hdr/sp_lg.php"; // a block
  require "p_hdr/sp_srch.php"; // another block.
  require "p_hdr/sp_usr-mn.php"; // a third block. Crazy.
  

  This means the code of my page is spread around different folders (and paths).

  Issue: If I call my JS script in the head section of my page, it doesn't work. If I want it to work, I have to put it directly inside my HTML code, using the script tags:

  <script type="text/javascript">
  var box = document.getElementById("el_ntf-ib");
  document.addEventListener("click", function(event) {
      if (event.target.closest("#el_ntf-ib") || event.target.closest("#earthSpinner")) return;
      box.style.display = "none";
  });
  </script>
  

  I'd really want my JS scripts to work without having to put them directly in my HTML code; it's cleaner that way.

  Questions:

  1. Does the position (either at the beginning or the end of a document) of a JS script matter?
  2. Why does this happen?
  3. How do I fix it?
• php mysql Query result with %Like%

  I am stuck with the query result and need help plz.

  My sample column How are you what is your name where are you from whats the age of the youth

  Now this is my column in Table and I query the below

    $search='you';
    $s=mysqli_query($con,"Select * from tblxyz where column1 is LIKE '%{$key}%'");
  

  I am getting the result of all the 4 rows as there is "you" in all, But I would like to get the result of the exact word which SQL searched, so the result from the 4th row would be "youth". How to get those words which SQL found based on my query.

  Thanks in Advance
• Sharing CSRF token between subdomains

  I have set up CORS correctly and set the session domain as .example.com But still when I make an ajax request from www.example.com to app.example.com it throws token mismatch exception. Any help is much apreciated.

  NB:

  My session domain: .example.com

  cors allowedOrigins set to [*]

  cors allowedMethods set to [*]

  cors allowedHeaders set to [*]
• How can I use soft deleted with relation

  I use eloquent with soft delete .I'm getting error because of my query still select data that already use softdelete here is my model

  User Model

  class User extends Authenticatable
  {
      use Notifiable, HasRoles, SoftDeletes;
      protected $guard_name = 'web';
      protected $fillable = [
          'username', 'password'
      ];
      protected $dates = ['deleted_at'];
  
  }
  

  for example I've 100 user and I deleted 1 user with softdelete . then I try to

  $a = User::all();
  dd($a);
  

  I get 99 user . It works! but after I use it relation It doest work here what I do

  This is my Parent table and Model

  table

   |id|user_id|parent_id|
  

  Note : user_id and parent_id are FK in user.id table

  class Parent extends Model
  {
      protected $table = 'parent';
      public function user()
      {
          return $this->belongsTo('App\User');
      }
  
  }
  
  
  $getParent = Parent::with('user')->get();
  

  when I dd($getParent); why I still get null data from user_id that I already use soft deleted ?

  UPDATE model User : after I put whereNull I still getting user that I alredy soft deleted

  public function user()
  {
      return $this->belongsTo('App\User')->whereNull('users.deleted_at');
  }
  
• Add extra column as a marker in laravel datatable

  What I want to do is to select the record from database based on two conditions, the first condition is to select all of the records that has reached 30 days today, and the second one is the records that has reached 25 days today based on the date field of the records. And for each condition I want to add a column (status) for marking the result. I want the result to be like this:

  +--+--------------------+-------------------+-------------------+
  |No|        Date        |       Name        |       Status      |
  +--+--------------------+-------------------+-------------------+
  |1 |     2018-10-17     |       John        |       30 days     |
  |2 |     2018-10-22     |      Daniel       |       25 days     |
  +--+--------------------+-------------------+-------------------+
  

  This is my query:

  $data       = DB::table('data_pemohon')->select('*')->whereRaw('tanggal_permohonan + INTERVAL 30 DAY <= NOW()')->orWhereRaw('tanggal_permohonan + INTERVAL 25 DAY <= NOW()')->where('status_paspor','Serahkan paspor')->get();
  return Datatables::of($data)->addIndexColumn()->make(true);
  

  How can I do that, help me guys, thanks.
• Axios request giving getter setter methods instead of data queried

  I'm working with Laravel and Vue to make a single page web application. I've used Vue before to get the data from a database using a controller with no problem, but for some reason I'm now only getting a seemingly infinitely nested JS object that has getter and setter methods stored in each parent object instead of the data I queried. I've seen other people with similar issues, but the solutions that worked for them didn't work for me. For example, some people used JSON.parse(JSON.stringify(response.data)); to get just the raw data, but this doesn't work when I attempt to store it in this.actions. Here is my index method in my ActionLogController

  public function index($url)
  {
  
      $companyName = explode("/", $url);
  
      if(Auth::check())
      {
          $company = Company::where('name', '=', strtolower($companyName[count($companyName) - 1]))->first();
  
          // If sortby not empty
          $sortby = "created_at";
  
          //assume desc (most recent)
          $sortdirection = 'desc';
  
          if(request()->has('sortdirection') && request()->sortdirection == 'asc')
          {
              $sortdirection = 'asc';
          }
  
          // if sortby is set
          if(request()->has('sortby')) 
          {
              $sortby = request()->sortby;
  
              switch($sortby) 
              {
                  case "date":
                      $sortby = "string_date";
                  break;
                  case "company":
                      $sortby = "company_name";
                  break;
                  case "name":
                      // do nothing
                  break;
                  case "communication-type":
                      $sortby = "communication_type";
                  break;
                  case "contact":
                      // do nothing
                  break;
                  case "subject":
                      $sortby = "status";
                  break;
                  case "assigned-to":
                      $sortby = "assigned_to";
                  break;
                  case "action":
                      $sortby = "action_item";
                  break;
                  case "assigned-to":
                      $sortby = "assigned_to";
                  break;
                  default:
                      $sortby = 'created_at';
                  break;
              }
          }
      }
  
      if($sortdirection == 'asc') {
          return Auth::user()->actionLogs
              ->where('activity_key', '=', '1,' . $company->id)
              ->sortBy($sortby);
      }
  
      return Auth::user()->actionLogs
          ->where('activity_key', '=', '1,' . $company->id)
          ->sortByDesc($sortby);
  
  }
  

  This is my Vue component to get the data from the controller. I know the template code works, because it worked fine when I sent it dummy data before pulling the data from the controller.

  <style scoped>
  .action-link {
      cursor: pointer;
  }
  
  .m-b-none {
      margin-bottom: 0;
  }
  </style>
  
  <template>
  <div class="table-responsive">
      <table class="table table-striped table-sm">
          <thead>
              <tr>
                  <th><a id="sortby-date" class="action-nav" href="?sortby=date&sortdirection=desc">Date</a></th>
                  <th><a id="sortby-company" class="action-nav" href="?sortby=company&sortdirection=desc">Company</a></th>
                  <th><a id="sortby-name" class="action-nav" href="?sortby=name&sortdirection=desc">Name</a></th>
                  <th><a id="sortby-communication-type" class="action-nav" href="?sortby=communication-type&sortdirection=desc">Communication Type</a></th>
                  <th><a id="sortby-contact" class="action-nav" href="?sortby=contact&sortdirection=desc">Contact</a></th>
                  <th><a id="sortby-subject" class="action-nav" href="?sortby=subject&sortdirection=desc">Subject</a></th>
                  <th><a id="sortby-action" class="action-nav" href="?sortby=action&sortdirection=desc">Comment/Action Item</a></th>
                  <th>Archive</th>
                  <!-- check if admin?? -->
                      <th><a id="sortby-assigned-to" class="action-nav" href="?sortby=date&sortdirection=desc">Assigned To</a></th>
                  <!-- /check if admin?? -->
              </tr>
          </thead>
          <tbody v-if="actions.length > 0">
              <tr v-for="action in actions">
                  <td>
                      {{ action.string_date }}
                  </td>
                  <td>
                      {{ action.company_name }}
                  </td>
                  <td>
                      {{ action.name }}
                  </td>
                  <td>
                      {{ action.communication_type }}
                  </td>
                  <td>
                      {{ action.contact }}
                  </td>
                  <td>
                      {{ action.status }}
                  </td>
                  <td>
                      {{ action.action_item }}
                  </td>
                  <td>
                      <input type="checkbox" :id="'archive-' + action.id" class="archive" :name="'archive-' + action.id">
                  </td>
                  <td :id="'record-' + action.id" class="assigned-to">
                      {{ action.assigned_to }}
                  </td>
              </tr>
          </tbody>
      </table>
      <p id="add-action" style="text-align: center;">
        <button id="action-log-add" class="btn btn-sm btn-primary edit">Add Item</button>
        <button id="action-log-edit" class="btn btn-sm btn-danger edit">Edit Items</button>
      </p>
  </div>
  </template>
  
  <script>
  export default {
      data() {
          return {
              actions: []
          }
      },
      methods: {
          getActionLogs(location) {
  
              var company = location.split("/");
              company = company[company.length - 1];
  
              axios.get('/action-log/' + company)
                   .then(response => {
  
                      this.actions = response.data;                        
                      console.log(this.actions);
  
                   })
                   .catch(error => {
                      console.log('error! ' + error);
                   });
          }
      },
      mounted() {
          this.getActionLogs(window.location.href);
      }
  }
  </script>
  

  This is the output I get in the browser console

      {…}
  ​
      1: Getter & Setter
  ​
      2: Getter & Setter
  ​
      3: Getter & Setter
  ​
      4: Getter & Setter
  ​
      5: Getter & Setter
  ​
      6: Getter & Setter
  ​
      7: Getter & Setter
  ​
      8: Getter & Setter
  ​
      9: Getter & Setter
  ​
      10: Getter & Setter
  ​
      __ob__: Object { value: {…}, dep: {…}, vmCount: 0 }
  ​
      <prototype>: Object { … }
  

  I was expecting to see the normal array of data that gets returned, but this is what shows up instead and then won't update the component with the data. I'm new to Vue, so maybe there's something really easy I missing, but I can't seem to figure this out.
• Did a migration to database (hrm-master) and got this errors

  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'hrm-master.sessions' doesn't exist (SQL: select * from sessions where id = FCtzXvm1CTIvGJCfWuTVyO1bpyDIDVnt9FlmoCAY limit 1)

  in Connection.php line 647 at Connection->runQueryCallback('select * from sessions where id = ? limit 1', array('FCtzXvm1CTIvGJCfWuTVyO1bpyDIDVnt9FlmoCAY'), object(Closure)) in Connection.php line 607
• Vue.js transitions not working in Laravel Blade + Sass

  My Google search didn't come up with any answer to is this expected behavior or am I doing something wrong.

  My HTML:

  <a v-on:click="showInformation = !showInformation">Show / Hide</a>
  <transition name="fade">
      <p class='further-info' v-if="!showInformation">Lorem ipsum dolor.</p>
  </transition>
  

  EDIT: Just found out that it works like this:

  <transition name="fade">
      <div v-if="!showInformation">
          <p class='further-info'>Lorem ipsum dolor</p>
      </div>
  </transition>
  

  This is not documented in the Vue.js documentation and it's clearly shown that it should work as the first example. Is this expected in my case?

  My SASS:

  .fade-enter-active, .fade-leave-active
      transition: opacity .5s
  
  .fade-enter, .fade-leave-to
      opacity: 0
  

  Pretty straight forward, but I may be doing something wrong. Whenever I click the button the p shows and hides correctly, but without any transition effect.

  Using:

  Laravel 5.7.9
  Vue.js 2.9.6 (with ES6)
  Sass 1.14.2 (but not relevant since it complies the transition code correctly)
  The HTML file is written a blade template file