Gecko [ thecigaretteboxes.com ]

Name	Size	Permission
Accessories.php	2 KB	-rw-r--r--
Accessorieslog.php	519 B	-rw-r--r--
Activity.php	1.62 KB	-rw-r--r--
Address.php	1.62 KB	-rw-r--r--
Administration.php	2.08 KB	-rw-r--r--
Administrationaccessorieslog.p...	545 B	-rw-r--r--
AgentRawData.php	1.97 KB	-rw-r--r--
Attandance.php	1.63 KB	-rw-r--r--
Attendance.php	1.76 KB	-rw-r--r--
AttendanceRequest.php	2.11 KB	-rw-r--r--
Client.php	2.99 KB	-rw-r--r--
ClientsReferalls.php	366 B	-rw-r--r--
Contact.php	734 B	-rw-r--r--
ContactAddress.php	1.72 KB	-rw-r--r--
ContactDetail.php	569 B	-rw-r--r--
Countries.php	390 B	-rw-r--r--
Courier.php	2 KB	-rw-r--r--
Currencies.php	392 B	-rw-r--r--
Deal.php	13.1 KB	-rw-r--r--
DealAmount.php	1.65 KB	-rw-r--r--
DealEstimation.php	1.4 KB	-rw-r--r--
DealEstimationlog.php	1.42 KB	-rw-r--r--
DealFollowUp.php	753 B	-rw-r--r--
DealNotification.php	367 B	-rw-r--r--
DealProduct.php	6.53 KB	-rw-r--r--
DealProductPrinting.php	1.92 KB	-rw-r--r--
DealProductQuantityAndEstimati...	1.9 KB	-rw-r--r--
DealShippingBoxes.php	294 B	-rw-r--r--
Department.php	1.62 KB	-rw-r--r--
Designation.php	1.6 KB	-rw-r--r--
Domains.php	1.61 KB	-rw-r--r--
EmailPhoneDetail.php	1.26 KB	-rw-r--r--
Embossing.php	1.59 KB	-rw-r--r--
EmployeeAssets.php	1.71 KB	-rw-r--r--
EmployeeBanks.php	1.8 KB	-rw-r--r--
EmployeeDocuments.php	1.66 KB	-rw-r--r--
EmployeeRelative.php	1.87 KB	-rw-r--r--
Employees.php	1.61 KB	-rw-r--r--
ExcelSales.php	589 B	-rw-r--r--
File.php	1007 B	-rw-r--r--
Foiling.php	1.59 KB	-rw-r--r--
Jobtitle.php	1.59 KB	-rw-r--r--
Lamination.php	1.62 KB	-rw-r--r--
LeadSource.php	1.64 KB	-rw-r--r--
LeadsType.php	1.39 KB	-rw-r--r--
Material.php	1.6 KB	-rw-r--r--
Metrial.php	1.58 KB	-rw-r--r--
Modelhasroles.php	678 B	-rw-r--r--
Module.php	1.1 KB	-rw-r--r--
Note.php	1.86 KB	-rw-r--r--
ObDeals.php	1.93 KB	-rw-r--r--
Opt.php	1.74 KB	-rw-r--r--
Outbound.php	435 B	-rw-r--r--
PF.php	1.7 KB	-rw-r--r--
Permission.php	935 B	-rw-r--r--
Pipeline.php	1.03 KB	-rw-r--r--
PipelineStage.php	1.9 KB	-rw-r--r--
Product.php	1.29 KB	-rw-r--r--
ProductColor.php	1.65 KB	-rw-r--r--
ProductMeasurementUnit.php	1.66 KB	-rw-r--r--
ProductPrinting.php	1.65 KB	-rw-r--r--
ProductStock.php	1.65 KB	-rw-r--r--
Production.php	880 B	-rw-r--r--
Projects.php	1.59 KB	-rw-r--r--
Projectslogs.php	596 B	-rw-r--r--
QuantityAndEstimation.php	652 B	-rw-r--r--
Relationships.php	398 B	-rw-r--r--
Reports.php	178 B	-rw-r--r--
Review.php	303 B	-rw-r--r--
Rewards.php	1.64 KB	-rw-r--r--
Role.php	892 B	-rw-r--r--
Salaries.php	2.66 KB	-rw-r--r--
SalaryDetails.php	1.64 KB	-rw-r--r--
Salarylogs.php	1.91 KB	-rw-r--r--
Setting.php	2 KB	-rw-r--r--
ShiftTimes.php	1.83 KB	-rw-r--r--
ShippingBoxes.php	1.75 KB	-rw-r--r--
State.php	1.6 KB	-rw-r--r--
TodayFollowUps.php	1.5 KB	-rw-r--r--
Tracking.php	3.49 KB	-rw-r--r--
User.php	11.71 KB	-rw-r--r--
UserLedger.php	1.84 KB	-rw-r--r--
UserLoan.php	1.76 KB	-rw-r--r--
UserLogin.php	1.49 KB	-rw-r--r--
UsersDaysoff.php	1.76 KB	-rw-r--r--
Uv.php	1.58 KB	-rw-r--r--
Vendors.php	1.8 KB	-rw-r--r--

Code Editor : DealProduct.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use DB;

class DealProduct extends Model
{
    use HasFactory;

protected $table = 'deal_products';

protected $fillable = [
        'deal_id',
        'product_id',
        'product_style_id',
        'product_length',
        'product_width',
        'product_height',
        'open_product_length',
        'open_product_width',
        'open_product_height',
        'insert_open_product_length',
        'insert_open_product_width',
        'insert_open_product_height',
        'product_size',
        'product_stock_id',
        'product_color_id',
        'product_measurement_unit_id',
        'open_product_length_two',
        'open_product_width_two',
        'open_product_height_two',
        'insert_open_product_length_two',
        'insert_open_product_width_two',
        'insert_open_product_height_two',
        'insert_open_product_length_three',
        'insert_open_product_width_three',
        'insert_open_product_height_three',
        'insert_product_height',
        'insert_product_width',
        'insert_product_height_two',
        'insert_product_width_two',
        'insert_product_height_three',
        'insert_product_width_three',

];

public function getDealProducts($id){

return   $getDealProducts = $this->where('deal_products.deal_id',$id)->get();

}

public function getProductPrinting(){
        return DB::table('product_printings')->get();
    }
    public function product_printings(){
        return $this->belongsToMany('App\Models\ProductPrinting' ,'deal_product_printings');

}
    public function dealProductQuantityAndEstimationAmount(){
        return $this->hasMany('App\Models\DealProductQuantityAndEstimationAmount' , 'deal_product_id');
    }

public function dealProductPrintings(){
        return $this->hasMany('App\Models\DealProductPrinting' , 'deal_product_id');
    }

public function quantityAndEstimation()
    {
        return $this->hasMany(\App\Models\QuantityAndEstimation::class, 'deal_product_id')
            ->where('checked_value', 1);
    }

public function productColor(){
        return $this->belongsTo(ProductColor::class);
    }public function product_stock(){
        return $this->belongsTo(ProductStock::class);
    }

public function product(){
        return $this->belongsTo(Product::class);
    }  public function products(){
        return $this->belongsTo(Product::class)->groupBy('name');
    }
    public function productstyle(){
        return $this->belongsTo('App\Models\Product','product_style_id');
    }
    public function product_unit(){
        return $this->belongsTo('App\Models\ProductMeasurementUnit','product_measurement_unit_id');
    }
    public function lead_source(){
        return $this->belongsTo(LeadSource::class);
    }

public function dealProductQuantityAndEstimationAmounts(){
        return $this->hasMany(DealProductQuantityAndEstimationAmount::class,'deal_product_id')->limit(1);
    }
    public function dealProductQuantityAndEstimationAmounts_sigle(){
        return $this->hasOne(DealProductQuantityAndEstimationAmount::class,'deal_product_id')->where('checked_value','=',1);
    }
    public function quantityAndEstimations() {
        return $this->hasMany(QuantityAndEstimation::class, 'deal_product_id');
    }
    public function closed_won(){

return $this->hasMany(Deal::class,"id",'deal_id')->whereIn('pipeline_stage_id', array('4'))->where('deal_status','=',1)->where('deal_type_id','=',2);

}

public function closed_lost(){

return $this->hasMany(Deal::class,"id",'deal_id')->whereIn('pipeline_stage_id', array('5'))->where('deal_status','=',1)->where('deal_type_id','=',2);

}   public function total_deal(){

return $this->hasMany(Deal::class,"id",'deal_id')->whereIn('pipeline_stage_id', array('1','2','3','11'))->where('deal_status','=',1)->orWhere('deal_type_id','=',2);

} public function progress_deal(){

return $this->hasMany(Deal::class,"id",'deal_id')->whereIn('pipeline_stage_id', array('3'))->where('deal_status','=',1)->where('deal_type_id','=',2);

}public function est_deal(){

return $this->hasMany(Deal::class,"id",'deal_id')->whereIn('pipeline_stage_id', array('2'))->where('deal_status','=',1)->where('deal_type_id','=',2);

}public function follow_deal(){

return $this->hasMany(Deal::class,"id",'deal_id')->whereIn('pipeline_stage_id', array('11'))->where('deal_status','=',1)->where('deal_type_id','=',2);

}public function lead_deal(){

return $this->hasMany(Deal::class,"id",'deal_id')->whereIn('pipeline_stage_id', array('1'))->where('deal_status','=',1)->where('deal_type_id','=',2);

}
        public function getDealID($pid){

return $this->where('product_id',$pid)->get();
        }

public function chat_deals(){

return $this->hasMany(Deal::class,"id",'deal_id')->where('lead_source_id','=',0)->where('deal_status','=',1);

}
    public function custom_quote_deals(){

return $this->hasMany(Deal::class,"id",'deal_id')->where('lead_source_id','=',1)->where('deal_status','=',1);;

}
    public function reference_deals(){

return $this->hasMany(Deal::class,"id",'deal_id')->where('lead_source_id','=',2)->where('deal_status','=',1);;

}

public function email_deals(){
       //return $this->belongsToMany(Deal::class,"deal_products",'deal_id')->where('lead_source_id','=',3);

return $this->hasMany(Deal::class,"id",'deal_id')->where('lead_source_id','=',3)->where('deal_status','=',1);;

}

public function call_deals(){

return $this->hasMany(Deal::class,"id",'deal_id')->where('lead_source_id','=',4)->where('deal_status','=',1);;

}
    public function organic_deals(){

return $this->hasMany(Deal::class,"id",'deal_id')->where('lead_source_id','=',5)->where('deal_status','=',1);;

}
    public function social_deals(){

return $this->hasMany(Deal::class,"id",'deal_id')->where('lead_source_id','=',6)->where('deal_status','=',1);;

}
    public function ppc_deals(){

return $this->hasMany(Deal::class,"id",'deal_id')->where('lead_source_id','=',7)->where('deal_status','=',1);;

}

public function mouseflow_deals(){

return $this->hasMany(Deal::class,"id",'deal_id')->where('lead_source_id','=',9)->where('deal_status','=',1);;

}
    public function dealProductPrinting(){
        return $this->belongsTo(ProductPrinting::class , 'product_printing_id');
    }

}

${this.title}

Code Editor : DealProduct.php