Please enable JavaScript.
Coggle requires JavaScript to display documents.
Login Process, sales Exceutive, http://192.168.0.231/loancrm/customer-list…
-
sales Exceutive
Customer_Interest
Customer::where(['interest'=>1,'emp_id'=>Auth::user()->id])->count()
Customer_NotInterest
Customer::where(['interest'=>'NI','emp_id'=>Auth::user()->id])->count()
Customer_Followup
Customer::where(['interest'=>3,'emp_id'=>Auth::user()->id])->count()
Customer_CallBack
Customer::where(['interest'=>'CALLBK','emp_id'=>Auth::user()->id])->count()
Call
Customer::where(['emp_id'=>Auth::user()->id])->whereIn('interest', array('CALLBK','3'))->get()
-
-
Sum
Customer::where(['emp_id'=>Auth::user()->id,'interest'=>1])->sum('salary')
-
-