private function _callbackFlow()
{
// 不正認証防止用に認証リクエスト用トークンをチェック
if ($_GET['oauth_token'] !== $_SESSION['tmp_twitter_oauth_token']) {
echo "Invalid Token!";
exit;
}
// twitterのユーザー情報の取得
$conn = new TwitterOAuth(TWITTER_CONSUMER_KEY, TWITTER_CONSUMER_SECRET, $_SESSION['tmp_twitter_oauth_token'], $_SESSION['tmp_twitter_oauth_token_secret']);
$tokens = $conn->oauth('oauth/access_token', ['oauth_verifier' => $_GET['oauth_verifier']]);
//取得したtwitterユーザー情報をDBに登録もしくは更新
$user = new \App\Model\User();
if ($user->existsTwitterUser($tokens['user_id'])) {
if (!$user->updateTwitterUser($tokens)) {
echo "update error!";
exit;
}
} else {
if (!$user->createTwitterUser($tokens)) {
echo "create error!";
exit;
}
}
//ログイン処理
session_regenerate_id(true);
$_SESSION['user'] = $user->findTwitterUser(['tw_user_id' => $tokens['user_id']]);
//認証リクエスト用トークンはもう使わないので消す
unset($_SESSION['tmp_twitter_oauth_token']);
unset($_SESSION['tmp_twitter_oauth_token_secret']);
header('Location: ' . SITE_URL);
exit;
}
protected function doPost()
{
//トークンチェック
if (!isset($_POST['token']) || $_POST['token'] !== $_SESSION['token']) {
echo "Invalid Token!";
exit;
}
//Viewの入力項目値の維持用
$this->setValues('user_email', $_POST['user_email']);
//入力値バリデーション
if (!$this->_isValidate()) {
$this->setErrors('message', '無効な入力値です');
return;
}
//ユーザー作成
$userModel = new \App\Model\User();
$user = $userModel->create(['email' => $_POST['user_email'], 'password' => $_POST['user_password']]);
if ($user) {
header('Location: ' . SITE_URL . 'login.php');
exit;
} else {
$this->setErrors('message', '新規アカウントの作成に失敗しました。既に登録されている可能性があります。');
return;
}
}
public function run()
{
if (!$this->isLoggedIn()) {
header('Location: ' . SITE_URL . 'login.php');
exit;
}
$userModel = new \App\Model\User();
$this->setValues('users', $userModel->findAll());
}
private function _login()
{
$userModel = new \App\Model\User();
$user = $userModel->findUser(['email' => $_POST['user_email'], 'password' => $_POST['user_password']]);
if ($user) {
session_regenerate_id(true);
$_SESSION["user"] = $user;
return true;
} else {
return false;
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$f = Faker\Factory::create();
$category = ['Kerajinan', 'Pakaian', 'Aksesoris', 'Lain-lain', 'Kuliner'];
DB::table('users')->delete();
DB::table('ukms')->delete();
DB::table('products')->delete();
DB::table('articles')->delete();
App\Model\User::create(['email' => '*****@*****.**', 'name' => 'Adhika Setya Pramudita', 'password' => bcrypt('123456')]);
App\Model\Ukm\Ukm::create(['name' => 'Kelompok Ibu-ibu Pengrajin Eceng Gondok Wates', 'long_description' => $f->text(), 'category' => 'Kerajinan', 'profile_picture' => '/images/ukm1.jpg', 'follower_number' => $f->numberBetween(1, 9999)]);
App\Model\Ukm\Ukm::create(['name' => 'UKM Batik Tulis Khas Ponorogo', 'long_description' => $f->text(), 'category' => 'Pakaian', 'profile_picture' => '/images/ukm2.jpg', 'follower_number' => $f->numberBetween(1, 9999)]);
App\Model\Ukm\Ukm::create(['name' => 'Kelompok Ibu-ibu Pengrajin Eceng Gondok Wates', 'long_description' => $f->text(), 'category' => 'Kerajinan', 'profile_picture' => '/images/ukm3.jpg', 'follower_number' => $f->numberBetween(1, 9999)]);
App\Model\Ukm\Ukm::create(['name' => 'Kelompok Ibu-ibu Pengrajin Eceng Gondok Wates', 'long_description' => $f->text(), 'category' => 'Kerajinan', 'profile_picture' => '/images/ukm4.jpg', 'follower_number' => $f->numberBetween(1, 9999)]);
App\Model\Ukm\Product::create(['name' => 'Kemeja batik tulis kualitas super', 'ukm_id' => 2, 'photo' => '\\images\\product\\batik-1.jpg', 'price' => $f->numberBetween(30, 150) * 1000]);
App\Model\Ukm\Product::create(['name' => 'Kemeja batik tulis kualitas super', 'ukm_id' => 2, 'photo' => '\\images\\product\\batik-2.jpg', 'price' => $f->numberBetween(30, 150) * 1000]);
App\Model\Ukm\Product::create(['name' => 'Kemeja batik tulis kualitas super', 'ukm_id' => 2, 'photo' => '\\images\\product\\batik-3.jpg', 'price' => $f->numberBetween(30, 150) * 1000]);
factory(App\Model\User::class, 10)->create();
factory(App\Model\Ukm\Ukm::class, 20)->create();
factory(App\Model\Ukm\Article::class, 20)->create();
factory(App\Model\Ukm\Product::class, 80)->create();
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('users')->delete();
App\Model\User::create(['email' => '*****@*****.**', 'name' => 'Adhika Setya Pramudita', 'password' => bcrypt('123456')]);
factory(App\Model\User::class, 50)->create();
}
$matched = true;
break;
}
}
if($matched){
$selected = $pdf_external_id == $template->id ? "selected='selected'" : "";
$selectTemplateHtml .= "<option value='". $template->id ."'".$selected.">". $template->name ."</option>";
}
}
}
//get variables
$vars = Array();
switch($local_template['name']){
case 'Account summary':
$userModel = new App\Model\User(new DBConnection());
$vars = $userModel->getTemplateFields();
break;
case 'Stock trade':
$tradeModel = new App\Model\StockTrades(new DBConnection());
$vars = $tradeModel->getTemplateFields();
break;
case 'Options trade':
$tradeModel = new App\Model\Trades(new DBConnection());
$vars = $tradeModel->getTemplateFields();
break;
case 'Transfer (deposit)':
case 'Transfer (withdraw)':
/**
* Get a validator for an incoming registration request.
*
* @param array $data
* @return \Illuminate\Contracts\Validation\Validator
*/
protected function validator(array $data)
{
return Validator::make($data, $this->user->getRegisterRules(), $this->user->getRegisterMessages());
}
<?php
require_once 'common.php';
check_logged_in();
if (isset($_SESSION['user']) && $_SESSION['user']['is_logged'] == 1) {
$PageTitle = getLang('ptitle_logged');
} else {
$PageTitle = getLang('ptitle_notlogged');
}
$db = new DBConnection();
$userModel = new App\Model\User($db);
$user = $userModel->getUserByUid($_SESSION['user']['user_account_num']);
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$db = new DBConnection();
$view = new App\View\View('mail/trade_request');
$view->form = $_POST;
$view->user = $user;
$to = getLang('site_notification');
$message = \Swift_Message::newInstance('Trade Request from ' . $user['user_account_name']);
$message->setFrom($to)->setTo($to)->setBody($view->render(), 'text/html');
$mailer = new App\Utility\Mailer($db);
$mailer->send($message);
$_SESSION['history_msg'] = 'Request was send';
header('Location: history.php');
exit;
}
$query = 'SELECT user_firstname, trading_type,user_lastname,user_account_num FROM users WHERE user_account_num="' . $_SESSION['user']['user_account_num'] . '" LIMIT 1';
$res = $db->rq($query);
$username = $db->fetch($res);
$buyStatuses = array(1 => 'Open', 2 => 'Pending', 3 => 'Disabled', 4 => 'Closed');
$sellStatuses = array(1 => 'Closed', 2 => 'Pending', 3 => 'Disabled');
});
});
#http://localhost/learnlaravel/public/db/test
Route::get('db/test', function () {
$userinfo = App\Model\User::find(2);
//通过主键id查询主键id=2的记录， 根据主键取出一条数据
$userinfo = App\Model\User::all();
//查询所有记录
#$userinfo = App\Model\User::findOrFail(3); #根据主键取出一条数据或抛出异常
$userinfo = App\Model\User::where('userid', '>', 1)->firstOrFail();
$users = $userinfo->get();
//返回结果集
foreach ($users as $user) {
var_dump($user->username);
}
#$userinfo = App\Model\User::where('userid', '>', 1)->take(10)->get(); //取前10条,
$num = App\Model\User::where('userid', '>', 1)->count();
//获取记录数
//echo $num ;
#$userinfo = App\Model\User::whereRaw('userid > ? and username = "******"', [1])->get();
/**
$user = new App\Model\User;
$user->username = '******';
$user->save();#保存记录
*/
//App\Model\User::create(['username' => 'to'.mt_rand(1,100),'pwd'=>12]);
#$affectedRows = App\Model\User::where('votes', '>', 100)->delete(); 删除符合条件的记录
//var_export($userinfo);
});
#http://localhost/learnlaravel/public/jellyusers
Route::controller('jellyusers', 'jelly\\UserController');
//$query='DELETE FROM users_logs WHERE user_account_num="'.$uDetails['user_account_num'].'"';
//$db->rq($query);
$query='DELETE FROM users WHERE user_uid="'.$_GET['uid'].'"';
$db->rq($query);
addLog('Back-end','Accounts',''.$uDetails['user_firstname'].' '.$uDetails['user_lastname'].' ('.$uDetails['user_account_num'].')',''.$_SESSION['admin']['name'].' ('.$_SESSION['admin']['refnum'].')','User deleted');
$db->close();
header('Location: users.php');
exit();
}
break;
case 'pdf':
$db = new DBConnection();
$userModel = new App\Model\User($db);
$tradesModel = new App\Model\Trades($db);
$transfersModel = new App\Model\Transfer($db);
$user = $userModel->getUserByUid($_GET['uid']);
$trades = $tradesModel->getUserTrades($user['user_account_num']);
$transfers = $transfersModel->getUserTransfers($user['user_account_num']);
$view = new App\View\View('user/account_statement');
$user['account_statement'] = $view->render(array(
'trades' => $trades,
'tradesBuyOptions' => $tradesModel->getOptions(),
'buyStatuses' => $tradesModel->getStatuses('buy'),
'sellStatuses' => $tradesModel->getStatuses('sell'),
'transfers' => $transfers,
'transfersOptions' => $transfersModel->getTypes(),
