public function actionStart()
{
if ($this->game->isFinished()) {
return $this->redirect('/game/finished');
}
if ($this->game->isStarted()) {
return $this->redirect('/game/overview');
}
$this->game->start();
if ($this->game->isStarted()) {
$this->session->set('started', true);
$this->storage->save($this->game);
return $this->redirect('/game/overview');
}
}
/**
* @param string|null $ip
* @return Result
*/
public function ip($ip = null)
{
if ($ip === null) {
$ip = Yii::$app->request->getUserIP();
}
if (!array_key_exists($ip, $this->result)) {
$key = self::className() . ':' . $ip;
if ($this->session->offsetExists($key)) {
$this->result[$ip] = $this->session->get($key);
} else {
$result = $this->reader->get($ip);
$this->result[$ip] = new Result($result);
$this->session->set($key, $this->result[$ip]);
}
}
return $this->result[$ip];
}
/**
* Lists all CallHistory models.
* @return mixed
*/
public function actionIndex()
{
$searchModel = new CallHistorySearch();
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
$session = new Session();
$session->set('dataProvider', $dataProvider);
return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]);
}
/**
* Lists all CallSummary models.
* @return mixed
*/
public function actionIndex()
{
$searchModel = new CallSummarySearch();
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
// echo "<pre>";
// print_r($dataProvider);
$session = new Session();
$session->set('dataProviderCallSummary', $dataProvider);
return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]);
}
public function run()
{
$session = new Session();
if (!@oci_connect($this->username, $this->password, $this->dsn, "AL32UTF8")) {
$e = oci_error();
$session->set('oracle_error', $e['message']);
return false;
} else {
return true;
}
}
/**
* @param string $id
* @param array $params
* @return mixed|\yii\web\Response
* @throws \yii\base\InvalidRouteException
*/
public function runAction($id, $params = [])
{
// See if it's ok to view this controller->action anonymously
$resolvedActionName = $id ? $id : $this->defaultAction;
if (!$this->member && !in_array($resolvedActionName, $this->anonActions)) {
// nope
$this->session->set('redirectAfterLogin', $_SERVER['REQUEST_URI']);
return $this->redirect('/login');
} else {
return parent::runAction($id, $params);
}
}
/**
* Lists all CallHistory models.
* @return mixed
*/
public function actionIndex()
{
// $searchModel = new CallHistorySearch();
// $dataProvider = $searchModel->search(Yii::$app->request->queryParams);
$searchModel = new CallHistory();
$connection = Yii::$app->db;
if (isset($_GET['CallHistory'])) {
$monthStart = substr($_GET['CallHistory']['start_time'], 5, 2);
$monthEnd = substr($_GET['CallHistory']['end_time'], 5, 2);
$yearStart = substr($_GET['CallHistory']['start_time'], 0, 4);
$yearEnd = substr($_GET['CallHistory']['end_time'], 0, 4);
$startTime = $_GET['CallHistory']['start_time'];
$endTime = $_GET['CallHistory']['end_time'];
$Anumber = $_GET['CallHistory']['Anumber'];
$Bnumber = $_GET['CallHistory']['Bnumber'];
$Zon = $_GET['CallHistory']['Zon'];
$Trunk1 = $_GET['CallHistory']['Trunk1'];
$Trunk2 = $_GET['CallHistory']['Trunk2'];
$query = "SELECT * FROM (SELECT * FROM tbl_call_history_{$yearStart}{$monthStart} UNION SELECT * FROM tbl_call_history_{$yearEnd}{$monthEnd}) AS maho WHERE start_time BETWEEN '{$_GET['CallHistory']['start_time']}' AND '{$_GET['CallHistory']['end_time']}'";
$params = [];
if (!empty($Anumber)) {
$query .= " AND Anumber LIKE :Anumber";
$params = [':Anumber' => "%{$Anumber}%"];
}
if (!empty($Bnumber)) {
$query .= " AND Bnumber LIKE :Bnumber";
$params = [':Anumber' => "%{$Anumber}%"];
}
if (!empty($zon)) {
$query .= " AND Zon LIKE {$zon}";
$params = [':Zon' => "%{$Zon}%"];
}
if (!empty($Trunk1)) {
$query .= " AND Trunk1 LIKE :Trunk1";
$params = [':Trunk1' => "%{$Trunk1}%"];
}
if (!empty($Trunk2)) {
$query .= " AND Trunk2 LIKE :Trunk2'";
$params = [':Trunk2' => "%{$Trunk2}%"];
}
$data = $connection->createCommand($query)->bindValues($params)->queryAll();
} else {
$query = "SELECT * FROM (SELECT * FROM tbl_call_history_201509 UNION SELECT * FROM tbl_call_history_201509) AS maho ";
$data = $connection->createCommand($query)->queryAll();
}
$provider = new ArrayDataProvider(['allModels' => $data, 'sort' => ['attributes' => ['start_time', 'ed_time', 'Anumber', 'Bnumber', 'Zon', 'Trunk1', 'Trunk2']], 'pagination' => ['pageSize' => empty($_GET['per-page']) ? 10 : $_GET['per-page']]]);
$session = new Session();
$session->set('dataProviderCallHistory', $provider);
return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $provider]);
}
/**
* Знайти користувача
* @param string $username Логін користувача
* @return static|null
*/
public static function findByUsername($username)
{
$instagram = new Instagram($username);
if ($instagram->hasUser()) {
$model = new static();
$model->id = $instagram->getId();
$model->instagram = $instagram;
$model->username = $instagram->getLogin();
$session = new Session();
$session->set($model->id . '_' . __CLASS__, serialize($model));
return $model;
}
return null;
}
public function actionLogin()
{
$modelLoginFrom = new LoginForm();
if ($modelLoginFrom->load(\Yii::$app->getRequest()->getBodyParams(), '') && $modelLoginFrom->login()) {
$post = \Yii::$app->getRequest()->getBodyParams();
$modelUser = new User();
$modelRole = new Role();
$result = $modelRole->find()->where(['=', 'role_id', \Yii::$app->user->identity->getRole()])->all();
$resultuserdata = $modelUser->find()->where(['=', 'username', $post['username']])->one();
$session = new Session();
$session->open();
$session->set('role', $result[0]->name);
$session->close();
return ['username' => $post['username'], 'role' => $result[0]->name, 'isLogined' => true, 'userDataID' => $resultuserdata->user_data_id];
} else {
return $modelLoginFrom;
}
}
public function actionLogin()
{
// error_reporting(0);
$model = new LoginForm();
$model->scenario = 'login';
if ($model->load(Yii::$app->request->post()) && $model->login()) {
// check change password date
if (Yii::$app->user->ChangePassDate == "") {
$session = new Session();
$session->set('user_id', $model->username);
return $this->redirect(array('site/change-password'));
}
self::updateLastAction();
return $this->goBack();
} else {
return $this->render('login', ['model' => $model]);
}
}
public function actionCheckout()
{
$case = new Apcase();
$request = \Yii::$app->request;
if (empty($request->post()) && empty($request->post('app_date'))) {
return $this->redirect(['index']);
}
if (empty($request->post('menstrual_date'))) {
$ms_period = "n/a";
} else {
$ms_period = $request->post('menstrual_date');
}
//file upload start
$uploaded_files = [];
$case->imageFiles = UploadedFile::getInstances($case, 'imageFiles');
$upload_result = $case->upload();
if (is_array($case->imageFiles) && count($case->imageFiles) > 0) {
foreach ($case->imageFiles as $file) {
array_push($uploaded_files, $file->name);
}
}
//file upload ends
$date = date("Y-m-d H:i:s");
$case->user_id = \Yii::$app->user->id;
$case->what_brought_you = $request->post('in_cause');
$case->location_of_symptom = $request->post('symptoms_location');
$case->quality_of_symptoms = $request->post('symptoms');
$case->severity_of_symptoms_right_now = $request->post('severity');
$case->severity_of_symptoms_during_episode = $request->post('severity_duration');
$case->symptoms_been_going_on_for = $request->post('symptoms_has_been');
$case->symptoms_type = $request->post('consis');
$case->symptoms_last_for = $request->post('eps_symptoms_last_for');
$case->when_symptom_occur = $request->post('when_got_sysmptoms');
$case->factors_that_make_symptoms_better = $request->post('better_symptoms');
$case->factors_that_make_symptoms_worse = $request->post('worse_symptoms');
$case->associated_symptoms = $request->post('associated_symptoms');
$case->other_associated_symptoms = $request->post('other_assoc_symp');
$case->medical_problems_treated_for = serialize($request->post('problem_treated'));
$case->other_medical_problems_treated_for = $request->post('other_prob_treated');
$case->past_surgeries = serialize($request->post('past_surgeries'));
$case->other_past_surgeries = $request->post('other_past_surgeries');
$case->medications_taken = $request->post('medication_taken');
$case->allergies = $request->post('allergies');
$case->ast_menstrual_period = $ms_period;
$case->primary_doctor = $request->post('doctor_first_name') . ' ' . $request->post('doctor_last_name');
$case->where_can_they_be_reached = $request->post('can_reached');
$case->martial_status = $request->post('martial_status');
$case->occupation = $request->post('occupation');
$case->habits = $request->post('habits');
$case->family_history = $request->post('family_history');
$case->other_family_history = $request->post('other_family_history');
$case->firtst_name = $request->post('first_name');
$case->last_name = $request->post('last_name');
$case->files = serialize($uploaded_files);
$case->save();
$appointment_id = $case->id;
$session = \Yii::$app->session;
$session = new Session();
$session->open();
$session->set('apid', $appointment_id);
if (\Yii::$app->user->isGuest) {
return $this->render("index_guest", array());
} else {
return $this->render("checkout", array("showProfilePostForm" => Setting::Get("showProfilePostForm", "appointments")));
}
}
public function actionCheckout()
{
$session = new Session();
$session->open();
$cart = $session->get('cart');
$billOrder = new BillOrder();
if (!empty($_POST)) {
// save bill order
$billOrder->member_id = $session->get('member_id');
$billOrder->ip = $_SERVER['REMOTE_ADDR'];
$billOrder->created_at = new Expression('NOW()');
$billOrder->status = 'wait';
$billOrder->name = $_POST['BillOrder']['name'];
$billOrder->address = $_POST['BillOrder']['address'];
$billOrder->tel = $_POST['BillOrder']['tel'];
if ($billOrder->save()) {
// loop read data from session to database
foreach ($cart as $c) {
$billOrderDetail = new BillOrderDetail();
$billOrderDetail->bill_order_id = $billOrder->id;
$billOrderDetail->product_id = $c['id'];
$billOrderDetail->price = $c['price'];
$billOrderDetail->qty = $c['qty'];
$billOrderDetail->save();
}
// clear session
$session->set('cart', null);
return $this->redirect(['checkoutsuccess']);
}
}
return $this->render('//Frontend/Checkout', ['n' => 1, 'cart' => $cart, 'sumQty' => 0, 'sumPrice' => 0, 'billOrder' => $billOrder]);
}
/**
* @param GameInterface $game
*/
public function save(GameInterface $game)
{
$this->session->set('game', serialize($game));
}
/**
* Saves data into the Session.
* This is normally called automatically after the Event::WIZARD_PROCESS_STEP event,
* but can be called directly for advanced navigation purposes.
*
* @param mixed $data Data to be saved
* @param string $step Step name. If empty the current step is used.
*/
public function save($data, $step = null)
{
$stepsData = $this->_session->get($this->_stepsKey, []);
$stepsData[empty($step) ? $this->_currentStep : $step] = $data;
$this->_session->set($this->_stepsKey, $stepsData);
}
