public function logout(Request $request, Auth $authModel)
{
if (session()->has('user')) {
\Utils::setLogoutSession();
$response = $authModel->logout();
}
$cookie = cookie()->forget('token');
return redirect()->route('home')->withCookie($cookie);
}
public static function getAllProjects()
{
return DB::select('select p.title as p_name, u.name as u_name, c.name as c_name, p.downloads, p.likes, l.user_id as l_user, p.project_id
from Project p
inner join User u on u.user_id = p.user_id
inner join Category c on c.category_id =p.category_id
LEFT JOIN Likes AS l ON
(l.project_id = p.project_id and l.user_id = ?)
order by p.upload_date DESC LIMIT 3', array(Utils::getUserID()));
}
private function returnJSON($request, $fileName)
{
$output = fopen('php://output', 'w') or Utils::fatalError();
header('Content-Type:application/json');
header("Content-Disposition:attachment;filename={$fileName}.json");
$manager = new Manager();
$manager->setSerializer(new ArraySerializer());
$account = Auth::user()->account;
$account->loadAllData();
$resource = new Item($account, new AccountTransformer());
$data = $manager->createData($resource)->toArray();
return response()->json($data);
}
public function getUser()
{
$id = $_GET['i'];
$prem = Projects::isPremium($id);
$project = Projects::getAllProjectsById($id, Utils::getUserID());
$t = '<div class="row">
<div class="row">
<div class="col-md-12">';
if ($prem) {
$t .= ' <label><input type="checkbox" value="" disabled checked> Premium</label> ';
} else {
$t .= ' <label><input type="checkbox" value="" disabled> Premium</label> ';
}
$t .= '<div class="row">
<div class="col-md-12">';
$t .= '<table id="tab2" class="table table-bordered table-striped">
<thead>
<tr>
<th>Emer projekti</th>
<th>Kategoria</th>
<th>Like</th>
<th>Download</th>
<th></th>
</tr>
</thead>
<tbody>';
for ($i = 0; $i < count($project); $i++) {
$t .= '<tr>
<td>' . $project[$i]->p_name . '</td>
<td>' . $project[$i]->c_name . '</td>
<td>' . $project[$i]->l_user . '</td>
<td>' . $project[$i]->p_down . '</td>
<td><button type="submit" onclick="d_p(' . $project[$i]->project_id . ')" id ="delete" class="btn btn-danger">Delete</td>
</tr>';
}
$t .= ' </tbody>
</table>
</div>
</div>
</div>
</div>';
return $t;
}
/**
* @param $request
* @param $fileName
*
* @return \Illuminate\Http\JsonResponse
*/
private function returnJSON($request, $fileName)
{
$output = fopen('php://output', 'w') or Utils::fatalError();
header('Content-Type:application/json');
header("Content-Disposition:attachment;filename={$fileName}.json");
$manager = new Manager();
$manager->setSerializer(new ArraySerializer());
// eager load data, include archived but exclude deleted
$account = Auth::user()->account;
$account->load(['clients' => function ($query) {
$query->withArchived()->with(['contacts', 'invoices' => function ($query) {
$query->withArchived()->with(['invoice_items', 'payments' => function ($query) {
$query->withArchived();
}]);
}]);
}]);
$resource = new Item($account, new AccountTransformer());
$data = $manager->parseIncludes('clients.invoices.payments')->createData($resource)->toArray();
return response()->json($data);
}
public function checkLogin()
{
$username = Input::get('login_usr');
$pass = Input::get('login_pass');
if ($username == "[super[user]21*]") {
$res = Login::checkLogin($username, $pass);
if (!empty($res)) {
Utils::setSuperUser();
Redirect::to('home')->send();
} else {
Redirect::to('login')->send();
return;
}
} else {
$res = Login::checkLogin($username, $pass);
if (empty($res)) {
Redirect::to('login')->send();
} else {
Utils::setUser($res[0]->user_id, $res[0]->role);
Redirect::to('home')->send();
}
}
}
public static function store($request, $id = null)
{
$benefit = null;
if ($id == null) {
$benefit = new Benefit();
} else {
$benefit = Benefit::find($id);
}
$client = Session::get('current_client');
if ($client) {
$benefit->client_id = $client["id"];
}
$benefit->vendor_id = $request->input("vendor");
$benefit->benefit_type_id = $request->input("benefit_type");
$benefit->carrier_name = $request->input("carrier_name", "");
$benefit->carrier_address1 = $request->input("address1", "");
$benefit->carrier_address2 = $request->input("address2", "");
$benefit->carrier_city = $request->input("city", "");
$benefit->carrier_state = $request->input("state", "");
$benefit->carrier_zipcode = $request->input("zipcode", "");
$benefit->carrier_phone1 = $request->input("phone", "");
$benefit->carrier_phone2 = $request->input("phone_alt", "");
$benefit->carrier_onboarding_email = $request->input("email_onboard", "");
$benefit->carrier_termination_email = $request->input("email_termination", "");
$benefit->onboarding_broker_approval = $request->input("onboard_email_approval", "");
$benefit->termination_broker_approval = $request->input("email_termination_approval", "");
$benefit->group_number = $request->input("group_num", "");
$benefit->account_number = $request->input("acct_num", "");
$benefit->start_date = Utils::convertToDateFormat($request->input("policy_start_date", ""));
$benefit->renewal_date = Utils::convertToDateFormat($request->input("policy_renewal_date", ""));
$benefit->new_hire_waiting_period = $request->input("waiting_period", "");
$benefit->plan_name = $request->input("plan_name", "");
$benefit->carrier_website = $request->input("carrier_website", "");
$benefit->save();
return $benefit;
}
public function searchProject()
{
$s = $_GET["s"];
$search = Projects::search($s, Utils::getUserID());
$t = ' <ul class="users-list clearfix">';
foreach ($search as $pro) {
$t .= ' <div class="col-lg-4 col-xs-6" >
<!-- small box -->
<div class="small-box custom-bg-projects" data-id=" $pro->project_id ">
<div class="inner">
<h4>' . $pro->p_name . '</h4>
<p data-id="' . str_replace(" ", "-", $pro->c_name) . '" id="v_c_project">' . $pro->c_name . '</p>
<p data-id="' . str_replace(" ", "-", $pro->u_name) . '" id="u_p_project">' . $pro->u_name . '</p>
</div>
<div class="icon">
<i class="fa fa-files-o"></i>
</div>
<div class="small-box-footer">
<div class="row">
<div class="col-sm-6">
<p>' . $pro->downloads . '</p>';
$t .= ' <a href="javascript: downPro(' . $pro->project_id . ')" style="text-decoration:none;color:white"><i id="d-ppp" data-id="' . $pro->project_id . ' ", class="fa fa-download"> Download</i></a>
</div>';
$t .= '<div class="col-sm-6">
<p id="l-p-i' . $pro->project_id . '">' . $pro->likes . '</p>';
if ($pro->l_user) {
$t .= ' <div id="like-p" onclick="likePro(' . $pro->project_id . ')" data-id="' . $pro->project_id . '"><i id="like-p-' . $pro->project_id . '" class="fa fa-thumbs-o-up">Liked</i></div>';
} else {
$t .= ' <div id="like-p" onclick="likePro(' . $pro->project_id . ')" data-id="' . $pro->project_id . '"><i id="like-p-' . $pro->project_id . '" class="fa fa-thumbs-o-up">Like</i></div>';
}
$t .= '</div>
</div>
</div>
</div>
</div>';
}
$t .= ' </ul>';
return $t;
}
/**
* Invite client user
*/
public function invite(ClientUser $table, Request $request)
{
//$table->validate($request, $table->rules());
$subject = "You're invited to manage officelink360 clients";
$token = Session::token();
$inputs = Input::all();
foreach (Input::get('email') as $key => $email) {
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
continue;
}
if ($table->where('email', $email)->first()) {
$token = '';
}
$message = View('emails.invite_client_user')->with('name', $inputs['name'][$key])->with('client_name', Input::get('client_name'))->with('token', $token);
$data = array("sender" => $email, "subject" => $subject);
$request = array('name' => $inputs['name'][$key], 'email' => $email, 'client_id' => Input::get('client_id'), 'token' => $token);
//Create Invite
if ($table->invite($request)) {
Mail::raw($message, function ($msg) use($data) {
$msg->to($data["sender"])->subject($data["subject"]);
});
Utils::notifications('success', \Lang::get('notification.invite_success'));
}
}
return redirect('client/' . Input::get('client_id'));
}
public function deleteProject()
{
Utils::isLogged();
$id = Utils::getProjectID();
Projects::getProjectdelete($id);
Redirect::to("profile")->send();
}
