@@ -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, |