000

<?php

namespace App\Http\Controllers;

use App\Item;
use DB;
use Facade\FlareClient\View;
use Illuminate\Http\Request;
use Mail;

class TestController extends Controller
{

public function test(){
	    
	     $pr_item = \App\PurchaseRequestItem::where('pr_id', 369)->selectRaw('sum(qty) as qty, sum(rqty) as rqty')->first();
	     echo "qty :".$pr_item->qty;
	     echo "rqty :".$pr_item->rqty;
	     dd($pr_item);
// 		dd(\App\User::all());
	}

public function update_table() {
		$i = 1;
		$purchaseOrders = DB::table('purchase_orders')->orderBy('id', 'desc')->get();
		foreach ($purchaseOrders as $key => $value) {
			
			DB::table('purchase_orders')->where('id', $value->id)->update([
				'delivery_periods_id' => $value->delivery_terms_id,
				'delivery_periods' => $value->delivery_terms
			]);	
			// dd('stop');
			if($i == 8) {
				break;
			} else {
				$i++;
			}
				
		}
	}

public function send_mymail(){
    $users_data= DB::table('users')
 	->where('role_id', '=', 3)
 	->first();
    $email_data['email']=$users_data->email;
 	$data['pr_data'] = DB::table('purchase_requests')
 	->where('id', '=', 1)
 	->get();
 	$data['item_data'] = DB::table('purchase_request_items')
 	->join('items', 'purchase_request_items.item_code', '=', 'items.code')
 	->join('category', 'items.category', '=', 'category.id')
    ->select('items.*', 'purchase_request_items.*','category.*')
 	->where('pr_id', '=', 1)
 	->get();
 	//return view('dashboard.pr.pr-mail',$data);
 			Mail::send('dashboard.pr.pr-mail', $data, function ($m) use ($email_data) {
            $m->from('hello@app.com', 'Your Application');
            $m->to($email_data['email'], 'abc');
            $m->subject('Your Reminder hhhh!');
        });
 }

public function upload(){
	// dd('stop');
		 $row = 1;
		 if (($handle = fopen("Copy of Item master (1).csv", "r")) !== FALSE) {
				 while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
						 $num = count($data);
						 if($row > 1){
								 // print_r($data);
								 // exit;

DB::table('items')->insert(
								     array(
								            'code'     =>   $data[0], 
								            'category' =>   $data[1], 
								            'model'    =>   $data[2], 
								            'description' =>   $data[3], 
								            'make'     =>   $data[4], 
								            'uom'   =>   $data[5],
								            'hsn_code' => $data[6],
								            'rate' => $data[7],
								            'gst' => $data[8],
								            'specification' => $data[9],
								            'is_active' => $data[10]
								     )
								);
								 //DB::table("vendors")->where('engineer_id', $data[1])->where('id', $data[0])->update(array("warehouse"=>$data[2]));								 
								 // DB::table('users')->insert([
									// ['email' => 'taylor@example.com', 'votes' => 0]									
							//]);
						 }
						 $row++;
				 }
		 }
 }

}