EMfinanga

I have already developed my web application so i want to make an android application to fetch some data and get some report.

What can i do while i have already created all route in 'web.app'

Please someone can assist me steps.

so what can i do to fetch data using daterange @snapey

@snapey ,

from string format (m-d-Y)

           "01/25/2020 - 01/25/2020"


             public function stock_summary(Request $request)
           {
         $inwards = CashSales::with('items')
          ->where('item_id', $request->id)
        
              ->whereBetween('created_at', [$request->from, $request->to])
              ->get();
             dd($request->from);

HTML

                        <div class=" col-md-4">
          <label for="from">Item Name</label>

        <select class="form-control " name="id" >
          <option data-tokens="">~items~</option>
          @foreach($products as $key=>$type)
          <option value="{{$key}}">{{$type}}</option>
          @endforeach
        </select>
           </div>
          <div class="col-md-6">
          <label for="from">From</label>
          <input type="text" id="from" name="from" class="daterange form-control">
        </div>

am using date range

got this error

             The separation symbol could not be found Trailing data

this code does not work correct, i want to select by date and id

           public function stock_summary(Request $request)
  {


      $id=$request->id;
      $from=$request->from;
      $to=$request->to;

      

   $products=Products::pluck('name','id');

    $inwards = CashSales::with('items')
      ->whereBetween('created_at', [new Carbon($from), new Carbon($to)])

      ->where('item_id', $id)

    ->get();
     dd($inwards);

   return view('stock_summary.show',compact('inwards','products'));


    }

date format in form 'd-m-Y'

date format in DB 'Y-m-d'

how can i reverse my code and work fine

i tried to add confirmation delete massage but does not works, below is my code which is not works

       {!! Form::open(['method' => 'DELETE','route' => ['users.destroy', $dt->id],'style'=>'display:inline','onsubmit'=> 'ConfirmDelete()']) !!}

                {!! Form::submit('Delete', ['class' => 'btn btn-danger btn-xs']) !!}
             
            {!! Form::close() !!}

@tisuchi ,

print method

    public function print($vch_no){

// $request->vch_no;

  $cash1=CashSales::with('customer_credit','items','store')
  ->where('vch_no', $vch_no)->first();

  $cash=CashSales::with('customer_credit','items','store')
  ->where('vch_no', $vch_no)->get();

     $GrandTotal = $cash->sum('amount');
       // dd($customerInvoice);
   // $test = 1000025.05;

    $f = new \NumberFormatter( locale_get_default(), \NumberFormatter::SPELLOUT );

  $AmountWord = $f->format($GrandTotal);
  // $pdf = App::make('dompdf.wrapper');
  $pdf = PDF::loadView('credit_sales.print', compact('cash1','GrandTotal','cash','AmountWord'));
  return $pdf->stream(); 
   // If you want to store the generated pdf to the server then you can use the store function

   // Finally, you can download the file using download function
  return $pdf->download('credit_sales.print'); 

   }

save method

             if(count($request->item_id) > 0)
{
  foreach($request->item_id as $key=>$v){
    $data2=([
      'l_type'=>'credit_sale',

      'vch_no'=>$fk,
      'credit_c_id'=>$request->customer_credit_id,
      'item_id'=>$request->item_id [$key],
      'store_id'=>$request->store_id [$key],
      'quantity'=>$request->qty [$key],
      'rate'=>$request->selling_price [$key],
      'amount'=>$request->amount [$key],
    ]);

    //check products if is less
     // foreach($request->qty[$key] as $data){
    $data=CashSales::select(DB::raw('sum(quantity) as tqty'))
    ->whereIn('l_type',['purchase','open balance'])
    ->where([
      ['item_id', '=', $request->item_id[$key]],
      ['store_id', '=', $request->store_id[$key]],
    ])->first();


    if((int)$data->tqty < (int)$request->qty[$key]){


     return redirect()->back()
     ->with('error','The stock quantity is less, Please check your stock quantity! ');

           }

       else{
     $credit1=CashSales::create($data2);


     //           //Check if the user asked for print
     if($_POST['valPrint']==1){



  / / $cash1=CashSales::with('customer_credit','items','store')
      //   ->where('vch_no', $credit1['vch_no'])->first();
      // //correct?yes lest see

    // return redirect()->action('[email protected]',$cash1);

// I WANT TO CALL PRINT FUNCTION HERE TO PRINT THE INVOICE I CREATED $credit=$request->fk;

       $this->print($credit);
               // $this->print($credit1['vch_no']);
     // dd();


     }

I want a ideas, i have the store function , and print function which select the invoice no and print the invoice.

I want that if i click the save button, will popup window to asking do you want to print invoice? If Yes then save data In DB and print invoice, if no save data in DB.

Please someone can guide me the idea

who can assist on this error, am using DomPdf laravel.

 <!DOCTYPE html>
 <html>

body{ font-family: arial; font-size: 11px; } table, th, td { border: 1px solid black; border-collapse: collapse; }

    <table  width="50%" align="center" style="margin-top: 200px;margin-bottom: 200px;" >
  <!--  <tr>
   <td><hr width="100%"></td>
   </tr> -->
     <tr>
      <td  align="right">
        <address>
        NAVIMEX AFRICA LIMITED <br>
        P.o.Box  4678 , Dodoma <br>
        0719 260 602 <br>
       </address>

    </td>

  </tr>

     <tr>
     <!-- <td align="left">Customer Address: </td> -->
       <td align="left">
       <address>
       <strong>{{$cash1->customer_cash->name}}</strong><br>
          {{$cash1->customer_cash->phone}}<br>
       </address>
       </td>
     </tr>

  <!-- <tr>
  <td><hr width="100%"></td>
   </tr> -->
   <tr>
   <td>
       <table width="100%">
       <td>Receipt No:</td>
       <td align="right" ><strong>{{$cash1->vch_no}}</strong></td>
       <tr>
       <td>Date:</td>
       <td align="right"> <small>{{$cash1->created_at->format('Y-m-d')}}</small></td>

      </tr>
    </table>
  </td>
</tr>

<!-- <tr>
  <td><hr width="100%" align="right"></td>
 </tr> -->

<tr>
  <td>
      <table  width="100%" cellpadding="0" cellspacing="0" align="center" >
       
        <tr>
          <td><b>Items</b></td>
          <td><b>Store</b></td>
          <td><b>Qnty</b></td>
          <td><b>Rate</b></td>
          <td align="right">Amount</td>
        </tr>
        
        
          <!-- @foreach($cash as $dt) -->
        <tr>
          <td>{{$dt->items->name}}</td>
          <td>{{$dt->store->name}}</td>
          <td>{{$dt->quantity}}</td>
          <td>{{$dt->rate}}</td>
          <td align="right">{{number_format($dt->amount,2)}}</td>
        </tr>
        <!-- @endforeach -->
       
      </table>
    </td>
</tr>

<!--   <tr>
   <td><hr width="30%" align="right"></td>
    </tr> -->
      <tr>
     <td>
      <table width="100%" align="center" >
       <tr>
            <td><b>Grand Total:</b></td>
            <td align="right">{{number_format($GrandTotal,2)}}</td>
          </tr>
        
        </table>
          </td>
       </tr>

   <tr>
         <td><hr width="30%" align="right"></td>
          </tr>

   <tr>
     <td><strong>{{$AmountWord}}</strong></td>
     </tr>

    <tr>
        <td colspan="6" align="center"><i>Thanks for Shopping. Visit Again!</i></td>
      </tr>

      <tr>
       <td>
        <table width="100%" cellpadding="0" cellspacing="0" align="center" >
         <tr>
          <td><a  href="{{url('cash_sales/index')}}">Back</a></td>
          <td align="right"><a href="{{url('cash_sales/print', $dt->vch_no)}}">Print</a></td>
        </tr>
        
      </table>
    </td>
  </tr>

Generated by Computer:

@sergiu17 , can you assist this again?, here i have multiple input so after save it i want to select and group it by invoice number or custmer_id and insert into another table, see my comment below.

              if(count($request->item_id) > 0)
    {
        foreach($request->item_id as $key=>$v){
            $data2=([
                'l_type'=>'credit_sale',
            
                'vch_no'=>$fk,
                'credit_c_id'=>$request->customer_credit_id,
                'item_id'=>$request->item_id [$key],
                'store_id'=>$request->store_id [$key],
                'quantity'=>$request->qty [$key],
                'rate'=>$request->selling_price [$key],
                'amount'=>$request->amount [$key],
            ]);

//check products if is less
 // foreach($request->qty[$key] as $data){
$data=CashSales::select(DB::raw('sum(quantity) as tqty'))
  ->whereIn('l_type',['purchase','open balance'])
  ->where([
  ['item_id', '=', $request->item_id[$key]],
  ['store_id', '=', $request->store_id[$key]],
  ])->first();
 if((int)$data->tqty < (int)$request->qty[$key]){


   return redirect()->back()
   ->with('error','The stock quantity is less, Please check your stock quantity! ');

    }

    else{
      
   $credit1=CashSales::create($data2);

 // SELECT THE LAST DATA WHICH I CREATED ABOVE
 $Credit=\DB::table('cash_sales')
->select('vch_no',DB::raw('sum(amount) as totalM'))
 ->where('credit_c_id','=',$request->customer_credit_id) 
  ->GROUPBY('vch_no')
 ->get();

// dd($Credit);
  // $Credit=CashSales::with('customer_credit','items')
  //   ->select('vch_no','credit_c_id','l_type','created_at',DB::raw('sum(amount) as totalM'))
  //   ->where('l_type', 'credit_sale')
  //   ->groupby('vch_no','l_type','credit_c_id','created_at')
  //   ->latest()->first(); 

      // INSERT SELECTED GROUP INTO THIS  TABLE
        DB::table('payment_credit_updates')->insert([
     'customer_id' => $credit1->credit_c_id,
    'amount' => $credit1->amount,
    'date' => $credit1->created_at, 
   'type' => 'CR'
     ]);

      }

           }

    return redirect()->back()->with('success', 'Successfully Stored');

    }

i have creating a multiple input(invoice details), so i want to select the latest groupby and insert into another table, so as you can see the comment below on my code

           if(count($request->item_id) > 0)
        {
            foreach($request->item_id as $key=>$v){
                $data2=([
                    'l_type'=>'credit_sale',
                
                    'vch_no'=>$fk,
                    'credit_c_id'=>$request->customer_credit_id,
                    'item_id'=>$request->item_id [$key],
                    'store_id'=>$request->store_id [$key],
                    'quantity'=>$request->qty [$key],
                    'rate'=>$request->selling_price [$key],
                    'amount'=>$request->amount [$key],
                ]);

    //check products if is less
     // foreach($request->qty[$key] as $data){
    $data=CashSales::select(DB::raw('sum(quantity) as tqty'))
      ->whereIn('l_type',['purchase','open balance'])
      ->where([
      ['item_id', '=', $request->item_id[$key]],
      ['store_id', '=', $request->store_id[$key]],
    ])->first();
  if((int)$data->tqty < (int)$request->qty[$key]){
    
    
     return redirect()->back()
     ->with('error','The stock quantity is less, Please check your stock quantity! ');
  
      }

      else{
          
       $credit1=CashSales::create($data2);

     // SELECT THE LAST DATA WHICH I CREATED ABOVE
 $Credit=\DB::table('cash_sales')
 ->select('vch_no',DB::raw('sum(amount) as totalM'))
 ->where('credit_c_id','=',$request->customer_credit_id) 
 ->GROUPBY('vch_no')
 ->get();

 // dd($Credit);
      // $Credit=CashSales::with('customer_credit','items')
      //   ->select('vch_no','credit_c_id','l_type','created_at',DB::raw('sum(amount) as totalM'))
      //   ->where('l_type', 'credit_sale')
      //   ->groupby('vch_no','l_type','credit_c_id','created_at')
      //   ->latest()->first(); 

 // INSERT SELECTED GROUP INTO THIS  TABLE
      DB::table('payment_credit_updates')->insert([
       'customer_id' => $credit1->credit_c_id,
      'amount' => $credit1->amount,
      'date' => $credit1->created_at, 
      'type' => 'CR'
     ]);

          }

               }

        return redirect()->back()->with('success', 'Successfully Stored');

        }

i want to check if the multiple input as less that requested qnty then display message, i tried but it get me null and accept on one input.

          $data=$request->all();
        $lastid=Customer_cash::create($data)->id;
        if(count($request->item_id) > 0)
        {
            foreach($request->item_id as $key=>$v){
                $data2=([
                    'vch_no'=>$fk,
                    // 'c_type'=>"cash",
                    'l_type'=>"cash_sale",
                    'cash_c_id'=>$lastid,
                    'item_id'=>$request->item_id [$key],
                    'store_id'=>$request->store_id [$key],
                    'quantity'=>$request->qty [$key],
                    'rate'=>$request->selling_price [$key],
                    'amount'=>$request->amount [$key],
                ]);

     //check products if is less
    $data=CashSales::select(DB::raw('sum(quantity) as tqty'))
      ->whereIn('l_type',['purchase','open balance'])
      ->where([
      ['item_id', '=', $request->item_id[$key]],
      ['store_id', '=', $request->store_id[$key]],
    ])->first();


    if((int)$data->tqty < (int)$request->qty[$key]){

    dd( $data);  
   return redirect()->back()
   ->with('error','The stock quantity is less, Please check your stock quantity! ');
  
  }

    else{
                CashSales::create($data2);
          }
               }
        return Redirect('show')->with('success', 'Successfully Stored');
        
        }
   }

@cronix , how ?

@sergiu17 , thank you it working,

hello, i want to select some data from table 1 and insert into another table, the below code it works but it insert many data into second and not LATEST one from one table

so kindly what can i do from there

        public function store(Request $request)
   {
       request()->validate([
        'amount' => 'required',
        'comment' => 'required',
        'customer_id' => 'required'
         ]);

   $model=$request->all();
    Payment::create($model);

  $datas =\DB::table('payments')->latest()->get();

 foreach($datas as $data){
   DB::table('payment_credit_updates')
     ->insert(['customer_id' => $data->customer_id, 'amount'=>$data->amount, 'date'=>$data->created_at, 
    'type'=>"DR"]);

  }

// dd(); return redirect()->back() ->with('success','category created successfully.'); }

how to i convert sum amount in to word as per below function

        $Cash_Sales=CashSales::with('customer_credit','items','store','supplier')
        ->select('vch_no','cash_c_id','l_type','created_at',DB::raw('sum(amount) as totalM'))
        ->where('l_type', 'cash_sale')
        ->groupby('vch_no','l_type','cash_c_id','created_at')
        ->get();

i want to display totalM in words, what code can i add there

i tried this but got the error

                     $balanceIn=CashSales::with('items')
                       ->select('item_id',
                        DB::raw('sum(quantity)  as tqty whereIn(l_type,["credit_sale,cash_sale"])'),
                        DB::raw('sum(quantity)  as  tqty1 whereIn( l_type , ["open balance,purchase"]'))
                    ->groupby('item_id')
                    ->get();

error

               Illuminate\Database\QueryException
             SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check 
                  the manual that corresponds to your MariaDB server version for the right syntax to use near 
            'whereIn(l_type,["credit_sale,cash_sale"]), sum(quantity) as tqty1 whereIn( l_t' at line 1 (SQL: select 
                      `item_id`, sum(quantity) as tqty whereIn(l_type,["credit_sale,cash_sale"]), sum(quantity) as tqty1 
               whereIn( l_type , ["open balance,purchase"] from `cash_sales` group by `item_id`)

$balanceIn=CashSales::with('items')

                    ->select('item_id',
                        DB::raw('sum(quantity)  as tqty whereIn(l_type,["credit_sale,cash_sale"])'),
                        DB::raw('sum(quantity)  as  tqty1 whereIn( l_type , ["open balance,purchase"]'))
                    ->groupby('item_id')
                    ->get();

I GOT THE ERROR

                  Illuminate\Database\QueryException
                SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; 
               check the manual that corresponds to your MariaDB server version for the right syntax to use near 
            'whereIn(l_type,["credit_sale,cash_sale"]), sum(quantity) as tqty1 whereIn( l_t' at line 1 (SQL: select 
         `item_id`, sum(quantity) as tqty whereIn(l_type,["credit_sale,cash_sale"]), sum(quantity) as tqty1 
            whereIn( l_type , ["open balance,purchase"] from `cash_sales` group by `item_id`)

@sinnbeck , it return only one products

if possible is can share my screen -emma4082@gmail.com

Once you switch to first() you will not get collections but single instances of CashSales.

YES, this is not get collection

what can i do to get the collection according to my query, can you modify it? @bugsysha

@bugsysha , YES

           $balanceQty=CashSales::with('items')
                    ->select('item_id',DB::raw('sum(quantity) as tqty'))
                    ->whereIn('l_type',['credit_sale','cash_sale'])

                    ->groupby('item_id')
                    ->first();

        $balanceQty1=CashSales::with('items')
                    ->select('item_id',DB::raw('sum(quantity) as tqty1'))
                    ->whereIn('l_type',['open balance','purchase'])

                    ->groupby('item_id')
                    ->first();

                    $data=$balanceQty->merge($balanceQty1);
                    

         $balanceQtyOut=(int)$balanceQty1->tqty1-(int)$balanceQty->tqty;

       // dd($data);

        return view('dashboard.index',compact('totalCredit','totalCashsale','balanceQtyOut','data'));

im using the marge, and im gettting that error

when i changed to first(), i get another error

       BadMethodCallException
     Call to undefined method App\CashSales::merge()

i want to have one foreach loop in blade view after combine this query

          $balanceQty=CashSales::with('items')
                    ->select('item_id',DB::raw('sum(quantity) as tqty'))
                    ->whereIn('l_type',['credit_sale','cash_sale'])

                    ->groupby('item_id')
                    ->get();

      $balanceQty1=CashSales::with('items')
                    ->select('item_id',DB::raw('sum(quantity) as tqty1'))
                    ->whereIn('l_type',['open balance','purchase'])

                    ->groupby('item_id')
                    ->get();

                    $data=$balanceQty->merge($balanceQty1);

       $balanceQtyOut=(int)$balanceQty1->tqty1-(int)$balanceQty->tqty;

i get this error

       Property [tqty1] does not exist on this collection instance

someone can assist me

@wraith , what do you think if we can create product as open balance on sales table instead of have itemstock table?,

kindly advice

@wraith, see the way i did on my app, and you can advice accordingly

i did like this because i have two store(Shop and Warehouse),then i created two store on store table:

Then i just created the products on products tables with categories.

Then on itemstock table, i just select the products name and store name, quantity, rate, and amount. and save it on itemstock table.

On this itemstock table is an open stock of each products.

Then i have sales table: from here i have a list of vouchers (Cash sales, credit sales, purchase) ,

then when you want to perform a cash sale, you will select the products name from product tables and select store , quantity , rate and Amount and save the data. And the same as credit sales and purchase, that why you can see on my table sales i have

Sales table
         
          id
          Vch_no
          l_type- default value
          Item_id- reference is products
          Qnty
          Rate
          amount
  

So that why i want to join there tables, then to evaluate one by one product(item_id)

I want to select product from the following tables,

Products

    Id
    Name
    Category_id

Itemstock

    Id
    Item_id
    Qty
    Rate
    amount

Sales

       Id
      Item_id
       Sale_type
       Qty
       rate
      Amount

I want to select product id=3 which found on those table.

What i try

     Function item_summary(Request,$request){

      $sale = Sale:: with(items)->where(item_id, $id)

}

I dont get the data in itemstock table, how can i modify this code?

i have that column "l_type" which have credit_sale,purchase,cash_sale, but both we have qnt, rate and amount

how can i apply this statement in my tag as my code below, or what is the best way i can use this

                 @foreach($inwards as $key=>$dt)
           
            <tr>
              <td>{{$dt->created_at->format('Y-m-d')}}</td>
              <td>{{$dt->vch_no}}</td>
              <td>{{$dt->l_type}}</td>
              <td>{{$dt->items->name}}</td>


        @if($dt->l_type == "purchase")
              <td>{{$dt->quantity}}</td>
              <td>{{$dt->rate}}</td>
              <td>{{$dt->amount}}</td>
            
             //i want to display data here which this column is much
          @elseif($dt->l_type == "credit_sale" and "cash_sale")
              <td>{{$dt->quantity}}</td>
              <td></td>

              <td>{{$dt->rate}}</td>
              <td>{{$dt->amount}}</td>
             @endif
              <td></td>
              <td></td>
              <td></td>
              <td></td>
              
            </tr>

hello how can i write this sql in laravel

                      SELECT `created_at`,`l_type`,`vch_no`,`item_id`,`quantity`,`rate`,`amount` FROM 
                    `cash_sales` WHERE `l_type`in ('credit_sale','cash_sale') AND item_id=3

i try this but got error

                  public function stock_summary(Request $request){

                  $inwards=CashSales::with('customer_cash','items','store')
                 ->SELECT( `created_at`,`l_type`,`vch_no`,`item_id`,`quantity`,`rate`,`amount`) 
                 ->WhereIn( `l_type`, 'credit_sale','cash_sale')
                 ->where('item_id', $id)
                ->get();

error

             Symfony\Component\Debug\Exception\FatalThrowableError
                  Argument 1 passed to Illuminate\Database\Query\Builder::cleanBindings() must be of the type 
                 array, string given, called in 
                  
             C:\xampp\htdocs\accounts\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php on line 907

                        return view('stock_summary.show',compact('inwards'));
                  }

Thanks @tisuchi

Example i created a sales now

   Created_at 2019-12-07 07:59:29

While Current timestamp

            2019-12-07 11:03:20

I have a table with timestamps column (created_at and updated_at) in mySql database. I am using laravel version 5.4 and php 7.0.

I happened to notice that it is adding incorrect time to this particular column.

How to set this column to set timestamp correct

@tisuchi

There is no problem, but i want to Evaluate one items by join those tables.

Example items 4 I want to know how many qnty in ward and out ward.

@tisuchi is not working i got the error

       SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'cash_sales' (SQL: select 
              `product`.`name`, `credit_sales`.`vch_no`, `cash_sales`.`vch_no`, `credit_sales`.`quantity`, 
      `cash_sales`.`quantity`, `credit_sales`.`rate`, `cash_sales`.`rate`, `cash_sales`.`rate`, ` 
      credit_sales`.`amount`, `cash_sales`.`amount`, `itemstocks`.`quantity`, `itemstocks`.`rate`, 
       `itemstocks`.`amount`, `itemstocks`.`created_at`, `credit_sales`.`created_at`, 
  `cash_sales`.`created_at` from `cash_sales` inner join `products` on `credit_sales`.`item_id` = 
     `products`.`id` inner join `cash_sales` on `products`.`id` = `cash_sales`.`item_id` inner join 
  `itemstocks` on `products`.`id` = `itemstocks`.`item_id` where `product`.`id` = 4)

@snapey , i need the simply way and correct so you can help me

on my model i used like this

                   class CashSales extends Model
           {

       protected $fillable = [
         'vch_no',
        'customer_cash_id',
        'item_id',
        'store_id',
        'quantity',
        'rate',
      'amount'];

        public function customer_cash(){

      return $this->belongsTo('App\Customer_cash','customer_cash_id','id');
      }

     public function items(){

       return $this->belongsTo('App\Products','item_id','id');
      }

        public function store(){

        return $this->belongsTo('App\Store','store_id','id');
      }
    }



      

class Itemstock extends Model { protected $fillable = [

    'item_id',
      'store_id',
     'quantity',
      'rate',
     'per',
    'amount'];

    public function Items(){

    return $this->belongsTo('App\Products','item_id','id');
     }


   public function store(){
    return $this->hasOne('App\Store','id','store_id');
     }


         }



 class Products extends Model
 {
  protected $fillable = [ 'name', 'category_id'];


  public function category(){
    return $this->hasOne('App\Category','id','category_id');
  }

  }

i tried this on sql, but i don't know if is correct or not how i can put in laravel

                  SELECT c.name,a.`vch_no`,b.vch_no,a.quantity,b.quantity,a.rate,b.rate,b.rate,
               a.amount,b.amount,d.quantity,d.rate,d.amount,d.created_at,a.created_at,b.created_at
              FROM credit_sales a, cash_sales b, products c ,itemstocks d
            WHERE a.`item_id` = c.id
            AND b.`item_id` = c.id
           AND d.`item_id` = c.id
            AND c.id=4

hello Team i have 4 tables, i design a sales system and inventory, i want to evaluate the items

            1.  Items
                -id
                -name
                - category_id

         2. Credit_sales
                 -item_id
                 -customer_credit_id
                 -rate
                 -vch_no
                 -quantity
                 -amount
              
          3. Cash_sales
                 -item_id
                 -store_id
                 -customer_cash_id
                 -rate
                 -vch_no
                 -quantity
                 -amount

         4. itemsstock
                  -item_id
                 -store_id
                   -rate
                  -quantity
                 -amount

i want to select the id=3 then to get this format output

                   item_id
                   vch_no
                 -rate
                 -quantity
                 -amount
                 

Anyone can help me

@ryanooi no no, there is no need to have many to many relationship, you need to make a pivot table

Noted, but remember i have two table here as you can seen on my code so kindly can you advice me clear on this ?

No no

This code below is for create data into database

I want to create the code for update

 $data=$request->all();
    $lastid=Customer_cash::create($data)->id;
    if(count($request->item_id) > 0)
    {
        foreach($request->item_id as $key=>$v){
            $data2=([
                'Cash_no'=>$fk,
                'customer_cash_id'=>$lastid,
                'item_id'=>$request->item_id [$key],
                'store_id'=>$request->store_id [$key],
                'quantity'=>$request->qty [$key],
                'rate'=>$request->selling_price [$key],
                'amount'=>$request->amount [$key],
            ]);

            CashSales::create($data2);
             }
    return redirect()->back()->with('success', 'Successfully Stored');

    }

ok, but what if i can apply a alert like do you want to print YES/NO, if i click yes button it direct me on printed page

how can i archive this ?

hello, i want the concept after save the data i want to get the pop up asking me to print invoice.

this is what i done.

$data=$request->all();
        $lastid=Customer_cash::create($data)->id;
        if(count($request->item_id) > 0)
        {
            foreach($request->item_id as $key=>$v){
                $data2=([
                    'Cash_no'=>$fk,
                    'customer_cash_id'=>$lastid,
                    'item_id'=>$request->item_id [$key],
                    'store_id'=>$request->store_id [$key],
                    'quantity'=>$request->qty [$key],
                    'rate'=>$request->selling_price [$key],
                    'amount'=>$request->amount [$key],
                ]);

                CashSales::create($data2);
                 }
        return redirect()->back()->with('success', 'Successfully Stored');

        }

this code is working fine for save data, but i want to add an idea to print the docs

@tray2 , i want to archive during create items i need to able to allocate that items quantity either shop store or warehouse

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