public function s3_file_upload()
{
$org_file_name = $_FILES["myfile"]["name"];
$tmp_file_name = $_FILES["myfile"]["tmp_name"];
$afinfo = explode('.', $org_file_name);
$s3_file_name = date('Ymd_His_') . str_random(10) . '.' . end($afinfo);
if ($_FILES["myfile"]['error'] == 0) {
rename($tmp_file_name, env('UPLOAD_PATH') . $s3_file_name);
\Common::make_product_img($s3_file_name, 720);
$res = \Common::s3_upload($s3_file_name, 'product/');
return $res;
} else {
return array('success' => false, 'message' => '', 'filename' => '');
}
}
public function profile_submit()
{
$data = \Request::all();
if (isset($data['image'])) {
$file_name = \Common::get_img_filename($data['image']);
\Common::make_square_img($file_name, 140);
$res = \Common::s3_upload($file_name, 'person/');
if ($res['success']) {
$person = Person::find(\Auth::user()->id);
$person->image = $res['filename'];
$person->save();
}
}
return \Redirect()->action('PersonController@profile');
}
public function edit_submit()
{
$data = \Request::all();
$company = Company::find(\Request::input('company_id'));
$company->name = $data['name'];
if (isset($data['image'])) {
$file_name = \Common::get_img_filename($data['image']);
\Common::make_square_img($file_name, 140);
$res = \Common::s3_upload($file_name, 'company/');
if ($res['success']) {
$company->ci = $res['filename'];
}
}
$company->status = $data['status_group'];
$company->save();
return \Redirect()->action('CompanyController@index');
}
public function newReviewMail($film, $review)
{
//Get All Followers of the loggedn in user
$users = new UsersController();
$followers = $users->getFollower(Auth::user()->id);
$movie = Movie::where('fl_id', $film)->first();
foreach ($followers as $subject) {
// if the subject is 1 or greater than 200 to avoid spam mail
if ($subject->id > 200 || $subject->id == 1) {
//The follower to whom this email will be sent
$user = User::where('id', $subject->id)->first();
if ($movie->fl_image) {
$filmImage = 'http://www.berdict.com/public/uploads/movie/' . $movie->fl_year . '/' . $movie->fl_image;
} else {
$filmImage = 'http://www.berdict.com/public/berdict/img/default_poster.jpg';
}
$filmUrl = 'http://www.berdict.com/movie/' . $movie->fl_id . '/' . Common::cleanUrl($movie->fl_name);
$subjectEmail = $user->usr_email;
$subjectName = $user->usr_fname . ' ' . $user->usr_lname;
$emailSubject = 'Hey ' . $user->usr_fname . '! Your friend ' . Auth::user()->usr_fname . ' ' . Auth::user()->usr_lname . ' wrote a review for ' . $movie->fl_name;
$data = array('subjectName' => $user->usr_fname, 'filmName' => $movie->fl_name, 'filmYear' => $movie->fl_year, 'filmUrl' => $filmUrl, 'filmImage' => $filmImage, 'filmReview' => $review->fr_review, 'reviewId' => $review->fr_id, 'objectId' => Auth::user()->id, 'objectName' => Auth::user()->usr_fname . ' ' . Auth::user()->usr_lname, 'objectUsername' => Auth::user()->username, 'filmName' => $movie->fl_name);
Mail::send('emails.newReview', $data, function ($message) use($subjectEmail, $subjectName, $emailSubject) {
$message->to($subjectEmail, $subjectName);
$message->subject($emailSubject);
$message->from('*****@*****.**', 'Berdict');
});
}
}
}
/**
* Show the application dashboard to the user.
*
* @return Response
*/
function BuildWhere($modifier = array())
{
//$modifier is an array suppose if you want to modify the fieldname for eg. firstname='aman' to p.firstname='aman'
// You need to define array like this $marr = array('firstname' =>'p.firstname' );
// filter data.
if (isset($_REQUEST['filterscount'])) {
$filterscount = $_REQUEST['filterscount'];
if ($filterscount > 0) {
$where = " WHERE (";
$tmpdatafield = "";
$tmpfilteroperator = "";
for ($i = 0; $i < $filterscount; $i++) {
// get the filter's value.
$filtervalue = addslashes($_REQUEST["filtervalue" . $i]);
if ($filtervalue == 'true' or $filtervalue == 'false') {
$filtervalue = filter_var($filtervalue, FILTER_VALIDATE_BOOLEAN);
}
// get the filter's condition.
$filtercondition = $_REQUEST["filtercondition" . $i];
// get the filter's column.
$filterdatafield = $_REQUEST["filterdatafield" . $i];
if (array_key_exists($filterdatafield, $modifier)) {
$filterdatafield = $modifier[$filterdatafield];
}
// get the filter's operator.
$filteroperator = $_REQUEST["filteroperator" . $i];
if ($tmpdatafield == "") {
$tmpdatafield = $filterdatafield;
} else {
if ($tmpdatafield != $filterdatafield) {
$where .= ")AND(";
} else {
if ($tmpdatafield == $filterdatafield) {
if ($tmpfilteroperator == 0) {
$where .= " AND ";
} else {
$where .= " OR ";
}
}
}
}
// build the "WHERE" clause depending on the filter's condition, value and datafield.
switch ($filtercondition) {
case "CONTAINS":
$where .= " " . $filterdatafield . " LIKE '%" . $filtervalue . "%'";
break;
case "SECRET_EQUAL":
$where .= " id ='" . Common::getDecode_hash_id($filtervalue) . "' ";
break;
case "DOES_NOT_CONTAIN":
$where .= " " . $filterdatafield . " NOT LIKE '%" . $filtervalue . "%'";
break;
case "EQUAL":
$where .= " " . $filterdatafield . " = '" . $filtervalue . "'";
break;
case "NOT_EQUAL":
$where .= " " . $filterdatafield . " <> '" . $filtervalue . "'";
break;
case "GREATER_THAN":
$where .= " " . $filterdatafield . " > '" . $filtervalue . "'";
break;
case "LESS_THAN":
$where .= " " . $filterdatafield . " < '" . $filtervalue . "'";
break;
case "GREATER_THAN_OR_EQUAL":
$where .= " " . $filterdatafield . " >= '" . $filtervalue . "'";
break;
case "LESS_THAN_OR_EQUAL":
$where .= " " . $filterdatafield . " <= '" . $filtervalue . "'";
break;
case "STARTS_WITH":
$where .= " " . $filterdatafield . " LIKE '" . $filtervalue . "%'";
break;
case "ENDS_WITH":
$where .= " " . $filterdatafield . " LIKE '%" . $filtervalue . "'";
break;
}
if ($i == $filterscount - 1) {
$where .= ")";
}
$tmpfilteroperator = $filteroperator;
$tmpdatafield = $filterdatafield;
}
return $where;
}
}
}
public function newLikeMail($subject, $film, $review, $random)
{
$user = User::where('id', $subject)->first();
$Ruser = User::where('id', $random)->first();
$movie = Movie::where('fl_id', $film)->first();
if ($movie->fl_image) {
$filmImage = 'http://www.berdict.com/public/uploads/movie/' . $movie->fl_year . '/' . $movie->fl_image;
} else {
$filmImage = 'http://www.berdict.com/public/berdict/img/default_poster.jpg';
}
$filmUrl = 'http://www.berdict.com/movie/' . $movie->fl_id . '/' . Common::cleanUrl($movie->fl_name);
$subjectEmail = $user->usr_email;
$subjectName = $user->usr_fname . ' ' . $user->usr_lname;
$emailSubject = '' . $user->usr_fname . '! ' . $Ruser->usr_fname . ' ' . $Ruser->usr_lname . ' agreed with your review for ' . $movie->fl_name;
$data = array('subjectName' => $user->usr_fname, 'filmName' => $movie->fl_name, 'filmYear' => $movie->fl_year, 'filmUrl' => $filmUrl, 'filmImage' => $filmImage, 'filmReview' => $review->fr_review, 'reviewId' => $review->fr_id, 'objectId' => $Ruser->id, 'objectName' => $Ruser->usr_fname . ' ' . $Ruser->usr_lname, 'objectUsername' => $Ruser->username, 'filmName' => $movie->fl_name);
Mail::send('emails.agree', $data, function ($message) use($subjectEmail, $subjectName, $emailSubject) {
$message->to($subjectEmail, $subjectName);
$message->subject($emailSubject);
$message->from('*****@*****.**', 'Berdict');
});
}
