';
}
echo json_encode(array('success'=>1,'add_html'=>$add_html,'contriname'=>$contriName));
exit;
}/*end of list of books function*/
/**
Function to delete contributor #modal #R
**/
public function deletecontributor(Request $request){
#redirect to home if user not a contributor
if(\Session::get('login_type') != 1){
return redirect()->route('dashboard');
}
#data
$data = $_POST;
#contributor's id
$contri_id = $data['contri_id'];
#publisher id
$id = Auth::user()->id;
#query
try{
$contributorss = DB::table('users')
->select('users.id','users.name','users.login_type','users.added_by')
->where('login_type', 2)
->where('added_by', $id)
->where(function ($query) {
$query->where('users.merged_contributor','!=',1)
->orWhereNull('users.merged_contributor');
})
->where('users.id', $contri_id)
->get();
}catch(\Exception $e){
return $e->getMessage();
}
#converting to array
$contributorss = json_decode(json_encode($contributorss),true);
#collecting the data
$contid = $contributorss[0]['id'];
$name = $contributorss[0]['name'];
echo json_encode(array('success'=>1,'contid'=>$contid,'name'=>$name));
exit;
}/* end of delete contributor function*/
/**
Merge contributor pop-up #prabh
**/
public function merge_contributor_popup(Request $request, $id){
#redirect to home if user not a contributor
if(\Session::get('login_type') != 1){
return redirect()->route('dashboard');
}
#logged in user
$id = Auth::user()->id;
#get name of main contributor
try{
$main_name = DB::Table('users')->where('id',$request->id)->value('name');
}catch(\Exception $e){
return $e->getMessage()." merge contri error1 ";
}
$main_name_html = '
Contributor: '.$main_name.'
';
#get other contributors
try{
$get_contri = DB::Table('users')
->select('id','name')
->where('id','!=',$request->id)
->where('added_by',$id)
->orderby('name','asc')
->where(function ($query) {
$query->where('merged_contributor','!=',1)
->orWhereNull('merged_contributor');
})
->get()
->toArray();
}catch(\Exception $e){
return $e->getMessage()." merge contri error2 ";
}
$list_of_contri = '';
foreach($get_contri as $item){
$list_of_contri .= '';
}
echo json_encode([
'success'=>1,
'list_of_contri'=>$list_of_contri,
'main_name'=>$main_name_html,
'main_id'=>$request->id,
]);
exit;
} ## merge_contributor_popup ends here
/**
Save merged contributor
**/
public function save_merged_contributor(Request $request){
#redirect to home if user not a contributor
if(\Session::get('login_type') != 1){
return redirect()->route('dashboard');
}
#logged in user
$id = Auth::user()->id;
#request array
$data = json_decode($request['data'],true);
$main_array = reset($data);
#for inserting into the merge_contrib table
$insert_merge_contri = array();
foreach( $main_array['sub_ids'] as $ids){
$insert_merge_contri[] = ['main_contri'=>$main_array['main_id'], 'sub_contri'=>$ids];
}
#check if sub id exists in the assign contributor, then get the books and ids
try{
$check_sub_id1 = DB::Table('assign_contributors')->select('book_id','role_id','percentage')->wherein('contributor_id',$main_array['sub_ids'])->get();
}catch(\Exception $e){
return $e->getMessage()." save_merged_contributor error1 ";
}
$check_sub_id1 = json_decode(json_encode($check_sub_id1), true);
#checking advances
try{
$check_adv_id = DB::Table('amount_details')->select('assigned_id','contributor_id','amount','quarter','year')->wherein('contributor_id',$main_array['sub_ids'])->get();
}catch(\Exception $e){
return $e->getMessage()." save_merged_contributor error1 ";
}
$check_adv_id = json_decode(json_encode($check_adv_id), true);
#if there is some advance added :
$check_sub_id2 = $check_sub_id1;
$checking_combination = array(); #for checking combination in db
foreach($check_sub_id1 as $key => $item){
$check_sub_id2[$key]['contributor_id'] = $main_array['main_id'] ;
#for checking combination in db
$checking_combination[$key]['contributor_id'] = $main_array['main_id'] ;
$checking_combination[$key]['book_id'] = $item['book_id'] ;
$checking_combination[$key]['role_id'] = $item['role_id'] ;
}
#if books found from sub ids assign it to the main id
if(!empty($check_sub_id1)){
#check if combination already existing
foreach($checking_combination as $item){
try{
$check_combination_vals[] = DB::Table('assign_contributors')->select('book_id','role_id','contributor_id')->where($item)->get()->toArray();
}catch(\Exception $e){
return $e->getMessage()." -> save_merged_contributor error4";
}
}
$check_combination_vals =json_decode(json_encode($check_combination_vals), true);
$check_combination = array();
foreach($check_combination_vals as $item){
foreach ($item as $values){
$check_combination[] = $values;
}
}
$check_sub_id2 = array_map("unserialize", array_unique(array_map("serialize", $check_sub_id2)));
#Difference of $check_sub_id2 and $check_combination for remove the same data.
$item12 = array();
if(empty($check_combination)){
$final_insertion = array();
foreach($check_sub_id2 as $key => $item){
unset($item['percentage']);
$item12[] = $item;
}
$item12 = array_values(array_map("unserialize", array_unique(array_map("serialize", $item12))));
foreach($check_sub_id2 as $key => $item){
if(array_key_exists($key, $item12)){
if(!in_array($item12[$key], $check_combination)){
$final_insertion[$key] = $item12[$key];
$final_insertion[$key]['percentage'] = $check_sub_id2[$key]['percentage'];
}
}
}
}else{
$final_insertion = array();
foreach($check_sub_id2 as $key => $item){
unset($item['percentage']);
if(!in_array($item, $check_combination)){
$final_insertion[$key] = $item;
$final_insertion[$key]['percentage'] = $check_sub_id2[$key]['percentage'];
}
}
}
#insert into assign contributors the filtered array
try{
$insert_in_assign = DB::Table('assign_contributors')->insert($final_insertion);
}catch(\Exception $e){
return $e->getMessage()." -> save_merged_contributor error2";
}
#if successfully added, assign an id to the contributors that they will not be visible in list
if($insert_in_assign == 1){
try{
$update_key = DB::table('users')->wherein('id',$main_array['sub_ids'])->update(['merged_contributor' => 1]);
}catch(\Exception $e){
return $e->getMessage()." -> save_merged_contributor error3";
}
#insert into merge_contributor table
try{
$insert_merge_table = DB::Table('merged_contributors')->insert($insert_merge_contri);
}catch(\Exception $e){
return $e->getMessage()." -> save_merged_contributor error5";
}
if($insert_merge_table ==1){
echo json_encode([
'success'=>1,
'succes_message'=>'Contributors merged successfully',
]);
exit;
}else{
echo json_encode([
'success'=>2,
'succes_message'=>'Some error occurred',
]);
exit;
}
}else{
echo json_encode([
'success'=>0,
'succes_message'=>'Some error occurred',
]);
}
}else{
#means the sub ids dont have any books assigned
#update key
try{
$update_key = DB::table('users')->wherein('id',$main_array['sub_ids'])->update(['merged_contributor' => 1]);
}catch(\Exception $e){
return $e->getMessage()." -> save_merged_contributor error3";
}
#insert into merge contri
try{
$insert_merge_table = DB::Table('merged_contributors')->insert($insert_merge_contri);
}catch(\Exception $e){
return $e->getMessage()." -> save_merged_contributor error5";
}
if($insert_merge_table ==1){
echo json_encode([
'success'=>1,
'succes_message'=>'Contributors merged successfully',
]);
exit;
}else{
echo json_encode([
'success'=>2,
'succes_message'=>'Some error occurred',
]);
exit;
}
}
}##save_merged_contributor
/**
save_credentials for email confirgurations
**/
public function save_credentials(Request $request){
#publisher's id
$id = Auth::user()->id;
#set email address
$email_address = $request->email_from;
#Initialize CURL:
$ch = curl_init('http://apilayer.net/api/check?access_key='.$this->access_key.'&email='.$email_address.'');
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
#Store the data:
$json = curl_exec($ch);
curl_close($ch);
#Decode JSON response:
$validationResult = json_decode($json, true);
#when newly added
if($request->form_type == 0 && $request->del_check == 0){
#collecting the details
$email = $request->email_from;
$name = $request->name_email;
if(!isset($validationResult['format_valid']) && !isset($validationResult['smtp_check'])){
return response()->json(array( 'success'=>0,'succes_message'=>$validationResult['error']['info'] ));
}
if ($validationResult['format_valid'] && $validationResult['smtp_check']) {
$insert_arr = ['publisher_id'=>$id,'email_id'=>$email,'email_name'=>$name];
try{
$insert_q = DB::table('emal_configuration')->insert($insert_arr);
}catch(\Exception $e){
return response()->json(array(
'success'=>0,
'succes_message'=>$e->getMessage(),
));
}
if($insert_q == 1){
return response()->json(array(
'success'=>1,
'succes_message'=>'Details Added Successfully',
));
}else{
return response()->json(array(
'success'=>0,
'succes_message'=>'Some error occured',
));
}
}else{
return response()->json(array(
'success'=>2,
'succes_message'=>'Please enter valid email id',
));
die;
}
}
#when record is updated
if($request->form_type == 1 && $request->del_check == 0){
#collecting the details
$email = $request->email_from;
$name = $request->name_email;
$update_arr = ['email_id'=>$email,'email_name'=>$name];
if(!isset($validationResult['format_valid']) && !isset($validationResult['smtp_check'])){
return response()->json(array( 'success'=>0,'succes_message'=>$validationResult['error']['info'], ));
}
if ($validationResult['format_valid'] && $validationResult['smtp_check']){
try{
$update_q = DB::table('emal_configuration')->where('publisher_id',$id)->update($update_arr);
}catch(\Exception $e){
return response()->json(array(
'success'=>0,
'succes_message'=>$e->getMessage(),
));
}
if($update_q == 1){
return response()->json(array(
'success'=>1,
'succes_message'=>'Details Updated successfully',
));
}elseif($update_q == 0){
return response()->json(array(
'success'=>0,
'succes_message'=>'No changes were done',
));
}else{
return response()->json(array(
'success'=>0,
'succes_message'=>'Some error occured',
));
}
}else{
return response()->json(array( 'success'=>2,'succes_message'=>'Please enter valid email id',));
}
}
#if delete request is sent
if($request->form_type == 1 && $request->del_check == 1){
#delete the record
try{
$del_q = DB::table('emal_configuration')->where('publisher_id',$id)->delete();
}catch(\Exception $e){
return response()->json(array(
'success'=>0,
'succes_message'=>$e->getMessage(),
));
}
if($del_q == 1){
return response()->json(array(
'success'=>1,
'succes_message'=>'Details deleted successfully',
'del_message'=>$del_q,
));
}else{
return response()->json(array(
'success'=>0,
'succes_message'=>'Some error occured',
'del_message'=>$del_q,
));
}
}
}#save_credentials
/**
check missing first name and last name of contributors -> Now no use of this function , we used this as testing of any code.
**/
public function check_names(Request $request){
#redirect to home if user not a contributor
if(\Session::get('login_type') != 1){
return redirect()->route('dashboard');
}
#logged in user
$id = Auth::user()->id;
#select contributors which are assigned multiple times to same book
// try{
// $contri = DB::table('assign_contributors')
// ->select('assign_contributors.contributor_id','assign_contributors.book_id','users.name','book_details.book_title')
// ->selectRaw('count(book_id) as occurences')
// ->leftJoin('users', function ($join) {
// $join->on('assign_contributors.contributor_id', '=', 'users.id');
// })
// ->leftJoin('book_details', function ($join) {
// $join->on('assign_contributors.book_id', '=', 'book_details.id');
// })
// ->groupby('assign_contributors.book_id','assign_contributors.contributor_id')
// //->havingRaw('count(assign_contributors.book_id) > 1')
// ->having('occurences', '>', 1)
// ->where(function ($query) {
// $query->where('users.merged_contributor','!=',1)
// ->orWhereNull('users.merged_contributor');
// })
// ->where(function ($query) {
// $query->where('book_details.merged_book','!=',1)
// ->orWhereNull('book_details.merged_book');
// })
// ->where('users.added_by',$id)
// ->get();
// }catch(\Exception $e){
// return $e->getMessage();
// }
// print'
';print_r($contri);die;
// try{
// $check_books = DB::Select("select `book_vol_containers`.id from `book_vol_containers` left join book_details on book_details.id = book_vol_containers.book_main_id where book_details.merged_book = 1 order BY `book_main_id` asc");
// }catch(\Exception $e){
// $e->getMessage();
// }
// $ids = array();
// foreach($check_books as $item){
// $item = get_object_vars($item);
// $ids[]=$item['id'];
// }
// try{
// $deletecontributor = DB::table('book_vol_containers')->wherein('id',$ids )->delete();
// }catch(\Exception $e){
// return $e->getMessage();
// }
// "
";print_r($deletecontributor);
die;
// try{
// $check_books = DB::Select("select dupes.book_main_id as inner_container,dupes.contained_book_id as inner_contained , book_vol_containers.added_by, book_vol_containers.book_main_id, book_vol_containers.contained_book_id,book_vol_containers.book_title from book_vol_containers INNER JOIN (select added_by , book_main_id, contained_book_id from book_vol_containers where added_by='".$id."') dupes on book_vol_containers.book_main_id = dupes.contained_book_id where book_vol_containers.added_by='".$id."'");
// }catch(\Exception $e){
// return $e->getMessage();
// }
// // print'
";print_r($update);
// die;
/* Update books with black_friday in it */
#parameters to check
/*$values_array = ['isbn_code','asin_code','comixology_code','google_gg_key','itune_code','upc','qb_classes','diamond_item_code'];
foreach($values_array as $data){
try{
$repeating_data[$data] = DB::select("select book_details.id, book_details.merged_book,book_details.book_title, book_details.asin_code,book_details.itune_code,book_details.comixology_code,book_details.google_gg_key,book_details.isbn_code,book_details.upc,book_details.qb_classes, book_details.diamond_item_code FROM book_details INNER JOIN (SELECT added_by,merged_book,book_title,comixology_code,asin_code,itune_code,diamond_item_code,google_gg_key,isbn_code,upc,qb_classes FROM book_details where added_by=".$id." GROUP BY ".$data." HAVING count(".$data.") > 1 ) dupes ON book_details.".$data." = dupes.".$data." where book_details.added_by=".$id." and book_details.".$data."<>'' ORDER BY book_details.".$data);
}catch(\Exception $e){
return $e->getMessage()." Line ".$e->getLine();
}
}#end foreach
$repeating_array = array(); #array used to store data
$repeating_data = json_decode(json_encode($repeating_data), true);
foreach($repeating_data as $key => $item){
$c = 0;
foreach($item as $d){
$c++;
if(stripos($d['book_title'], 'BLACK FRIDAY') ){
unset($d['merged_book']);
$repeating_array[] = $d;
}
}
}
#unique arrays
$repeating_array = array_unique($repeating_array, SORT_REGULAR);
///print'
.){kind=logo}
";
$content_email= ''.$content_email.'';
#for sending email
if(!empty($data['email'])){
if($data['password'] != ""){
//$this->index_mail(); #from basecontroller : setting for email
try{
$post = array('from' => $from_email,
'fromName' => $from_name,
'apikey' => env('SENDMAIL_TOKEN'),
'subject' => $subject_email,
'to' => $recipient,
'bodyHtml' => $content_email,
'bodyText' => 'Text Body',
'isTransactional' => false);
$ch = curl_init();
curl_setopt_array($ch, array(
CURLOPT_URL => env('SENDMAIL_API_URL'),
CURLOPT_POST => true,
CURLOPT_POSTFIELDS => $post,
CURLOPT_RETURNTRANSFER => true,
CURLOPT_HEADER => false,
CURLOPT_SSL_VERIFYPEER => false
));
$result=curl_exec ($ch);
curl_close ($ch);
$mail = Mail::raw([], function($message) use($recipient,$subject_email,$content_email,$from_email, $from_name) {
$message->replyTo($from_email, $from_name);
$message->to($recipient);
$message->subject($subject_email);
$message->setBody($content_email, 'text/html');
});
DB::table('users')->where('id',$add_contributor->id)->update(['email_sent'=>1]);
}catch(\Exception $e){
##if error occured delete the newly created contributor
$del_contri = DB::table('users')->where('id',$add_contributor->id)->delete();
if($del_contri == 1){
unset($_SESSION["url_val"]);
return response()->json(array( 'error'=>$e->getMessage(),'success'=>4));
}
}
}
}
#for sending email
$added_by = Auth::user()->id;
#inserting into the database
$email_content_arr = [
'email_type'=>2,
'added_by'=>$added_by,
'email_title'=>$subject_email,
'email_content'=>$data['email_content'],
'from_setting'=>0,
];
#insert into the db
try{
$insert_content = DB::Table('email_content')->insertGetId($email_content_arr);
}catch(\Exception $e){
return response()->json(array( 'error'=>$e->getMessage(),'success'=>0));
}
if($insert_content == "" || $insert_content == '0' || $insert_content == null){
unset($_SESSION["url_val"]);
return response()->json(array( 'error'=>'email content not added','success'=>0));
}
#insert into the history
#get contributor id newly created
$contributor_id = $add_contributor->id;
if($contributor_id == "" || $contributor_id == '0' || $contributor_id == null){
unset($_SESSION["url_val"]);
return response()->json(array( 'error'=>'Contributor id not found','success'=>0));
}
$history_insert_arr = [
'contributor_id'=> $add_contributor->id,
'email_content'=>$insert_content,
'added_by'=>$added_by,
'enable_view'=>1,
];
try{
$history_insert = DB::Table('email_history')->insertGetId($history_insert_arr);
}catch(\Exception $e){
return response()->json(array( 'error'=>$e->getMessage(),'success'=>0));
}
if($history_insert == "" || $history_insert == '0' || $history_insert == null){
return response()->json(array( 'error'=>'Contributor id not found','success'=>0));
}else{
return response()->json(array(
'msg'=> 'Account Details Updated Successfully',
'success'=>1,
));
}
}else{
return response()->json(array(
'msg'=> 'Account Details Updated Successfully.',
'success'=>1,
));
}
}elseif(empty($add_contributor)){
unset($_SESSION["url_val"]);
return response()->json(array(
'msg'=> 'Some error occured',
'success'=>0,
));
}elseif(!empty($add_contributor) && empty($data['email'])){
#add contributor session- start
session_start();
$_SESSION["url_val"] = "message";
return response()->json(array(
'msg'=> 'Account Details Updated Successfully',
'success'=>1,
));
}
}
}/** ends add contributor function**/
/**
To get states in add contributor page
**/
public function getStateList(Request $request){
#request of country
$country_id = $request->country_id;
#get the state associated with that country
try{
$states_db = DB::table("state")
->where('country_id', $country_id)->orderby('state','asc')
->pluck("state","id");
}catch (\Exception $e) {
return $e->getMessage()."Line no_o".$e->getLine();
}
$states = array();
foreach($states_db as $s_id => $s_name){
#adding a space to prevent sorting of states by id in jason
$states[" ".$s_id] =$s_name; #converting id > int to string
}
return response()->json($states);
}
/**
To get cities in add contributor page
**/
public function getCityList(Request $request){
#request of state_id
#get the state associated with that country
try{
$cities_db = DB::table("city")
->where("state_id",$request->state_id)
->orderby("city","asc")
->pluck("city","id");
}catch (\Exception $e) {
return $e->getMessage()."Line no_p".$e->getLine();
}
$cities = array();
foreach($cities_db as $c_id => $c_name){
#adding a space to prevent sorting of cities by id in jason
$cities[" ".$c_id] =$c_name; #converting id > int to string
}
return response()->json($cities);
}
/**
Edit contributor view - load data in form
**/
public function edit_contributor_view(Request $request, $id){
#redirect to home if user not a contributor
if(\Session::get('login_type') != 1){
return redirect()->route('dashboard');
}
#load the countries in the drop from where the request of cities and state is being sent
try{
$countries = DB::table('country')->orderby('country','asc')->get();
}catch(\Exception $e){
return $e->getMessage()."Line no_q".$e->getLine();
}
#load the contributor's data from id
try{
$contributors = DB::table('users')
->select('users.id','users.password','users.last_name', 'users.first_name', 'users.middle_name', 'users.profile_image', 'users.w9_form', 'users.username', 'users.birth_date', 'users.country', 'users.state', 'users.city', 'users.postcode', 'users.phone_number','users.contract_date','users.address', 'users.facebook_link', 'users.twitter_link', 'users.instagram_link', 'users.bio', 'users.login_type','users.added_by', 'users.social_login', 'users.profile_img_type', 'users.instagram_id','users.balance', 'users.stage_name', 'users.contributor_comment', 'users.csv_id','users.merged_contributor','country.country as cval','state.state as sval','city.city as cityval','users.email')
->leftJoin('country', function ($join) {
$join->on('users.country', '=', 'country.id');
})
->leftJoin('state', function ($join) {
$join->on('users.state', '=', 'state.id');
})
->leftJoin('city', function ($join) {
$join->on('users.city', '=', 'city.id');
})
->where('users.id',$id)
->get();
}catch(\Exception $e){
return $e->getMessage()."Line no_r".$e->getLine();
}
#to show the list of states and cities
$country_id = 0;
$state_id = 0;
#get the country id and state id and collect the states and cities corresponding to them in arrays and show the list on edit contributor page
foreach($contributors as $contri){
$contri = get_object_vars($contri);
$country_id = $contri['country'];
$state_id = $contri['state'];
}
#states
try{
$states = DB::table('state')->select('state','id')->where('country_id',$country_id)->orderby('state','asc')->get();
}catch(\Exception $e){
return $e->getMessage()."Line states ".$e->getLine();
}
#cities
try{
$cities = DB::table('city')->select('city','id')->where('state_id',$state_id)->orderby('city','asc')->get();
}catch(\Exception $e){
return $e->getMessage()."Line cities ".$e->getLine();
}
return view('edit_contributor',compact('contributors','countries','states','cities'));
} /* ends edit load contributor function */
/**
Edit contributor
**/
public function edit_contributor(Request $request, $id){
#redirect to home if user not a contributor
if(\Session::get('login_type') != 1){
return redirect()->route('dashboard');
}
#added by publisher's id
$added_by = Auth::user()->id;
#get all data
$data = $request->all();
#getting password from sent in hidden field
$dbpassword = $request->dbpassword;
#checking if id sent, exists in table or not
try{
$checkid = User::where('id', '=', $id)->first();
}catch(\Exception $e){
return $e->getMessage()."Line no_s".$e->getLine();
}
#id does not exist
if ($checkid === null) {
return redirect('edit_contributor')->with("error","Looks like there is a problem. Please try again later");
}
#changing date format
$date1 = $request->DOB;
if(empty($date1)){
$dob="";
}else{
$dob = date("Y-m-d", strtotime($date1));
}
#changing date format
$contract_date1 = $request->contract_date;
#if date is empty , make the variable empty
if(empty($contract_date1)){
$contract_date = "";
}else{
$contract_date = date("Y-m-d", strtotime($contract_date1));
}
#validating
$validator = Validator::make($request->all(), [
'first_name' => 'required|max:255',
'last_name' => 'required|max:255',
'middle_name' => 'nullable|max:255',
'image' => 'image|mimes:jpeg,png,jpg,gif,svg|max:1024',
'w9form' => 'mimes:doc,docx,pdf',
'email' => 'nullable|email|unique:users,email,'.$id,
//'email' => 'nullable|email|unique:users,email,'.$id.',id,added_by,'.$added_by,
//'email' => 'nullable|email',
'DOB'=>'nullable',
'contract_date' =>'nullable',
'postal_code' => 'nullable|max:255',
'phone_number'=> 'nullable',
'contract_date'=>'nullable',
'address' => 'nullable|max:255',
'facebook' =>'max:255',
'twitter' =>'max:255',
'instagram' =>'max:255',
'bio' =>'nullable|min:30|max:255',
'country' =>'nullable|not_in:0',
'city' =>'nullable|not_in:0',
'state' =>'nullable|not_in:0',
//'password' => 'nullable|min:6',
'stage_name'=>'nullable|max:255',
]);
#returning errors back to view
if ($validator->fails()) {
return response()->json(array( 'error'=> $validator->getMessageBag()->toArray(),'success'=>0,));
}
##Email validate code start
$email_address = $data['email'];
#Initialize CURL:
$ch = curl_init('http://apilayer.net/api/check?access_key='.$this->access_key.'&email='.$email_address.'');
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
#Store the data:
$json = curl_exec($ch);
curl_close($ch);
#Decode JSON response:
$validationResult = json_decode($json, true);
if(!isset($validationResult['format_valid']) && !isset($validationResult['smtp_check'])){
return response()->json(array( 'error'=> $validationResult['error']['info'],'success'=>3)); die;
}
if($validationResult['format_valid'] && !$validationResult['smtp_check']) {
return response()->json(array( 'error'=> 'Invalid email','success'=>2)); die;
}
#if image is being added
if ($request->hasFile('image')) {
if($request->file('image')->isValid()) {
try {
$profile_img = time().'.'.$request->image->getClientOriginalExtension();
$request->image->move(public_path('/profilepic'), $profile_img);
} catch (\Exception $e) {
throw $this->createNotFoundException('Image not saved');
}
$profile_img_type = 1;
}
}
#if no image
if (! $request->hasFile('image')) {
if($request->profile_img_type == 1){
#get old value from db sent in hidden field
if ($request->has('db_image')) {
$profile_img = $request->db_image;
}else{
#no old value;no image saved in db;no new added > set var empty
$profile_img = "";
}
$profile_img_type = 1; #image uploaded manually
}
if($request->profile_img_type == 3){
#get old value from db sent in hidden field
if ($request->has('db_image')) {
$profile_img = $request->db_image;
}else{
#no old value;no image saved in db;no new added > set var empty
$profile_img = "";
}
$profile_img_type = 3; #uploaded from csv
}
}
#if w9 form is being added
if ($request->hasFile('w9form')) {
if($request->file('w9form')->isValid()) {
try {
$w9form = time().'.'.$request->w9form->getClientOriginalExtension();
$request->w9form->move(public_path('/w9form'), $w9form);
} catch (\Exception $e) {
throw $this->createNotFoundException('Form not saved');
}
}
}
#if no w9form
if (! $request->hasFile('w9form')) {
#get old value from db sent in hidden field
if ($request->has('db_w9form')) {
$w9form = $request->db_w9form;
}else{
#no old value;no form saved in db;no new added > set var empty
$w9form = "";
}
}
#if pwd is not changed
if(($request->password)==""){
$passwordgenerated = $dbpassword;
$sendpassword = ""; #variable to check if password is changed
}else{
#if password is changed
$passwordgenerated = bcrypt($request->password);
$sendpassword = $request->password; #contains pswd to mail the contributor
}
#update data
try{
$updatecontri = DB::table('users')->where('id', $id)->update([
'name' => $data['first_name']." ".$data['last_name'],
'first_name' => $data['first_name'],
'last_name' => $data['last_name'],
'middle_name' => $data['middle_name'],
'email' => $data['email'],
'password'=> $passwordgenerated,
'birth_date' => $dob,
'postcode' => $data['postal_code'],
'phone_number' => $data['phone_number'],
'contract_date'=> $contract_date,
'address' =>$data['address'],
'profile_image' => $profile_img,
'w9_form'=> $w9form,
'facebook_link' => $data['facebook'],
'twitter_link' => $data['twitter'],
'instagram_link' => $data['instagram'],
'bio' => $data['bio'],
'country' => $data['country'],
//'city' => $data['city'],
'city' => $data['city_name'],
//'state' => $data['state'],
'state' => $data['state_name'],
'remember_token' => $data['_token'],
'added_by' => $data['added_by'],
'stage_name'=>$data['stage_name'],
'profile_img_type'=>$profile_img_type,
//'updated_at'=>date("Y-m-d H:i:s")
]);
}catch (\Exception $e) {
return $e->getMessage()." ".$e->getLine().$e->getFile();
}
#if changes are saved
if($updatecontri == 1){
/*for sending email only when contributor password is changed*/
/*if(!empty($data['email'])){
if($sendpassword != ""){
try{
$user = array('user_email'=>$data['email'], "user_password" =>$sendpassword);
$mail = Mail::to($data['email'])->send(new EditContributor($user));
}catch(\Exception $e){
return $e->getMessage()." >> Email Error<< ".$e->getLine();
}
}
}*/
/*for sending email */
return back()->with("message","Contributor Details Updated Successfully");
}
#if no changes were done in the form
if($updatecontri == 0){
return back()->with("message","Contributor Details Updated Successfully");
}
#if changes are not saved
if(! $updatecontri){
return back()->with("error","Contributor details not updated");
}
}/*Edit contributor Action end */
/**
Excel Sheet generation
**/
public function get_export(Request $request){
#redirect to home if user not a contributor
if(\Session::get('login_type') != 1){
return redirect()->route('dashboard');
}
#id of the contributor
$id = Auth::user()->id;
#get the contributors and their given percentage along with books and roles
try{
$userdet = DB::raw("(select yearly_book_totals.totals,yearly_book_totals.year,bookdet.id,bookdet.assign_id,bookdet.book_title,bookdet.author_name,bookdet.contributor_id,bookdet.book_id,bookdet.role_id,bookdet.contributor_role,bookdet.percentage,bookdet.added_by from (select book_details.added_by,book_details.book_title,book_details.author_name,book_details.id,contri.book_id,contri.contributor_id ,contri.id as assign_id ,contri.role_id,contri.contributor_role,contri.percentage,contri.assigned_id from book_details left join (select assign_contributors.book_id,assign_contributors.contributor_id ,assign_contributors.id ,assign_contributors.percentage,assign_contributors.role_id,assign_contributors.id as assigned_id, contributor_roles.contributor_role from assign_contributors left join contributor_roles on assign_contributors.role_id = contributor_roles.id) as contri on book_details.id = contri.book_id ) as bookdet left join yearly_book_totals on yearly_book_totals.amount_id = bookdet.assign_id ) as book_detail");
$bookdetails = DB::table('book_detail')
->select('users.name','book_detail.contributor_role','book_detail.book_title','book_detail.percentage')
->from($userdet)
->leftJoin('users', function ($join) {
$join->on('book_detail.contributor_id', '=', 'users.id');
})
->where('book_detail.assign_id', '<>', '', 'and') //is not null
->where('book_detail.added_by', $id)
->where(function ($query) {
$query->where('users.merged_contributor','!=',1)
->orWhereNull('users.merged_contributor');
})
->orderby('users.name', 'asc')
->get();
}catch(\Exception $e){
return $e->getMessage();
}
$bookdetails = $bookdetails->toArray();
#creating heading of excel
$b_details = array();
$b_details[] = ['CONTRIBUTOR NAME', 'ROLES','BOOK TITLE','PERCENTAGE (%)'];
foreach($bookdetails as $bd){
$bd = get_object_vars($bd);
$b_details[] = $bd;
}
#code to create excel
return Excel::create('contributor_roles_'.date("m/d/Y"), function($excel) use ($b_details) {
$excel->setTitle('Books/Percentage');
$excel->setDescription('Percentage details');
$excel->sheet('mySheet', function($sheet) use ($b_details){
$sheet->fromArray($b_details, null, 'A1', false, false);
});
})->download('xls');
return redirect('home');
}/*Excel Sheet ends*/
/*
Function for contributors info #modals
*/
public function contributors_info(Request $request){
#redirect to home if user not a contributor
if(\Session::get('login_type') != 1){
return redirect()->route('dashboard');
}
#contributor's id
$dataid=$_POST['id'];
#publisher id
$id = Auth::user()->id;
#get info of the contributor
try{
$contributorss = DB::table('users')
->select('users.name','users.last_name', 'users.id', 'users.email', 'users.first_name', 'users.middle_name', 'users.profile_image', 'users.w9_form','users.username', 'users.birth_date', 'users.country','users.state', 'users.city', 'users.postcode', 'users.phone_number', 'users.contract_date', 'users.address', 'users.facebook_link', 'users.twitter_link', 'users.instagram_link', 'users.bio', 'users.login_type', 'users.added_by', 'users.profile_img_type', 'users.instagram_id', 'users.stage_name','users.merged_contributor', 'country.country','state.state','city.city')
->leftJoin('country', function ($join) {
$join->on('users.country', '=', 'country.id');
})
->leftJoin('state', function ($join) {
$join->on('users.state', '=', 'state.id');
})
->leftJoin('city', function ($join) {
$join->on('users.city', '=', 'city.id');
})
->where('login_type', 2)
->where('added_by', $id)
->where(function ($query) {
$query->where('users.merged_contributor','!=',1)
->orWhereNull('users.merged_contributor');
})
->where('users.id', $dataid)->get();
}catch(\Exception $e){
return $e->getMessage();
}
#collect into array - one contributor can have multiple books
$contributorslist = array();
foreach($contributorss as $item){
$item = get_object_vars($item);
$contributorslist[$item['id']]['user_details']['id']= $item['id'];
$contributorslist[$item['id']]['user_details']['name']= $item['name'];
$contributorslist[$item['id']]['user_details']['email']= $item['email'];
$contributorslist[$item['id']]['user_details']['last_name']= $item['last_name'];
$contributorslist[$item['id']]['user_details']['first_name']= $item['first_name'];
$contributorslist[$item['id']]['user_details']['middle_name']= $item['middle_name'];
$contributorslist[$item['id']]['user_details']['profile_image']= $item['profile_image'];
$contributorslist[$item['id']]['user_details']['w9_form']= $item['w9_form'];
$contributorslist[$item['id']]['user_details']['username']= $item['username'];
$contributorslist[$item['id']]['user_details']['birth_date']= $item['birth_date'];
$contributorslist[$item['id']]['user_details']['country']= $item['country'];
$contributorslist[$item['id']]['user_details']['state']= $item['state'];
$contributorslist[$item['id']]['user_details']['city']= $item['city'];
$contributorslist[$item['id']]['user_details']['postcode']= $item['postcode'];
$contributorslist[$item['id']]['user_details']['phone_number']= $item['phone_number'];
$contributorslist[$item['id']]['user_details']['contract_date']= $item['contract_date'];
$contributorslist[$item['id']]['user_details']['address']= $item['address'];
$contributorslist[$item['id']]['user_details']['facebook_link']= $item['facebook_link'];
$contributorslist[$item['id']]['user_details']['twitter_link']= $item['twitter_link'];
$contributorslist[$item['id']]['user_details']['instagram_link']= $item['instagram_link'];
$contributorslist[$item['id']]['user_details']['bio']= $item['bio'];
$contributorslist[$item['id']]['user_details']['login_type']= $item['login_type'];
$contributorslist[$item['id']]['user_details']['added_by']= $item['added_by'];
$contributorslist[$item['id']]['user_details']['stage_name']= $item['stage_name'];
$contributorslist[$item['id']]['user_details']['profile_img_type']= $item['profile_img_type'];
}
#collect the values that need in popup.
foreach($contributorslist as $key=>$value){
#name
$name = $value['user_details']['name'].'
';
#email
if((empty($value['user_details']['email'])) ){
$email = '-';
}else{
$email = ''.$value['user_details']['email'];
}
#Birth date
if((empty($value["user_details"]["birth_date"])) || ($value["user_details"]["birth_date"] == '0000-00-00')){
$birth_date = '-';
}else{
$birth_date = ''.$value['user_details']['birth_date'];
}
#Bio
if(!empty($value['user_details']['bio'])){
$bio = ''.$value['user_details']['bio'];
}else{
$bio = "This is bio of the contributor which is being added by the publisher. Please add the updated and bio related to the contributor's profile";
}
#Address
$address = $value['user_details']['address'];
#City
if(!($value['user_details']['city'])){
$city = 'No Record Found';
}else{
$city = $value['user_details']['city'];
}
#country
if(!($value['user_details']['country'])){
$country = 'No Record Found';
}else{
$country = $value['user_details']['country'];
}
#state
if(!( $value["user_details"]["state"] )){
$state = 'No Record Found';
}else{
$state = $value["user_details"]["state"];
}
#postcode
if(empty($value['user_details']['postcode'])){
$postcode = '-';
}else{
$postcode = $value['user_details']['postcode'];
}
#phone number
if(empty($value["user_details"]["phone_number"])){
$phone_number = '-';
}else{
$phone_number = $value["user_details"]["phone_number"];
}
#Date of contract
if((empty($value["user_details"]["contract_date"])) || ($value["user_details"]["contract_date"] == '0000-00-00')){
$contract_date = '-';
}else{
$contract_date = $value["user_details"]["contract_date"] ;
}
#W9 form
if(!($value["user_details"]["w9_form"])){
$w9form_status = '
