/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DatabaseSeeder::truncateTable('phones');
$authors = \App\Author::all();
foreach ($authors as $author) {
\App\Phone::create(['author_id' => $author->id, 'phone_number' => '0' . (string) (9099990000 + $author->id)]);
}
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Station $station)
{
$this . validate($request, $this->rules);
//
$input = Input::all();
$input['station_id'] = $station->id;
Phone::create($input);
return Redirect::route('stations.show', $station->slug)->with('message', 'Phone created.');
}
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');
$address = Input::get('address');
$city = Input::get('city');
$pincode = Input::get('pincode');
$stud_branch = Input::get('stud_branch');
$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::Where('is_student_branch', $stud_branch)->first();
$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, 'paid_amount' => $amountPaid, 'proof' => $filename]);
$journal = Journal::create(['payment_id' => $payment->id, 'narration_id' => $narration->id]);
if (!is_null($member->id) && $member->id > 0) {
$user = $member;
}
return $member;
});
return $var;
}
public function phoneUpload(Request $request)
{
if ($request->hasFile('phonefile')) {
$date = Carbon::now()->format("Y_m_d");
$path = base_path() . "/up/" . "Phone/" . $date . "/";
$ext = $request->file('phonefile')->getClientOriginalExtension();
$extmine = $request->file('phonefile')->getClientMimeType();
$exts = collect(['application/vnd.ms-excel', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet']);
if ($exts->contains($extmine)) {
$request->file('phonefile')->move($path, Carbon::now()->timestamp . "." . $ext);
$filename = $path . Carbon::now()->timestamp . "." . $ext;
/* Import Excel file*/
Excel::load($filename, function ($reader) {
$rule = ['number' => 'required|unique:phones'];
$sheetsCount = $reader->getSheetCount();
for ($i = 0; $i < $sheetsCount; $i++) {
$sheets = $reader->getSheet($i)->toArray();
$sheetCount = count($sheets);
for ($j = 1; $j < $sheetCount; $j++) {
/*
* $table->integer('company_id')->unsigned();
$table->boolean('isShared')->default(false);
$table->string('department_name')->nullable();
$table->boolean('isActived')->default(true);
$table->string('number')->unique();
$table->integer('payment_company_id')->unsigned();
$table->integer('category_id')->unsigned();
*/
if ($sheets[$j][6] == 'EXT_CDMA') {
$data['number'] = trim($sheets[$j][1]);
$data['company_id'] = Company::where('name', trim($sheets[$j][3]))->value('id');
$data['payment_company_id'] = $data['company_id'];
$data['category_id'] = PhoneCategory::where('name', 'CDMA')->value('id');
$data['department_name'] = $sheets[$j][4];
$validator = \Validator::make($data, $rule);
if ($validator->fails()) {
} else {
Phone::create($data);
}
}
/* $validator=\Validator::make($data,$rule);
if($validator->fails()){
}else{
}*/
}
}
});
} else {
return back()->with('message', '文件格式不对');
}
}
return back();
}
/**
* 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!');
});
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, User $user)
{
if ($user->cannot('edit', $user)) {
return redirect('users');
}
//if(auth()->user()->id != $user->id) return redirect('users');
$this->validate($request, ['name' => 'required|max:30', 'email' => 'required|max:60|email|unique:users,email,' . $user->id, 'country_id' => 'integer|max:3', 'phone' => 'string']);
//$user->name = $request->name;//2
//$user->email = $request->email;//2
//$user->country()->associate($request->country_id);//2//update a belongs to
//$user->save();//2
if ($user->phone) {
//->user_id
Phone::where('user_id', $user->id)->update(['name' => $request->phone]);
} else {
Phone::create(['user_id' => $user->id, 'name' => $request->phone]);
//1
}
$user->roles()->sync(!$request->input('role_list') ? [] : $request->input('role_list'));
$user->update($request->all());
//1
return redirect('users/' . $user->id);
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$this->validate($request, Phone::validationRules());
Phone::create($request->all());
return redirect('/phone');
}
