/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$faker = Faker\Factory::create();
/**
* academic institution
*/
factory(Member::class, 'institution', 5)->create()->each(function ($member) use($faker) {
Address::create(['type_id' => 1, 'member_id' => $member->id, 'country_code' => 'IND', 'state_code' => CsiChapter::find($member->csi_chapter_id)->state->state_code, 'address_line_1' => $faker->streetAddress, 'city' => State::filterByStateCode(CsiChapter::find($member->csi_chapter_id)->state->state_code)->first()->name, 'pincode' => 110052]);
$this->command->info('address done!');
Phone::create(['member_id' => $member->id, 'std_code' => 011, 'landline' => 47028209, 'country_code' => 91, 'mobile' => 1234567890]);
$this->command->info('phone done!');
$institution = Institution::create(['member_id' => $member->id, 'membership_type_id' => 1, 'salutation_id' => 1, 'name' => $faker->company, 'head_name' => $faker->name, 'head_designation' => $faker->word, 'email' => $faker->email, 'mobile' => 1234567890]);
$this->command->info('institution done!');
AcademicMember::create(['id' => $institution->id, 'institution_type_id' => 2]);
$this->command->info('academic done!');
$head = PaymentHead::getHead(1, 1)->first();
$payment = Payment::create(['paid_for' => $member->id, 'payment_head_id' => $head->id, 'service_id' => 1]);
$this->command->info('payment done!' . $member->id);
$narration = Narration::create(['payer_id' => $member->id, 'mode' => 1, 'transaction_number' => str_random(12), 'bank' => 'sbi', 'branch' => 'kamla nagar', 'date_of_payment' => $faker->date('d/m/Y'), 'drafted_amount' => $head->amount, 'proof' => '6.jpg']);
$this->command->info('narration done!');
Journal::create(['payment_id' => $payment->id, 'narration_id' => $narration->id, 'paid_amount' => $head->amount]);
$this->command->info('Journal done!');
RequestService::create(['service_id' => Service::getServiceIDByType('membership'), 'payment_id' => $payment->id, 'member_id' => $member->id]);
$this->command->info('request done!');
});
/**
* non academic institution
*/
factory(Member::class, 'institution', 5)->create()->each(function ($member) use($faker) {
Address::create(['type_id' => 1, 'member_id' => $member->id, 'country_code' => 'IND', 'state_code' => CsiChapter::find($member->csi_chapter_id)->state->state_code, 'address_line_1' => $faker->streetAddress, 'city' => State::filterByStateCode(CsiChapter::find($member->csi_chapter_id)->state->state_code)->first()->name, 'pincode' => 110052]);
$this->command->info('address done!');
Phone::create(['member_id' => $member->id, 'std_code' => 011, 'landline' => 47028209, 'country_code' => 91, 'mobile' => 1234567890]);
$this->command->info('phone done!');
$institution = Institution::create(['member_id' => $member->id, 'membership_type_id' => 2, 'salutation_id' => 1, 'name' => $faker->company, 'head_name' => $faker->name, 'head_designation' => $faker->word, 'email' => $faker->email, 'mobile' => 1234567890]);
$this->command->info('institution done!');
$head = PaymentHead::getHead(9, 1)->first();
$payment = Payment::create(['paid_for' => $member->id, 'payment_head_id' => $head->id, 'service_id' => 1]);
$this->command->info('payment done!' . $member->id);
$narration = Narration::create(['payer_id' => $member->id, 'mode' => 1, 'transaction_number' => str_random(12), 'bank' => 'sbi', 'branch' => 'kamla nagar', 'date_of_payment' => $faker->date('d/m/Y'), 'drafted_amount' => $head->amount, 'proof' => '6.jpg']);
$this->command->info('narration done!');
Journal::create(['payment_id' => $payment->id, 'narration_id' => $narration->id, 'paid_amount' => $head->amount]);
$this->command->info('Journal done!');
RequestService::create(['service_id' => Service::getServiceIDByType('membership'), 'payment_id' => $payment->id, 'member_id' => $member->id]);
$this->command->info('request done!');
});
/**
* professional individual
*/
factory(Member::class, 'individual', 5)->create()->each(function ($member) use($faker) {
Address::create(['type_id' => 1, 'member_id' => $member->id, 'country_code' => 'IND', 'state_code' => CsiChapter::find($member->csi_chapter_id)->state->state_code, 'address_line_1' => $faker->streetAddress, 'city' => State::filterByStateCode(CsiChapter::find($member->csi_chapter_id)->state->state_code)->first()->name, 'pincode' => 110052]);
$this->command->info('address done!');
Phone::create(['member_id' => $member->id, 'std_code' => 011, 'landline' => 47028209, 'country_code' => 91, 'mobile' => 1234567890]);
$this->command->info('phone done!');
$individual = Individual::create(['member_id' => $member->id, 'membership_type_id' => 4, 'salutation_id' => $faker->randomElement(range(1, 5)), 'first_name' => $faker->firstName, 'middle_name' => $faker->word, 'last_name' => $faker->lastname, 'card_name' => $faker->name, 'gender' => $faker->randomElement(['m', 'f']), 'dob' => $faker->date('d/m/Y')]);
$this->command->info('individual done!');
$professional = ProfessionalMember::create(['id' => $individual->id, 'organisation' => $faker->company, 'designation' => $faker->word]);
$this->command->info('professional done!');
$head = PaymentHead::getHead(17, 1)->first();
$payment = Payment::create(['paid_for' => $member->id, 'payment_head_id' => $head->id, 'service_id' => 1]);
$this->command->info('payment done!' . $member->id);
$narration = Narration::create(['payer_id' => $member->id, 'mode' => 1, 'transaction_number' => str_random(12), 'bank' => 'sbi', 'branch' => 'kamla nagar', 'date_of_payment' => $faker->date('d/m/Y'), 'drafted_amount' => $head->amount, 'proof' => '6.jpg']);
$this->command->info('narration done!');
Journal::create(['payment_id' => $payment->id, 'narration_id' => $narration->id, 'paid_amount' => $head->amount]);
$this->command->info('Journal done!');
RequestService::create(['service_id' => Service::getServiceIDByType('membership'), 'payment_id' => $payment->id, 'member_id' => $member->id]);
$this->command->info('request done!');
});
/**
* academic individual
*/
factory(Member::class, 'individual', 5)->create()->each(function ($member) use($faker) {
Address::create(['type_id' => 1, 'member_id' => $member->id, 'country_code' => 'IND', 'state_code' => CsiChapter::find($member->csi_chapter_id)->state->state_code, 'address_line_1' => $faker->streetAddress, 'city' => State::filterByStateCode(CsiChapter::find($member->csi_chapter_id)->state->state_code)->first()->name, 'pincode' => 110052]);
$this->command->info('address done!');
Phone::create(['member_id' => $member->id, 'std_code' => 011, 'landline' => 47028209, 'country_code' => 91, 'mobile' => 1234567890]);
$this->command->info('phone done!');
$individual = Individual::create(['member_id' => $member->id, 'membership_type_id' => 3, 'salutation_id' => $faker->randomElement(range(1, 5)), 'first_name' => $faker->firstName, 'middle_name' => $faker->word, 'last_name' => $faker->lastname, 'card_name' => $faker->name, 'gender' => $faker->randomElement(['m', 'f']), 'dob' => $faker->date('d/m/Y')]);
$this->command->info('individual done!');
$student_details = StudentMember::create(['id' => $individual->id, 'student_branch_id' => 1, 'college_name' => $faker->company, 'course_name' => $faker->word, 'course_branch' => $faker->word, 'course_duration' => 3]);
$this->command->info('student done!');
$head = PaymentHead::getHead(21, 1)->first();
$payment = Payment::create(['paid_for' => $member->id, 'payment_head_id' => $head->id, 'service_id' => 1]);
$this->command->info('payment done!' . $member->id);
$narration = Narration::create(['payer_id' => $member->id, 'mode' => 1, 'transaction_number' => str_random(12), 'bank' => 'sbi', 'branch' => 'kamla nagar', 'date_of_payment' => $faker->date('d/m/Y'), 'drafted_amount' => $head->amount, 'proof' => '6.jpg']);
$this->command->info('narration done!');
Journal::create(['payment_id' => $payment->id, 'narration_id' => $narration->id, 'paid_amount' => $head->amount]);
$this->command->info('Journal done!');
RequestService::create(['service_id' => Service::getServiceIDByType('membership'), 'payment_id' => $payment->id, 'member_id' => $member->id]);
$this->command->info('request done!');
});
}
private function storeAcademicInstitution()
{
$var = DB::transaction(function ($connection) {
$membership_period = Input::get('membership-period');
$institution_type = Input::get('institution_type');
$nameOfInstitution = Input::get('nameOfInstitution');
$country = Input::get('country');
$state = Input::get('state');
$chapter = Input::get('chapter');
$address = Input::get('address');
$city = Input::get('city');
$pincode = Input::get('pincode');
$email1 = Input::get('email1');
$email2 = Input::get('email2');
$std = Input::get('std');
$phone = Input::get('phone');
$salutation = Input::get('salutation');
$headName = Input::get('headName');
$headDesignation = Input::get('headDesignation');
$headEmail = Input::get('headEmail');
$country_code = Input::get('country-code');
$mobile = Input::get('mobile');
$paymentMode = Input::get('paymentMode');
$tno = Input::get('tno');
$drawn = Input::get('drawn');
$bank = Input::get('bank');
$branch = Input::get('branch');
$paymentReciept = Input::file('paymentReciept');
$amountPaid = Input::get('amountPaid');
$member = new Member();
$num = $country_code . '-' . $mobile;
$member->membership_id = 1;
$membership_type = 1;
$member->csi_chapter_id = $chapter;
$member->email = $email1;
$member->email_extra = $email2;
$member->password = bcrypt('1234');
$member->save();
$member->id;
$filename = $member->id . '.';
$filename .= $paymentReciept->getClientOriginalExtension();
Address::create(['type_id' => 1, 'member_id' => $member->id, 'country_code' => $country, 'state_code' => $state, 'address_line_1' => $address, 'city' => $city, 'pincode' => $pincode]);
Phone::create(['member_id' => $member->id, 'std_code' => $std, 'landline' => $phone]);
$paymentReciept->move(storage_path('uploads/payment_proofs'), $filename);
$institution = Institution::create(['member_id' => $member->id, 'membership_type_id' => $membership_type, 'salutation_id' => $salutation, 'name' => $nameOfInstitution, 'head_name' => $headName, 'head_designation' => $headDesignation, 'email' => $headEmail, 'country_code' => $country_code, 'mobile' => $mobile]);
$academic_member = AcademicMember::create(['id' => $institution->id, 'institution_type_id' => $institution_type]);
// 2nd arg is currency.. needs to be queried to put here
$head = PaymentHead::getHead($membership_period, 1)->first();
$payment = Payment::create(['paid_for' => $member->id, 'payment_head_id' => $head->id, 'service_id' => 1]);
$narration = Narration::create(['payer_id' => $member->id, 'mode' => $paymentMode, 'transaction_number' => $tno, 'bank' => $bank, 'branch' => $branch, 'date_of_payment' => $drawn, 'drafted_amount' => $head->amount, 'paid_amount' => $amountPaid, 'proof' => $filename]);
$journal = Journal::create(['payment_id' => $payment->id, 'narration_id' => $narration->id]);
$request = RequestService::create(['service_id' => Service::getServiceIDByType('membership'), 'member_id' => $member->id]);
return $member;
});
return $var;
}
private function storeStudentIndividual()
{
$var = DB::transaction(function ($connection) {
$membership_period = Input::get('membership-period');
$salutation = Input::get('salutation');
$fname = Input::get('fname');
$mname = Input::get('mname');
$lname = Input::get('lname');
$card_name = Input::get('card_name');
$dob = Input::get('dob');
$gender = Input::get('gender');
$country = Input::get('country');
$state = Input::get('state');
$stud_branch = Input::get('stud_branch');
$address = Input::get('address');
$city = Input::get('city');
$pincode = Input::get('pincode');
$college = Input::get('college');
$course = Input::get('course');
$cbranch = Input::get('cbranch');
$cduration = Input::get('cduration');
$email1 = Input::get('email1');
$email2 = Input::get('email2');
$std = Input::get('std');
$phone = Input::get('phone');
$country_code = Input::get('country-code');
$mobile = Input::get('mobile');
$paymentMode = Input::get('paymentMode');
$tno = Input::get('tno');
$drawn = Input::get('drawn');
$bank = Input::get('bank');
$branch = Input::get('branch');
$paymentReciept = Input::file('paymentReciept');
$amountPaid = Input::get('amountPaid');
$student_branch = AcademicMember::find($stud_branch);
$chapter = $student_branch->institution->member->csi_chapter_id;
$member = new Member();
$member->membership_id = 2;
// individual member
$membership_type = 3;
// student member
$member->csi_chapter_id = $chapter;
$member->email = $email1;
$member->email_extra = $email2;
$member->password = bcrypt('1234');
$member->save();
$member->id;
$filename = $member->id . '.';
$filename .= $paymentReciept->getClientOriginalExtension();
Address::create(['type_id' => 1, 'member_id' => $member->id, 'country_code' => $country, 'state_code' => $state, 'address_line_1' => $address, 'city' => $city, 'pincode' => $pincode]);
Phone::create(['member_id' => $member->id, 'std_code' => $std, 'landline' => $phone, 'country_code' => $country_code, 'mobile' => $mobile]);
$paymentReciept->move(storage_path('uploads/payment_proofs'), $filename);
$individual = Individual::create(['member_id' => $member->id, 'membership_type_id' => $membership_type, 'salutation_id' => $salutation, 'first_name' => $fname, 'middle_name' => $mname, 'last_name' => $lname, 'card_name' => $card_name, 'gender' => $gender, 'dob' => $dob]);
$student_details = StudentMember::create(['id' => $individual->id, 'student_branch_id' => $student_branch->id, 'college_name' => $college, 'course_name' => $course, 'course_branch' => $cbranch, 'course_duration' => $cduration]);
// 2nd arg is currency.. needs to be queried to put here
$head = PaymentHead::getHead($membership_period, 1)->first();
$payment = Payment::create(['paid_for' => $member->id, 'payment_head_id' => $head->id, 'service_id' => 1]);
$narration = Narration::create(['payer_id' => $member->id, 'mode' => $paymentMode, 'transaction_number' => $tno, 'bank' => $bank, 'branch' => $branch, 'date_of_payment' => $drawn, 'drafted_amount' => $head->amount, 'proof' => $filename]);
$journal = Journal::create(['payment_id' => $payment->id, 'narration_id' => $narration->id, 'paid_amount' => $amountPaid]);
$request = RequestService::create(['service_id' => Service::getServiceIDByType('membership'), 'payment_id' => $payment->id, 'member_id' => $member->id]);
return $member;
});
return $var;
}