Shiva

@maverickchan - cool I will look into that, but will that solve my problem because even if I change the path for example to my home page it still doesn't change

@maverickchan - but wouldn't it be called when I do this import Users from "../users/Users"; in my permissions.js

@topvillas - nope I don't get any errors

I have a laravel vue app and I'm trying to create a roles and permissions page that links to the users page.

The problem I'm having is that, when you're on the permissions page and you open up the users panel and you select a user and you decide you need to change their details and you click on their edit button and that should take you to the users page.

So far I've only managed to get the url to change but the page stays on the permissions page.

My permissions.vue

<template>
  <div>
    <h3>Users</h3>

    <div>
      <table>
        <thead>
          <tr>
            <th>Permission Name</th>
            <th style="width:240px;"></th>
          </tr>
        </thead>
        <tbody>
          <tr v-for="permission in permissions">
            <td>{{permission.name}}</td>
            <td style="text-align: right;">
              <button class="btn btn-sm btn-outline-info" @click="users(permission)">
                Users
              </button>
            </td>
          </tr>
        </tbody>
      </table>
    </div>
  </div>
</template>

<script>
  export default {
    props: ['emit', 'roles'],
    data() {
      return {

      }
    },
    computed: {

    },
    mounted() {

    },
    methods: {
      users(permission) {
        this.emit.$emit('edit-users', { permission: permission });
      }
    }
  }
</script>

this.emit.$emit('edit-users', { permission: permission }); then opens up the users panel on the permission page

<template>
  <div>
    <h3>Users in <strong>{{permission.name}}</strong></h3>

    <div>
      <table>
        <thead>
          <tr>
            <th>User</th>
            <th style="width:120px;"></th>
          </tr>
        </thead>
        <tbody>
          <tr v-for="user in users">
            <td>{{user.name}}</td>
            <td style="text-align: right;">
              <button class="btn btn-sm btn-outline-info" @click="edit(user)">
                Edit
              </button>
            </td>
          </tr>
        </tbody>
      </table>
    </div>
  </div>
</template>

<script>
  export default {
    props: ['emit', 'role'],
    data() {
      return {
        users: []
      }
    },
    computed: {

    },
    mounted() {
      this.getUsers();
    },
    watch: {

    },
    methods: {
      getUsers() {
        axios.get('/admin/permissions/'+this.permission.name+'/users').then(response => {
          this.users = response.data.users;
        });
      },
      edit(user) {
        this.$router.push({name: 'Users', params: {id: user.id}});
      }
    }
  }
</script>

in my permissions.js I have

import VueRouter from 'vue-router';
Vue.use(VueRouter);

import Users from "../users/Users";

const router = new VueRouter({
  mode: 'history',
  routes: [
    {
      path: '/admin/users/:id',
      name: 'Users',
      component: Users
    }
  ]
})

if (document.getElementById('permissions')) {
  const app = new Vue({
    el: "#permissions",
    router,
    data() {
      return {
        emit: new Vue(),
      }
    },
    methods: {

    },
    mounted() {

    }
  });
}

@deepu07 - I'm using DB::connection('second')->table('products)->where('category_id', $category_id);

I'm trying to find out if a column exists in a table. I tried doing this

if(Schema::hasColumn('products', 'category_id'))
{
    dd('has category_id');
}else{
    dd('doesnt have category_id');
}

the reason why I say it isn't working is because if I check my network tab I see that doesnt have category_id printed out and if I do check my products table then the category_id is there. So what is supposed to happen is that if category_id does exist then has category_id is supposed to be printed out.

I have a csv that looks like this

product,title,category,price\n
PR001,"Product Title 1","Category 1", 123\n
PR002,"Product Title 2","Category 2", 123\n
PR003,"Product Title 3","Category 3", 123\n
PR004,"Product Title 4","Category 4", 123\n
PR005,"Product Title 5","Category 5", 123\n

What I would like to do is get an array that looks like this

array:5 [
  "PR001" => "123"
  "PR002" => "123"
  "PR003" => "123"
  "PR004" => "123"
  "PR005" => "123"
]

When I run my code I get this error

 ErrorException  : Illegal offset type

Here is my code

$users = User::all();

$productArr = [];

foreach($users as $user)
{
	$csv = $user->getCsv();

	$lines = explode(PHP_EOL, $csv);
    $csvArray = [];

    foreach($lines as $line)
    {
        $csvArray[] = str_getcsv($line);
    }

    $keys = array_shift($csvArray);

    $result = array_combine($keys, array_map(null, ...$csvArray));

    $productArr[$result['product']] = $result['price'];
}

dd($role);

I'm trying to get my selected options to show the option that was saved in the database. For example I have a product and that product belongs to a category so what I would like is for my selected options to display that saved category but also all the other categories. The problem I'm having is that I can't get my saved category to show up.

Here is my code

<select class="form-control" v-model="addNewCategory">
	<option :value="0">Choose Category</option>
	<option v-for="category in this.categories" :value="category.id" :selected="category.id === getCategoryId()">{{ category.name }}</option>
	<button @click="addCategory" class="btn btn-sm btn-success">Add</button>
</select>

<script>
	export default {
		props: ['product', 'categories'],
		data() {
            return {
                addNewCategory: null,
                category_id: ''
            }
        },
        mounted() {
            axios.get('/admin/products/'+this.product.id+'/category').then((response) => {
                this.category_id = response.data.category_id;
            });
        },
        methods: {
        	getCategoryId(){
        		return this.category_id;
        	},
        	addCategory() {
                if(this.addNewCategory > 0){
                    axios.put('/admin/products/'+this.product.id+'/category', {
                        selected_category: this.addNewCategory
                    }).then((response) => {
                
                    })
                }
            },
        },
	}
<\script>

Ok cool. But then how can I turn it into an eloquent object so that I can do $runs->id

I'm trying to get my data to be an eloquent object instead of an array. I'm using the DB::select()->get() but I get this error

Call to a member function get() on array

Here is my full code

$runs = DB::select("SELECT id FROM item_run WHERE
(EXTRACT(EPOCH FROM now()) - EXTRACT(EPOCH FROM started_at)) >= 300 AND started_at IS NOT NULL AND 
completed_at is NULL")->get();

I would like to be able to do $runs->id