EMfinanga

kindly i want a idea how can i do this in MY ACCOUNTS app as per below info.

i want to have an option to create items with store, lets say items 1 has a quantity -200 pcs, so i want to locate 100 pc to store 1 and 100 pc to store 2 in my DB

so i want an idea to relate the stock items table and store table.

keep in mind that i want store can be an option that means you can direct that pc to that store or not

i want to excute the report of sales, to get all data,

example this is the query i used now

public function salesreport(Request $request) {

$sales = Sales::select("sales.*")
->whereBetween('created_at', [$request->input('from'), $request->input('to')])->get();

return view('reports.salesreport',compact('sales')); }

how can i create a query to select data by day, week, month and year?

thank you @sinnbeck

someone can assist me the query to select data range by date.

i want a user input a date., How can i rebuild my query?

public function salesreport()
{

    $sales = Sales::select("sales.*")
    ->whereBetween('created_at', ['2019-09-01', '2019-09-10'])->get();

return view('reports.salesreport'); }

@braunson this is what i tried its work but does not check the quantity so i want to apply that logic

for ($a=0; $a < count($ids); $a++) { //create detail on data faktur

$ido=$request->name[$a];
$store=$request->store[$a];

$model=([
    'invoice_no'=>$fk, 
    'customer_id'=>$request->customer_id, 
    //'product_code'=>$request->product_code[$a], 
    'name'=>$request->name[$a],
    'store'=>$request->store[$a],
    'selling_price'=>$request->selling_price[$a], 
    'amount'=>$request->amount[$a],
    'qty'=>$request->qty[$a], 
]);
//update stok
 $data=Stock::select('quantity','store')->where([
                ['id', '=', $ido],
                ['store', '=', $store],
                  ])->first();
// apply  conditions
//check if available

$check=(int)$data->quantity < (int)$request->qty[$a];
dd($data);
if($check){

return redirect()->back()
            ->with('success','quantity is Less that entered');
    // return view('sales.index')->with('success', 'not register'); 
}
else{
$stokl=(int)$data->quantity-(int)$request->qty[$a];
// dd($stokl);

$model1=([
    'quantity'=>$stokl,

]);
$x=Stock::find($ido);

if($x->update($model1))
{
    Sales::create($model);
}

I need an idea regards on my explanation

I have order form i want to check quantity, if the quatity request is available on the stock, i have two store store 1 and 2

So i select product and store on the order form, i want to check before i save the order.

Someone can help me to create this loop

@snapey but i define it in the model,

but my concept is to select a customer and get his invoice from sales table

@munazzil , i get the same error

@tykus i dont know how to apply this

@munazzil i get this error.

                    Order direction must be "asc" or "desc".

customer has many invoice, that why i want to select customer and return all invoice belong to customer

    example this customer has this invoices 
            
               FK060919#0001,   FK060919#0003,   FK060919#0007,

i want to show only some data which is specific selected id

when i run that foreach its comes multiples, keep in mind that i want to show only one specific selected id

                     public function show($id)
              {

               $customer_ledger=Sales::with('customer')
                 -> select('invoice_no','customer_id','created_at',DB::raw('sum(amount) as totalM'))
                 ->where('customer_id', $id)
                   ->groupby('invoice_no','customer_id','created_at')
                             
                                 ->get();
                 return view('customers.customer_ledger',compact('customer_ledger'));
               }

i have two table which is related, i want to select some data where the id is equal to selected, and display in blade

i tried this but get the below error.

 Property [customer] does not exist on this collection instance. 

my code:

         $customer_ledger=Sales::with('customer')
                   -> select('invoice_no','customer_id','created_at',DB::raw('sum(amount) as totalM'))
                   ->where('customer_id', $id)
                     ->groupby('invoice_no','customer_id','created_at')
                      ->get();

How to implement this on my code below? $ids=$request->name;

 for ($a=0; $a < count($ids); $a++)
 {
    //create detail on data faktur

    $ido=$request->name[$a];
    $store=$request->store[$a];

    $model=([
        'invoice_no'=>$fk, 
        'customer_id'=>$request->customer_id, 
        //'product_code'=>$request->product_code[$a], 
        'name'=>$request->name[$a],
        'store'=>$request->store[$a],
        'selling_price'=>$request->selling_price[$a], 
        'amount'=>$request->amount[$a],
        'qty'=>$request->qty[$a], 
    ]);
    //update stok
     $data=Stock::select('quantity','store')->where([
                    ['id', '=', $ido],
                    ['store', '=', $store],
                      ])->first();
    // apply  conditions
    //check if available

    $check=(int)$data->quantity < (int)$request->qty[$a];
    dd($data);
    if($check){
    
    return redirect()->back()
                ->with('success','quantity is Less that entered');
        // return view('sales.index')->with('success', 'not register'); 
    }
    else{
    $stokl=(int)$data->quantity-(int)$request->qty[$a];
    // dd($stokl);

    $model1=([
        'quantity'=>$stokl,

    ]);
    $x=Stock::find($ido);

    if($x->update($model1))
    {
        Sales::create($model);
    }

I have multiple input of order form(product,price, qnty, store and amount)

I want to put the condition if the product quantity is bigger than stock then redirect back with error

Also i want to check foreach product name if it available (added) on stock inorder to perform the sales if not redirect it back.

Someone can share me an idea to archive this as well.

i want to have the condition regarding on my code to check few thing as per below

1. check if the quantity is less than entered with user, and if is less don't save the data display the list of that product which is less

• right now my code is working only for one products and save others which is not less than.

1. Also i i want to check if the product is selected as per query says, if not true then display the error of that products is not satisfy the condition.
   • right now my code is working fine but it checks well but if there is error it save only product which is sastify condition.

below is my code of controller

                $ids=$request->name;

    
     for ($a=0; $a < count($ids); $a++)
     {
        //create detail on data faktur

        $ido=$request->name[$a];
        $store=$request->store[$a];

        $model=([
            'invoice_no'=>$fk, 
            'customer_id'=>$request->customer_id, 
            //'product_code'=>$request->product_code[$a], 
            'name'=>$request->name[$a],
            'store'=>$request->store[$a],
            'selling_price'=>$request->selling_price[$a], 
            'amount'=>$request->amount[$a],
            'qty'=>$request->qty[$a], 
        ]);
        //update stok
         $data=Stock::select('quantity','store')->where([
                        ['id', '=', $ido],
                        ['store', '=', $store],
                          ])->first();
        // apply  conditions
        //check if available

        $check=(int)$data->quantity < (int)$request->qty[$a];
        dd($data);
        if($check){
        
        return redirect()->back()
                    ->with('success','quantity is Less that entered');
            // return view('sales.index')->with('success', 'not register'); 
        }
        else{
        $stokl=(int)$data->quantity-(int)$request->qty[$a];
        // dd($stokl);

        $model1=([
            'quantity'=>$stokl,

        ]);
        $x=Stock::find($ido);

        if($x->update($model1))
        {
            Sales::create($model);
        }
        }

i need the help on declare the condition

i have a invoice which perform sales basis, , so i want to select product_id and store name(office or Yard) then to calculate some some formular as per code below.

but right now it select only one row and perform calculation, i want to select multiple row according then perform calculation.

below is my code.

           for ($a=0; $a < count($ids); $a++)
    {
        //create detail on data 

        $ido=$request->name[$a];
        $store=$request->store[$a];

        $model=([
            'invoice_no'=>$fk, 
            'customer_id'=>$request->customer_id, 
             'name'=>$request->name[$a],
            'store'=>$request->store[$a],
            'selling_price'=>$request->selling_price[$a], 
            'amount'=>$request->amount[$a],
            'qty'=>$request->qty[$a], 
        ]);
        //update stok
         $data=Stock::select('quantity')->where([
                        ['id', '=', $ido],
                        ['store', '=', $store],
                          ])->first();
        //$data=Stock::select('quantity')->where('id','=',$ido)->first();
  
        $stokl=(int)$data->quantity-(int)$request->qty[$a];

        dd($stokl);
        
        $model1=([
            'quantity'=>$stokl,

        ]);
        $x=Stock::find($ido);

        if($x->update($model1))
        {
            Sales::create($model);
        }

when i running dd($stokl); is show the calculation of one row, while i entered two rows

There is the second, answer he sent i don't see it inorder to mark as answer that why i comment like that

@sti3bas your answer is correct, thank you

i get null

i want to select qnty where the condition is much

 $product_id=$request->product_id;
     $store=$request->store;

   $data=Stock::select('quantity')->where(['id'=> $product_id,'store'=>$store])->get();
                                           // ->where('store','=', $store)->get();

     $stockl=(int)$data->quantity+(int)$request->quantity;
     dd($data);

i get the error below

           Property [quantity] does not exist on this collection instance.

@bobbybouwmann pdf.blade.php it existing

hello i try to make a pdf, but the browser is loading to much, and does not work

   public function export_pdf($invoice_no)
{


  $customerInvoice1 = Sales::with('customer')
  ->where('invoice_no', $invoice_no)->first();

  $customerInvoice = Sales::with('customer')
   
  ->where('invoice_no', $invoice_no)->get();

    $totalAmount = $customerInvoice->sum('amount');


$pdf =PDF::loadView('sales.pdf',compact('customerInvoice','totalAmount','customerInvoice1'));

$fieldName=$customerInvoice1->invoice_no;
return $pdf->stream($fieldName. '.pdf'); 

}

@ftiersch im get some error

    #message: "Trying to get property 'name' of non-object"

i want to select the invoice number then to get all the details regards that invoice number include customer details from customer table

and show me how on the blade can be like

I want to achive the particular detail for customer invoice, i dot want to loop customer name,customer adress and customer phone,

how can i pass that info details in my blade

this is my controller

           public function show($invoice_no)
  {

  $customerInvoice = Sales::with('customer')->where('invoice_no','=', $invoice_no)->get();
    $totalAmount = $customerInvoice->sum('amount');
   return view('sales.show', compact('customerInvoice','totalAmount'));
  }

No, what i mean here, i want to select the products name, the can display one raw with price and qnty then i can able to add rows and delete rows

kindly i want to create invoice, cashier can select customer/write customer and input multiple orders, price,quantity amount in database

some one can assist me

i want to get a concept about stock decrement and increment

everyday the items is coming to intered in the stock and everyday is saling out,

assist me the concept steps to archive this

i have two tables user and profile table so in profile table i have advocate_id which is related from user.id

so how can i related this two table

i tried this code but i get the errror

my model protected $table = 'profiles'; protected $primaryKey = 'id'; protected $fillable = [ 'advocate_id','Ad_title', 'education','office_add','file','skill','phone'];

       public function user(){
           return $this->belongsTo('App\User', 'advocate_id');
       }

my controller

    public function index()
   {
    
     $adlist = Profile::with('user')->get();
      $userlist=User::where('user_type','Client')->get();
    
     return view('advocate.index',compact('adlist','userlist'));
  
      }

my blade view @foreach($adlist as $key=> $dt) {{++$key}} {{$dt->user->name}} {{$dt->Ad_title}} {{$dt->phone}} {{$dt->user->email}} {{$dt->office_add}} {{$dt->created_at}}

error

    "Trying to get property 'name' of non-object (View: 
    C:\xampp\htdocs\ACS\resources\views\advocate\index.blade.php)"

no, i want like massanger

i want to create simple chats,i have two users user A and User B, those user are inserted in one table called User,

so i want user A to chats with user B

public function up() { Schema::create('profiles', function (Blueprint $table) { $table->bigIncrements('id'); $table->integer('advocate_id')->unsigned(); $table->string('Ad_title'); $table->string('education'); $table->string('office_add'); $table->string('image'); $table->string('skill'); $table->integer('phone'); $table->timestamps(); }); }

the record is there in database with ID =3,

that why i told you on another question that what i want to archive

Profile::find(3) [!] Aliasing 'Profile' to 'App\Profile' for this Tinker session. => null >>> Profile::find(3) => null >>> i run in twice i get that

i have a data with ID of 3 which i inserted manually, so keep in mind that i want to update those data, no matter is there in DB or not

i get this

 null
 "3"

@snapey , i have this issue, i have created a user on USER table, so i want when that user login can update the profile and save data to another table "Profile "

so this is what i want to archive

@snapey i changed but still get the same error

how should i passing it?

i dont know what the problem here of my code to update

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

        $this->validate($request, [
        'Ad_title' => 'required',
        'education' => 'required',
        'office_add' => 'required',
        'skill' => 'required',
        'phone' => 'required',
      
       
       
          ]);
  
    $updateprofile = Profile::find($advocate_id);
    $updateprofile->advocate_id=Auth::user()->id;
    $updateprofile->Ad_title = $request->get('Ad_title');
    $updateprofile->education = $request->get('education');
    $updateprofile->office_add = $request->get('office_add');
     $updateprofile->skill = $request->get('skill');
    $updateprofile->phone = $request->get('phone');
    
    $updateprofile->save();
    return redirect()->route('advocate.profile')->with('success', 'Data Updated');

       }

i get the error subjected above

i tried this code below but i get this error

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

        $this->validate($request, [
        'Ad_title' => 'required',
        'education' => 'required',
        'office_add' => 'required',
        'skill' => 'required',
        'phone' => 'required',
        ]);
  
    $updateprofile = Profile::find($advocate_id);
    $updateprofile->advocate_id=Auth::user()->id;
    $updateprofile->Ad_title = $request->get('Ad_title');
    $updateprofile->education = $request->get('education');
    $updateprofile->office_add = $request->get('office_add');
     $updateprofile->skill = $request->get('skill');
    $updateprofile->phone = $request->get('phone');
    
    $updateprofile->save();
    return redirect()->route('advocate.profile')->with('success', 'Data Updated');

    }

Error

   "Creating default object from empty value"

i need help how the controller should be , i have my form to update some data below is my blade view and model, so i want to setup my controller to update those data.

my form

   <form  action="advocate/profile/.$data->id" method="POST" class="form-horizontal" enctype="multipart/form-data">
               {{ csrf_field() }} 
              <div class="form-group">
                <label for="inputName" class="col-sm-2 control-label">Title Name</label>

                <div class="col-sm-10">
                  <input type="text" class="form-control" name="Ad_title" id="inputName" placeholder="Name">
                </div>
              </div>
              <div class="form-group">
                <label for="inputName" class="col-sm-2 control-label">Education </label>

                <div class="col-sm-10">
                  <input type="text" class="form-control" name="education" id="inputName" placeholder="Name">
                </div>
              </div>
              <div class="form-group">
                <label for="inputEmail" class="col-sm-2 control-label">office Address</label>

                <div class="col-sm-10">
                  <input type="text" class="form-control" name="office_add" id="inputEmail" placeholder="Email">
                </div>
              </div>
              <div class="form-group">
                <label for="inputName" class="col-sm-2 control-label">Image</label>

                <div class="col-sm-10">
                  <input type="file" class="form-control" name="file" id="inputName" placeholder="Name">
                </div>
              </div>
              <div class="form-group">
                <label for="inputExperience" class="col-sm-2 control-label">Skills</label>

                <div class="col-sm-10">
                  <textarea class="form-control" name="skill" id="inputExperience" placeholder="Experience"> 
         </textarea>
                </div>
              </div>

my model

       protected $table    = 'profiles';
   protected $primaryKey = 'id';
  protected $fillable = [ 'advocate_id','Ad_title', 'education','office_add','file','skill','phone'];

    public function user(){
    return $this->belongsTo('App\User','advocate_id');
      }

i have two users Admin and advocate,

i want Admin to view all data from selected model and advocate to view a specific data from the same model,

now i managed view a spefics data from advocate

below is my code

     public function index()
  {
    //

    $userId = Auth::user()->id;
   $case = CaseManage::where('ad_id',$userId)->get();
    return view('case_manage.add_case')->with(compact('case'));
   }

sure thanks

my code has error

 " SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: 

'{"id":3,"name":"Justine","email":"[email protected]","user_type":"Advocate","email_verified_at":null,"created_at":"2019-06-17 09' for column 'ad_id' at row 1 (SQL: insert into case_manages (ad_id, case_title, file, updated_at, created_at) values ({"id":3,"name":"Justine","email":"[email protected]","user_type":"Advocate","email_verified_at":null,"created_at":"2019-06-17 09:52:18","updated_at":"2019-06-17 09:52:18"}, mama, Lecture Five-Design, Develop and Market a Product (3).pptx, 2019-07-03 12:05:32, 2019-07-03 12:05:32)) ◀"

my code

      public function store(Request $request)
  {
    //

  if($file = $request->file('file')){
    $docsfile=$file->getClientOriginalName();
    if($file->move('Case_file', $docsfile)){

        $upload= new CaseManage();
        $upload->ad_id=Auth::user();
         $upload->case_title= $request->input('title');
         $upload->file=$docsfile;

         $upload->save();

   return redirect('add_case')->with('success','success Laws uploaded');

    };

    }

return redirect()->back()->with('success','Not Uploaded'); }

No, the flow is like this

I have stock menu, after add all products in DB, then on stock menu i select the product name and entered the stock detail (quantity and store; either store 1 and store 2) the i save it

After that i make a order, so i want when i make a order i want to select the store inorder to decrement it.

I have two store, store 1 and Store 2, i want to decrement quantity in store 1 based on order

Some one can assist me the concept ?