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 : Deal.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
use Prettus\Repository\Contracts\Transformable;
use Prettus\Repository\Traits\TransformableTrait;
use App\Models\PipelineStage;
use App\Models\State;
use DB;
use Auth;

/**
 * Class Deal.
 *
 * @package namespace App\Models;
 */
class

Deal extends Model implements Transformable
{
    use TransformableTrait;
    use SoftDeletes;

public $table = 'deals';

protected $perPage = 10;

protected $dates = ['deleted_at'];

//If created_by & updated_by columns exists
    protected static $created_update_by = true;

//If deleted_by columns exists
   protected static $deleted_by = true;

/**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'product_id',
        'order_no',
        'lead_source_id',
        'production_from',
        'client_id',
        'pipeline_stage_id',
        'deal_type_id',
        'priority_id',
        'referred_by',
        'owner_id',
        'open_date',
        'close_date',
        'order_number',
        'tip_amount',
        'shipping_address',
        'shipping_city',
        'shipping_state',
        'shipping_zip',
        'shipping_country',
        'china_doc',
        'china_image',
        'billing_address',
        'billing_city',
        'billing_state',
        'billing_zip',
        'billing_country',
        'invoice_number',
        'deal_type',
        'lead_type_id',
'special_instruction',
        'bd_owner_id',
        'ob_owner_id',
        'ob_open_date',
        'ob_close_date',
        'shipping_dollar_rate',
        'shipping_date',
        'billing_name',
        'billing_email',
        'billing_phone',
        'lost_reason',
        'production_cost',
        'customer_type',
        'dollar_rate',
        'production_billing_date',
        'est_weight',
        'est_shipping_amount',
        'est_production_cost',
        'weight',
        'shipping_amount',
        'description',
        'domain_id',
        'design_assign_date',
        'designer_id',
        'design_complete_date',
        'assign_to_template_date',
        'template_designer_id',
        'template_status',
        'bd_open_date',
        'bd_close_date',
        'china_note',

'designer_work',
        'reward_point',
        'facebook',
        'linkedin',

'reward_amount',
        'design_complete_status',
        'no_of_design',
        'show_follow_up',
        'ob_pipeline_stage_id',
        'template_complete_date',
        'sale_type',
        'ob_order_number',
       'lamination',
       'gsm',
       'pt',
        'foiling',
       'material',
       'uv',
       'embossing',
       'estimator_id',
       'website_link',
        'deal_lead_type_id'

];

/**
     * The attributes that should be casted to native types.
     *
     * @var array
     */
    //protected $casts = $CAST$;

/**
     * Validation rules
     *
     * @var array
     */
    //public static $rules = $RULES$

protected static function boot() {
        parent::boot();

if(self::$created_update_by){
            static::creating(function ($model) {
                $model->created_by = Auth::user()->id;
                $model->updated_by = Auth::user()->id;
            });

static::updating(function ($model) {
                $model->updated_by = Auth::user()->id;
            });
        }

if(self::$deleted_by){
            static::deleting(function ($model) {
                $model->deleted_by = Auth::user()->id;
            });
        }
    }
    public function setOpenDateAttribute($value)
    {
        $this->attributes['open_date'] = date_format(date_create($value),"Y-m-d");
    }

public function setCloseDateAttribute($value)
    {
        $this->attributes['close_date'] = ($value)?date_format(date_create($value),"Y-m-d"):null;
    }

public function getDealNumber($id){

return $this->where('id',$id)->first();

//   return $id;

}

public function user_closedwon_deals(){

return $this->hasMany(Deal::class,'id','id')->where('deals.deal_status','=','1')->where('pipeline_stage_id','=',4);

}
    public function getDeals($from,$to){

$first = date("Y-m-d", strtotime("first day of this month"));
        $last = date("Y-m-d", strtotime("last day of this month"));

$deals=   DB::select("SELECT * ,count(deal_products.`product_id`) as t FROM `deal_products`,deals WHERE `deal_id`=deals.id and deals.close_date >='2023-02-01' and deals.close_date <='2023-02-28' and deals.pipeline_stage_id=4 and deal_type_id=2 group by deal_products.product_id");

return $deals;

}

public function getDeal($pid,$from,$to){

if(!empty($from) && !empty($to)){

return $this->where('product_id',$pid)->where('deal_type_id','=','2')->where('deal_status','=','1')->whereIn('pipeline_stage_id',array('1','2','3','11'))->whereBetween('open_date', [date($from) , date($to)])->count();
        }

}

public function getDeadDeal($pid,$from,$to){

if(!empty($from) && !empty($to)){

return $this->where('product_id',$pid)->where('deal_type_id','=','2')->where('deal_status','=','1')->whereIn('pipeline_stage_id',array('13'))->whereBetween('close_date', [date($from) , date($to)])->count();
        }

}

public function getWonDeal($pid,$from,$to){

if(!empty($from) && !empty($to)){

return $this->where('product_id',$pid)->whereIn('pipeline_stage_id',array('4'))->where('deal_status','=','1')->whereBetween('close_date', [date($from) , date($to)])->where('deal_type_id','2')->count();
        }

}
    public function getlostDeal($pid,$from,$to){

if(!empty($from) && !empty($to)){

return $this->where('product_id',$pid)->whereIn('pipeline_stage_id',array('5'))->where('deal_status','=','1')->whereBetween('close_date', [date($from) , date($to)])->where('deal_type_id','2')->count();
        }

}
    public function Dealproduct()
    {
       // return $this->belongsToMany('App\Models\Product' ,'deals','product_id');
        return $this->hasMany('App\Models\Product' ,'id','product_id');

}
    public function products()
    {
        return $this->belongsToMany('App\Models\Product' ,'deal_products');
    }
    public function deal_amount()
    {
        return $this->hasMany('App\Models\DealAmount' ,'deal_id');
    }
    public function deal_amounts()
    {
        return $this->hasMany('App\Models\DealAmount' ,'deal_id');
    }
    public function dealProducts()
    {
        return $this->hasMany('App\Models\DealProduct' ,'deal_id');
    }

public function dealporducts(){

return $this->hasMany(DealProduct::class);

}
    public function getids($oderno){
        return $this->where('order_no',$oderno)->get();
    }
    public function user(){

return $this->belongsTo('App\Models\User' , 'owner_id');
    }

public function vendor()
    {
        return $this->belongsTo('App\Models\Vendors' ,'vendor_id');
    } public function domain()
    {
        return $this->belongsTo('App\Models\Domains' ,'domain_id');
    }
    public function courier()
    {
        return $this->belongsTo('App\Models\Courier' ,'courier_id');
    }

public function productdetails()
    {
        return $this->belongsToMany('App\Models\DealProduct' ,'deal_product_quantity_and_estimation_amounts','deal_product_id');
    }
    public function productprinting()
    {
        return $this->belongsToMany('App\Models\DealProduct' ,'deal_product_printings','deal_product_id');
    }
    public function pipelineStage()
    {
        return $this->belongsTo('App\Models\PipelineStage' , 'pipeline_stage_id');
    }

public function clientDetails()
    {
        return $this->hasMany(EmailPhoneDetail::class, 'model_id', 'client_id');  // Adjust 'deal_id' and 'id' as needed
    }

public function client()
    {
        return $this->belongsTo('App\Models\Client' , 'client_id');
    }
    public function client_email()
    {
        return $this->belongsTo('App\Models\EmailPhoneDetail' , 'client_id');
    }

public function emailPhoneDetails()
    {
        return $this->morphMany('App\Models\EmailPhoneDetail' , 'model');
    }

public function lead_source(){
        return $this->belongsTo('App\Models\LeadSource','lead_source_id');
    }
    public function owner()
    {
        return $this->belongsTo('App\Models\User' , 'owner_id');
    }

public function estimator()
    {
        return $this->belongsTo('App\Models\User' , 'estimator_id');
    }
    public function template_designer()
    {
        return $this->belongsTo('App\Models\User' , 'template_designer_id')->where('designer_status','active');
    }

public function owners()
    {
        return $this->belongsTo('App\Models\User' , 'owner_id');
    }
    public function bdowners()
    {
        return $this->belongsTo('App\Models\User' , 'bd_owner_id');
    }    public function obowners()
    {
        return $this->belongsTo('App\Models\User' , 'ob_owner_id');
    }
    public function files()
    {
        return $this->morphMany('App\Models\File' , 'fileable');
    }
    public function print_ready_designer()
    {
        return $this->belongsTo('App\Models\User' , 'designer_id')->where('designer_status','active');
    }

public function tracking()
    {
        return $this->hasMany('App\Models\Tracking' , 'deal_id');
    }
    public function activities()
    {
        return $this->morphMany('App\Models\Activity' , 'activityable')->orderBy('id','DESC');
    }

public function notes()
    {
        return $this->morphMany('App\Models\Note' , 'noteable')->orderBy('id','DESC');
    }

public function getPipelineStageNameById($pipelineStage_id)
    {
        return PipelineStage::select('name')->where('id',$pipelineStage_id)->first()->name;
    }

public function piplelinestage()
    {
        return $this->belongsTo('App\Models\PipelineStage' ,'pipeline_stage_id' );
    }

public function production_details()
    {
        return $this->hasMany('App\Models\Production' ,'deal_id' );
    }
    public function tracking_details()
    {
        return $this->hasMany('App\Models\Tracking' ,'deal_id' );
    }
    public function shipping_boxes_details()
    {
        return $this->hasMany('App\Models\DealShippingBoxes' ,'deal_id' );
    }

public function shipping_states(){
        return $this->belongsTo('App\Models\State' ,'shipping_state' );
    }
    public function billing_states(){
        return $this->belongsTo('App\Models\State' ,'billing_state' );
    }
    public function deals()
    {
        return $this->hasMany('App\Models\Deal' , 'pipeline_stage_id')->orderBy('id','desc');
    } public function ob_deal()
    {
        return $this->hasOne('App\Models\Deal' , 'ob_pipeline_stage_id');
    }

public function production(){

return $this->hasMany('App\Models\Production' , 'deal_id');
    }

public function closed_won(){

return $this->where('pipeline_stage_id',4)->where('deal_type_id',1);

}

public function closed_lost(){

return $this->hasMany(Deal::class,'id','id')->where('pipeline_stage_id',5)->where('deal_type_id',1);

}

public function leads(){

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

}

public function estimation(){

return $this->hasMany(Deal::class,'id','id')->where('pipeline_stage_id',2)->where('deal_type_id',1);

}

public function followup(){

return $this->hasMany(Deal::class,'id','id')->where('pipeline_stage_id',2)->where('deal_type_id',1);

}

public function inprogress(){

return $this->hasMany(Deal::class,'id','id')->where('pipeline_stage_id',11)->where('deal_type_id',1);

}

public function productions()
    {
        return $this->hasOne(Production::class);
    }

public function shipping()
    {
        return $this->hasOne(Tracking::class);
    }

public function user_follow_deals(){

return $this->hasMany(Deal::class,'owner_id','id')->where('deals.deal_status','=','1')->where('pipeline_stage_id','=',11);

}
    public function user_estimation_deals(){

return $this->hasMany(Deal::class,'owner_id','id')->where('deals.deal_status','=','1')->where('pipeline_stage_id','=',2);

}
    public function user_inprogress_deals(){

return $this->hasMany(Deal::class,'owner_id','id')->where('deals.deal_status','=','1')->where('pipeline_stage_id','=',3);

}

public function user_closedwon_new_deals(){

return $this->hasMany(Deal::class,'owner_id','id')->where('deals.deal_type_id','=','2')->where('deals.deal_status','=','1')->where('pipeline_stage_id','=',4);

} public function user_closedwon_repeat_deals(){

return $this->hasMany(Deal::class,'owner_id','id')->where('deals.deal_type_id','=','1')->where('deals.deal_status','=','1')->where('pipeline_stage_id','=',4);

}
    public function user_closedlost_deals(){

return $this->hasMany(Deal::class,'owner_id','id')->where('deals.deal_status','=','1')->where('pipeline_stage_id','=',5);

}
}

${this.title}

Code Editor : Deal.php