@@ -167,23 +167,23 @@ |
||
167 | 167 | try { |
168 | 168 | $invoice_total = $request->admission_amount + $request->subscription_amount + $request->taxes_amount - $request->discount_amount; |
169 | 169 | $already_paid = PaymentDetail::leftJoin('trn_cheque_details', 'trn_payment_details.id', '=', 'trn_cheque_details.payment_id') |
170 | - ->whereRaw("trn_payment_details.invoice_id = $id AND (trn_cheque_details.`status` = 2 or trn_cheque_details.`status` IS NULL)") |
|
171 | - ->sum('trn_payment_details.payment_amount'); |
|
170 | + ->whereRaw("trn_payment_details.invoice_id = $id AND (trn_cheque_details.`status` = 2 or trn_cheque_details.`status` IS NULL)") |
|
171 | + ->sum('trn_payment_details.payment_amount'); |
|
172 | 172 | |
173 | 173 | $pending = $invoice_total - $already_paid; |
174 | 174 | |
175 | 175 | $status = \Utilities::setInvoiceStatus($pending, $invoice_total); |
176 | 176 | |
177 | 177 | Invoice::where('id', $id)->update(['invoice_number'=> $request->invoice_number, |
178 | - 'total'=> $invoice_total, |
|
179 | - 'status'=> $status, |
|
180 | - 'pending_amount'=> $pending, |
|
181 | - 'discount_amount'=> $request->discount_amount, |
|
182 | - 'discount_percent'=> $request->discount_percent, |
|
183 | - 'discount_note'=> $request->discount_note, |
|
184 | - 'tax'=> $request->taxes_amount, |
|
185 | - 'additional_fees'=> $request->additional_fees, |
|
186 | - 'note'=>' ', ]); |
|
178 | + 'total'=> $invoice_total, |
|
179 | + 'status'=> $status, |
|
180 | + 'pending_amount'=> $pending, |
|
181 | + 'discount_amount'=> $request->discount_amount, |
|
182 | + 'discount_percent'=> $request->discount_percent, |
|
183 | + 'discount_note'=> $request->discount_note, |
|
184 | + 'tax'=> $request->taxes_amount, |
|
185 | + 'additional_fees'=> $request->additional_fees, |
|
186 | + 'note'=>' ', ]); |
|
187 | 187 | |
188 | 188 | DB::commit(); |
189 | 189 | flash()->success('Discount was successfully updated'); |
@@ -52,9 +52,9 @@ discard block |
||
52 | 52 | if ($request->mode == \constPaymentMode::Cheque) { |
53 | 53 | // Store Cheque Details |
54 | 54 | $chequeData = ['payment_id'=> $payment_detail->id, |
55 | - 'number'=> $request->number, |
|
56 | - 'date'=> $request->date, |
|
57 | - 'status'=> \constChequeStatus::Recieved, ]; |
|
55 | + 'number'=> $request->number, |
|
56 | + 'date'=> $request->date, |
|
57 | + 'status'=> \constChequeStatus::Recieved, ]; |
|
58 | 58 | |
59 | 59 | $cheque_details = new ChequeDetail($chequeData); |
60 | 60 | $cheque_details->createdBy()->associate(Auth::user()); |
@@ -134,7 +134,7 @@ discard block |
||
134 | 134 | // Store Cheque Details |
135 | 135 | $cheque_detail = ChequeDetail::where('payment_id', $id)->first(); |
136 | 136 | $cheque_detail->update(['number' => $request->number, |
137 | - 'date' => $request->date, |
|
137 | + 'date' => $request->date, |
|
138 | 138 | ]); |
139 | 139 | $cheque_detail->updatedBy()->associate(Auth::user()); |
140 | 140 | $cheque_detail->save(); |
@@ -179,8 +179,8 @@ discard block |
||
179 | 179 | |
180 | 180 | $invoice_total = $invoice->total; |
181 | 181 | $payment_total = PaymentDetail::leftJoin('trn_cheque_details', 'trn_payment_details.id', '=', 'trn_cheque_details.payment_id') |
182 | - ->whereRaw("trn_payment_details.invoice_id = $invoice->id AND (trn_cheque_details.`status` = 2 or trn_cheque_details.`status` IS NULL)") |
|
183 | - ->sum('trn_payment_details.payment_amount'); |
|
182 | + ->whereRaw("trn_payment_details.invoice_id = $invoice->id AND (trn_cheque_details.`status` = 2 or trn_cheque_details.`status` IS NULL)") |
|
183 | + ->sum('trn_payment_details.payment_amount'); |
|
184 | 184 | |
185 | 185 | $amount_due = $invoice_total - $payment_total; |
186 | 186 | |
@@ -224,8 +224,8 @@ discard block |
||
224 | 224 | $invoice_total = $payment_detail->invoice->total; |
225 | 225 | |
226 | 226 | $payment_total = PaymentDetail::leftJoin('trn_cheque_details', 'trn_payment_details.id', '=', 'trn_cheque_details.payment_id') |
227 | - ->whereRaw("trn_payment_details.invoice_id = $payment_detail->invoice_id AND (trn_cheque_details.`status` = 2 or trn_cheque_details.`status` IS NULL)") |
|
228 | - ->sum('trn_payment_details.payment_amount'); |
|
227 | + ->whereRaw("trn_payment_details.invoice_id = $payment_detail->invoice_id AND (trn_cheque_details.`status` = 2 or trn_cheque_details.`status` IS NULL)") |
|
228 | + ->sum('trn_payment_details.payment_amount'); |
|
229 | 229 | |
230 | 230 | $amount_due = $invoice_total - $payment_total; |
231 | 231 |
@@ -129,8 +129,8 @@ discard block |
||
129 | 129 | { |
130 | 130 | // Member Model Validation |
131 | 131 | $this->validate($request, ['email' => 'unique:mst_members,email', |
132 | - 'contact' => 'unique:mst_members,contact', |
|
133 | - 'member_code' => 'unique:mst_members,member_code', ]); |
|
132 | + 'contact' => 'unique:mst_members,contact', |
|
133 | + 'member_code' => 'unique:mst_members,member_code', ]); |
|
134 | 134 | |
135 | 135 | // Start Transaction |
136 | 136 | DB::beginTransaction(); |
@@ -187,16 +187,16 @@ discard block |
||
187 | 187 | |
188 | 188 | // Storing Invoice |
189 | 189 | $invoiceData = ['invoice_number'=> $request->invoice_number, |
190 | - 'member_id'=> $member->id, |
|
191 | - 'total'=> $invoice_total, |
|
192 | - 'status'=> $paymentStatus, |
|
193 | - 'pending_amount'=> $pending, |
|
194 | - 'discount_amount'=> $request->discount_amount, |
|
195 | - 'discount_percent'=> $request->discount_percent, |
|
196 | - 'discount_note'=> $request->discount_note, |
|
197 | - 'tax'=> $request->taxes_amount, |
|
198 | - 'additional_fees'=> $request->additional_fees, |
|
199 | - 'note'=>' ', ]; |
|
190 | + 'member_id'=> $member->id, |
|
191 | + 'total'=> $invoice_total, |
|
192 | + 'status'=> $paymentStatus, |
|
193 | + 'pending_amount'=> $pending, |
|
194 | + 'discount_amount'=> $request->discount_amount, |
|
195 | + 'discount_percent'=> $request->discount_percent, |
|
196 | + 'discount_note'=> $request->discount_note, |
|
197 | + 'tax'=> $request->taxes_amount, |
|
198 | + 'additional_fees'=> $request->additional_fees, |
|
199 | + 'note'=>' ', ]; |
|
200 | 200 | |
201 | 201 | $invoice = new Invoice($invoiceData); |
202 | 202 | $invoice->createdBy()->associate(Auth::user()); |
@@ -220,8 +220,8 @@ discard block |
||
220 | 220 | |
221 | 221 | //Adding subscription to invoice(Invoice Details) |
222 | 222 | $detailsData = ['invoice_id'=> $invoice->id, |
223 | - 'plan_id'=> $plan['id'], |
|
224 | - 'item_amount'=> $plan['price'], ]; |
|
223 | + 'plan_id'=> $plan['id'], |
|
224 | + 'item_amount'=> $plan['price'], ]; |
|
225 | 225 | |
226 | 226 | $invoiceDetails = new InvoiceDetail($detailsData); |
227 | 227 | $invoiceDetails->createdBy()->associate(Auth::user()); |
@@ -231,9 +231,9 @@ discard block |
||
231 | 231 | |
232 | 232 | // Store Payment Details |
233 | 233 | $paymentData = ['invoice_id'=> $invoice->id, |
234 | - 'payment_amount'=> $request->payment_amount, |
|
235 | - 'mode'=> $request->mode, |
|
236 | - 'note'=> ' ', ]; |
|
234 | + 'payment_amount'=> $request->payment_amount, |
|
235 | + 'mode'=> $request->mode, |
|
236 | + 'note'=> ' ', ]; |
|
237 | 237 | |
238 | 238 | $paymentDetails = new PaymentDetail($paymentData); |
239 | 239 | $paymentDetails->createdBy()->associate(Auth::user()); |
@@ -243,9 +243,9 @@ discard block |
||
243 | 243 | if ($request->mode == 0) { |
244 | 244 | // Store Cheque Details |
245 | 245 | $chequeData = ['payment_id'=> $paymentDetails->id, |
246 | - 'number'=> $request->number, |
|
247 | - 'date'=> $request->date, |
|
248 | - 'status'=> \constChequeStatus::Recieved, ]; |
|
246 | + 'number'=> $request->number, |
|
247 | + 'date'=> $request->date, |
|
248 | + 'status'=> \constChequeStatus::Recieved, ]; |
|
249 | 249 | |
250 | 250 | $cheque_details = new ChequeDetail($chequeData); |
251 | 251 | $cheque_details->createdBy()->associate(Auth::user()); |
@@ -36,13 +36,13 @@ discard block |
||
36 | 36 | public function storeUser(Request $request) |
37 | 37 | { |
38 | 38 | $this->validate($request, ['name' => 'required|max:255', |
39 | - 'email' => 'required|email|max:255|unique:mst_users', |
|
40 | - 'password' => 'required|confirmed|min:6', ]); |
|
39 | + 'email' => 'required|email|max:255|unique:mst_users', |
|
40 | + 'password' => 'required|confirmed|min:6', ]); |
|
41 | 41 | |
42 | 42 | $user = User::create(['name' => $request['name'], |
43 | 43 | 'email' => $request['email'], |
44 | 44 | 'password' => bcrypt($request['password']), |
45 | - 'status'=> $request->status, ]); |
|
45 | + 'status'=> $request->status, ]); |
|
46 | 46 | |
47 | 47 | $user->save(); |
48 | 48 | |
@@ -142,9 +142,9 @@ discard block |
||
142 | 142 | DB::beginTransaction(); |
143 | 143 | try { |
144 | 144 | $role = Role::create(['name' => $request->name, |
145 | - 'display_name' => $request->display_name, |
|
146 | - 'description' => $request->description, |
|
147 | - ]); |
|
145 | + 'display_name' => $request->display_name, |
|
146 | + 'description' => $request->description, |
|
147 | + ]); |
|
148 | 148 | |
149 | 149 | if ($request->has('permissions')) { |
150 | 150 | $role->attachPermissions($request->permissions); |
@@ -179,9 +179,9 @@ discard block |
||
179 | 179 | $role = Role::findOrFail($id); |
180 | 180 | |
181 | 181 | $role->update(['name' => $request->name, |
182 | - 'display_name' => $request->display_name, |
|
183 | - 'description' => $request->description, |
|
184 | - ]); |
|
182 | + 'display_name' => $request->display_name, |
|
183 | + 'description' => $request->description, |
|
184 | + ]); |
|
185 | 185 | |
186 | 186 | //Updating permissions for the role |
187 | 187 | $DBpermissions = PermissionRole::where('role_id', $id)->select('permission_id')->lists('permission_id'); |
@@ -252,7 +252,7 @@ discard block |
||
252 | 252 | 'display_name' => $request->display_name, |
253 | 253 | 'description' => $request->description, |
254 | 254 | 'group_key' => $request->group_key, |
255 | - ]); |
|
255 | + ]); |
|
256 | 256 | |
257 | 257 | flash()->success('Permission was successfully created'); |
258 | 258 |
@@ -76,10 +76,10 @@ discard block |
||
76 | 76 | { |
77 | 77 | // For Tax calculation |
78 | 78 | JavaScript::put([ |
79 | - 'taxes' => \Utilities::getSetting('taxes'), |
|
80 | - 'gymieToday' => Carbon::today()->format('Y-m-d'), |
|
81 | - 'servicesCount' => Service::count(), |
|
82 | - ]); |
|
79 | + 'taxes' => \Utilities::getSetting('taxes'), |
|
80 | + 'gymieToday' => Carbon::today()->format('Y-m-d'), |
|
81 | + 'servicesCount' => Service::count(), |
|
82 | + ]); |
|
83 | 83 | list($invoice_number_mode, $invoiceCounter, $invoice_number) = $this->generateInvoiceNumber(); |
84 | 84 | |
85 | 85 | return view('subscriptions.create', compact('invoice_number', 'invoiceCounter', 'invoice_number_mode')); |
@@ -109,16 +109,16 @@ discard block |
||
109 | 109 | |
110 | 110 | // Storing Invoice |
111 | 111 | $invoiceData = ['invoice_number'=> $request->invoice_number, |
112 | - 'member_id'=> $request->member_id, |
|
113 | - 'total'=> $invoice_total, |
|
114 | - 'status'=> $paymentStatus, |
|
115 | - 'pending_amount'=> $pending, |
|
116 | - 'discount_amount'=> $request->discount_amount, |
|
117 | - 'discount_percent'=> $request->discount_percent, |
|
118 | - 'discount_note'=> $request->discount_note, |
|
119 | - 'tax'=> $request->taxes_amount, |
|
120 | - 'additional_fees'=> $request->additional_fees, |
|
121 | - 'note'=>' ', ]; |
|
112 | + 'member_id'=> $request->member_id, |
|
113 | + 'total'=> $invoice_total, |
|
114 | + 'status'=> $paymentStatus, |
|
115 | + 'pending_amount'=> $pending, |
|
116 | + 'discount_amount'=> $request->discount_amount, |
|
117 | + 'discount_percent'=> $request->discount_percent, |
|
118 | + 'discount_note'=> $request->discount_note, |
|
119 | + 'tax'=> $request->taxes_amount, |
|
120 | + 'additional_fees'=> $request->additional_fees, |
|
121 | + 'note'=>' ', ]; |
|
122 | 122 | |
123 | 123 | $invoice = new Invoice($invoiceData); |
124 | 124 | $invoice->createdBy()->associate(Auth::user()); |
@@ -142,8 +142,8 @@ discard block |
||
142 | 142 | |
143 | 143 | //Adding subscription to invoice(Invoice Details) |
144 | 144 | $detailsData = ['invoice_id'=> $invoice->id, |
145 | - 'plan_id'=> $plan['id'], |
|
146 | - 'item_amount'=> $plan['price'], ]; |
|
145 | + 'plan_id'=> $plan['id'], |
|
146 | + 'item_amount'=> $plan['price'], ]; |
|
147 | 147 | |
148 | 148 | $invoice_details = new InvoiceDetail($detailsData); |
149 | 149 | $invoice_details->createdBy()->associate(Auth::user()); |
@@ -153,9 +153,9 @@ discard block |
||
153 | 153 | |
154 | 154 | //Payment Details |
155 | 155 | $paymentData = ['invoice_id'=> $invoice->id, |
156 | - 'payment_amount'=> $request->payment_amount, |
|
157 | - 'mode'=> $request->mode, |
|
158 | - 'note'=> ' ', ]; |
|
156 | + 'payment_amount'=> $request->payment_amount, |
|
157 | + 'mode'=> $request->mode, |
|
158 | + 'note'=> ' ', ]; |
|
159 | 159 | |
160 | 160 | $payment_details = new PaymentDetail($paymentData); |
161 | 161 | $payment_details->createdBy()->associate(Auth::user()); |
@@ -267,10 +267,10 @@ discard block |
||
267 | 267 | $gymieDiff = $subscription->end_date->addDays($diff); |
268 | 268 | |
269 | 269 | JavaScript::put([ |
270 | - 'gymieToday' => Carbon::today()->format('Y-m-d'), |
|
271 | - 'gymieEndDate' => $subscription->end_date->format('Y-m-d'), |
|
272 | - 'gymieDiff' => $gymieDiff->format('Y-m-d'), |
|
273 | - ]); |
|
270 | + 'gymieToday' => Carbon::today()->format('Y-m-d'), |
|
271 | + 'gymieEndDate' => $subscription->end_date->format('Y-m-d'), |
|
272 | + 'gymieDiff' => $gymieDiff->format('Y-m-d'), |
|
273 | + ]); |
|
274 | 274 | |
275 | 275 | return view('subscriptions.edit', compact('subscription')); |
276 | 276 | } |
@@ -366,14 +366,14 @@ discard block |
||
366 | 366 | $subscription = Subscription::findOrFail($id); |
367 | 367 | |
368 | 368 | $already_paid = PaymentDetail::leftJoin('trn_cheque_details', 'trn_payment_details.id', '=', 'trn_cheque_details.payment_id') |
369 | - ->whereRaw("trn_payment_details.invoice_id = $subscription->invoice_id AND (trn_cheque_details.`status` = 2 or trn_cheque_details.`status` IS NULL)") |
|
370 | - ->sum('trn_payment_details.payment_amount'); |
|
369 | + ->whereRaw("trn_payment_details.invoice_id = $subscription->invoice_id AND (trn_cheque_details.`status` = 2 or trn_cheque_details.`status` IS NULL)") |
|
370 | + ->sum('trn_payment_details.payment_amount'); |
|
371 | 371 | |
372 | 372 | JavaScript::put([ |
373 | - 'taxes' => \Utilities::getSetting('taxes'), |
|
374 | - 'gymieToday' => Carbon::today()->format('Y-m-d'), |
|
375 | - 'servicesCount' => Service::count(), |
|
376 | - ]); |
|
373 | + 'taxes' => \Utilities::getSetting('taxes'), |
|
374 | + 'gymieToday' => Carbon::today()->format('Y-m-d'), |
|
375 | + 'servicesCount' => Service::count(), |
|
376 | + ]); |
|
377 | 377 | |
378 | 378 | return view('subscriptions.change', compact('subscription', 'already_paid')); |
379 | 379 | } |
@@ -403,15 +403,15 @@ discard block |
||
403 | 403 | } |
404 | 404 | |
405 | 405 | Invoice::where('id', $subscription->invoice_id)->update(['invoice_number'=> $request->invoice_number, |
406 | - 'total'=> $invoice_total, |
|
407 | - 'status'=> $paymentStatus, |
|
408 | - 'pending_amount'=> $pending, |
|
409 | - 'discount_amount'=> $request->discount_amount, |
|
410 | - 'discount_percent'=> $request->discount_percent, |
|
411 | - 'discount_note'=> $request->discount_note, |
|
412 | - 'tax'=> $request->taxes_amount, |
|
413 | - 'additional_fees'=> $request->additional_fees, |
|
414 | - 'note'=>' ', ]); |
|
406 | + 'total'=> $invoice_total, |
|
407 | + 'status'=> $paymentStatus, |
|
408 | + 'pending_amount'=> $pending, |
|
409 | + 'discount_amount'=> $request->discount_amount, |
|
410 | + 'discount_percent'=> $request->discount_percent, |
|
411 | + 'discount_note'=> $request->discount_note, |
|
412 | + 'tax'=> $request->taxes_amount, |
|
413 | + 'additional_fees'=> $request->additional_fees, |
|
414 | + 'note'=>' ', ]); |
|
415 | 415 | |
416 | 416 | foreach ($request->plan as $plan) { |
417 | 417 | $subscription->update(['plan_id'=> $plan['id'], |
@@ -423,14 +423,14 @@ discard block |
||
423 | 423 | //Adding subscription to invoice(Invoice Details) |
424 | 424 | |
425 | 425 | InvoiceDetail::where('invoice_id', $subscription->invoice_id)->update(['plan_id'=> $plan['id'], |
426 | - 'item_amount'=> $plan['price'], ]); |
|
426 | + 'item_amount'=> $plan['price'], ]); |
|
427 | 427 | } |
428 | 428 | |
429 | 429 | //Payment Details |
430 | 430 | $paymentData = ['invoice_id'=> $subscription->invoice_id, |
431 | - 'payment_amount'=> $request->payment_amount, |
|
432 | - 'mode'=> $request->mode, |
|
433 | - 'note'=> ' ', ]; |
|
431 | + 'payment_amount'=> $request->payment_amount, |
|
432 | + 'mode'=> $request->mode, |
|
433 | + 'note'=> ' ', ]; |
|
434 | 434 | |
435 | 435 | $payment_details = new PaymentDetail($paymentData); |
436 | 436 | $payment_details->createdBy()->associate(Auth::user()); |
@@ -20,7 +20,7 @@ |
||
20 | 20 | 'status', |
21 | 21 | 'created_by', |
22 | 22 | 'updated_by', |
23 | - ]; |
|
23 | + ]; |
|
24 | 24 | |
25 | 25 | protected $searchableColumns = [ |
26 | 26 | 'number' => 20, |