public function SaveCampaignSummary() { $rules = array('listing_logo' => 'required', 'business_name' => 'required|between:1,50', 'business_summary' => 'required|between:2,140', 'min_investment' => 'required|numeric', 'money_valuation' => 'numeric', 'max_investment' => 'required|numeric', 'money_util' => 'required|between:2,300', 'categories' => 'required', 'website_address' => 'url', 'facebook_address' => 'url', 'twitter_address' => 'url', 'linkedin_address' => 'url'); $validator = Validator::make(Input::all(), $rules); // check if the validator failed ----------------------- if ($validator->fails()) { return Redirect::to(URL::previous())->withErrors($validator)->withInput()->with('activetab', Input::get('activetab')); } else { Helpers::logData("Saving Campaign Summary"); if (Helpers::isNewCampaign(Input::get('campaign'), 1)) { DB::table('tbl_campaign_summary')->insert(array('campaign_id' => Input::get('campaign'), 'business_name' => Input::get('business_name'), 'business_summary' => Input::get('business_summary'), 'min_investment' => Input::get('min_investment'), 'percent_equity' => Input::get('min_inv_percent'), 'pre_money_valuation' => Input::get('money_valuation'), 'max_investment' => Input::get('max_investment'), 'max_percent_equity' => Input::get('max_inv_percent'), 'money_use' => Input::get('money_util'), 'categories' => Input::get('categories'), 'facebook' => Input::get('facebook_address'), 'twitter' => Input::get('twitter_address'), 'linkedin' => Input::get('linkedin_address'), 'website' => Input::get('website_address'))); } else { DB::table('tbl_campaign_summary')->where('campaign_id', Input::get('campaign'))->update(array('business_name' => Input::get('business_name'), 'business_summary' => Input::get('business_summary'), 'min_investment' => Input::get('min_investment'), 'percent_equity' => Input::get('min_inv_percent'), 'pre_money_valuation' => Input::get('money_valuation'), 'max_investment' => Input::get('max_investment'), 'max_percent_equity' => Input::get('max_inv_percent'), 'money_use' => Input::get('money_util'), 'categories' => Input::get('categories'), 'facebook' => Input::get('facebook_address'), 'twitter' => Input::get('twitter_address'), 'linkedin' => Input::get('linkedin_address'), 'website' => Input::get('website_address'))); } return Redirect::to(URL::route('campaign_info', array('campaign' => Input::get('campaign'))))->with('activetab', Input::get('activetab')); } }
public function SendChat() { /* * get the recipient */ if (Input::get('contact_list') == '') { $target = DB::select("SELECT target_user_id,source_user_id from mradi_messages where message_hash = ?", array(Input::get('message_'))); $target = $target[0]->source_user_id == Session::get('account_id') ? $target[0]->target_user_id : $target[0]->source_user_id; } else { $target = Input::get('contact_list'); } $source = Session::get('account_id'); DB::select("update mradi_messages set message_hash=? where (source_user_id = ? and target_user_id = ?) \n or (source_user_id = ? and target_user_id = ?)", array(Input::get('message_'), $source, $target, $target, $source)); $queries = DB::getQueryLog(); $last_query = end($queries); Helpers::logData(print_r($last_query, true)); DB::table('mradi_messages')->insert(array('target_user_id' => $target, 'source_user_id' => Session::get('account_id'), 'message' => Input::get('message'), 'message_hash' => Input::get('message_'))); if (Input::get('contact_list') != '') { return Redirect::to(URL::previous()); } else { return Response::make('OK', 200); } }
public function validateUser() { $email = Input::get('_username'); $password = hash('sha256', Input::get('_password')); $account_type = Input::get('account_type') == 'other' ? 'Admin' : Input::get('account_type'); $results = DB::select("select * from accounts_dbx where email_address = ? and password = ? and account_type = ?", array($email, $password, $account_type)); if (empty($results)) { Helpers::logAction($email . " attempted to login as " . $account_type, false); Helpers::logData("select * from accounts_dbx where email_address = {$email} and password = {$password} and account_type = {$account_type}"); Session::flash('login_message', '<div class="alert alert-danger" style="width: 500px;">Error login! Please try again</div>'); return Redirect::route('login'); } else { $status = ''; foreach ($results as $item) { Session::put('email_address', $item->email_address); Session::put('account_id', $item->account_id); Session::put('username', $item->email_address); Session::put('firstname', $item->firstname); Session::put('fullnames', $item->firstname . " " . $item->lastname); Session::put('membersince', date("M. Y", strtotime($item->date_created))); Session::put('country', $item->country); Session::put('gender', $item->gender); Session::put('phone_no', $item->phone); Session::put('account_type', $item->account_type); Session::put('rec_per_page', Helpers::getGlobalValue('RECORDS_PER_PAGE')); Session::put('template_price', Helpers::getGlobalValue('TEMPLATE_COST')); $status = $item->account_status; } Helpers::logAction("Logged in successfully"); if ($status == 'ACTIVE') { return Redirect::route('dashboard'); } else { Session::flash('login_message', '<div class="alert alert-danger" style="width: 500px;">Error login! Account hasn\'t been activated yet</div>'); return Redirect::route('login'); } } }