/**
* init
*
* @return void
*/
public function init()
{
$this->params =& Yii::$app->params;
$this->request =& Yii::$app->request;
$this->session =& Yii::$app->session;
$this->cache =& Yii::$app->cache;
if ($this->session->isActive) {
$this->session->open();
}
$this->loadLanguages();
if ($this->loadMember()) {
$this->member->lastSeenTime = time();
$this->member->save();
}
}
public function actionSetwindowguid()
{
$guid = (string) filter_input(INPUT_POST, 'guid');
$pathname = (string) filter_input(INPUT_POST, 'path');
$search = (string) filter_input(INPUT_POST, 'search');
$session = new Session();
$session->open();
$res = isset($session['WindowsGUIDs']) ? $session['WindowsGUIDs'] : [];
$currentguid = $session['WindowsGUIDCurrent'];
$gohome = false;
$homeurls = ["", "?r=site%2Findex", "?r=site%2Flogin", "?r=site%2Flogout", "?r=site%2Ferror"];
$ishome = in_array($search, $homeurls);
if (empty($guid)) {
// Если новая вкладка
for ($i = 0; $i < 6; $i++) {
$guid .= dechex(rand(0, 15));
}
$res[$guid] = 1;
$session['WindowsGUIDs'] = $res;
$session['WindowsGUIDCurrent'] = $guid;
$gohome = !$ishome;
} else {
// Если существующая вкладка
if ($session['WindowsGUIDCurrent'] === $guid) {
// Если текущая вкладка
} else {
// Если другая существующая вкладка
$session['WindowsGUIDCurrent'] = $guid;
$gohome = !$ishome;
}
$session['WindowsGUIDs'] = $res;
}
$session->close();
echo json_encode((object) ['guid' => $guid, 'gohome' => $gohome]);
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Reqdevice::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
// $query->andFilterWhere([
// 'recid' => $this->recid,
// 'jobtype' => $this->jobtype,
// 'jobaction' => $this->jobaction,
// 'jobdate' => $this->jobdate,
// 'aproveddate' => $this->aproveddate,
// 'requestby' => $this->requestby,
// 'approvedby' => $this->approvedby,
// 'jobstatus' => $this->jobstatus,
// 'startdate' => $this->startdate,
// 'enddate' => $this->enddate,
// 'operateby' => $this->operateby,
// ]);
$session = new Session();
$session->open();
if ($session['groupid'] != 1) {
$query->orFilterWhere(['like', 'jobtitle', $this->globalSearch])->orFilterWhere(['like', 'comment', $this->globalSearch])->andFilterWhere(['=', 'jobtype', 4])->andFilterWhere(['=', 'requestby', $session['userid']]);
} else {
$query->orFilterWhere(['like', 'jobtitle', $this->globalSearch])->orFilterWhere(['like', 'comment', $this->globalSearch])->andFilterWhere(['=', 'jobtype', 4]);
}
return $dataProvider;
}
/**
* Updates an existing Books model.
* If update is successful, the browser will be redirected to the 'view' page.
* @param integer $id
* @return mixed
*/
public function actionUpdate($id)
{
$model = $this->findModel($id);
$session = new Session();
$session->open();
$oldFile = $model->preview;
if ($model->load(Yii::$app->request->post()) && $model->validate()) {
$file = UploadedFile::getInstance($model, 'image');
$model->image = $file;
// Если изображение выбрано, загрузить его и удалить старое
if (!empty($model->image)) {
$filename = uniqid();
$model->image = $file;
$model->preview = $filename . "." . $model->image->getExtension();
if ($model->save()) {
$file->saveAs($model->getUplDir() . $filename . "." . $model->image->getExtension());
if (file_exists($model->getUplDir() . $oldFile)) {
@unlink($model->getUplDir() . $oldFile);
}
return $this->redirect("?" . $session['urlParam']);
}
} else {
if ($model->save()) {
return $this->redirect("?" . $session['urlParam']);
}
}
}
return $this->render('update', ['model' => $model]);
}
private function redirect($tud)
{
$session = new Session();
$session->open();
$session['tud'] = $tud;
return \Yii::$app->response->redirect(Url::to(['/authentication/response']));
}
public function actionDelete($id)
{
Category::findOne($id)->delete();
$session = new Session();
$session->open();
$session->setFlash('message', 'Deleted.');
return $this->redirect(['index']);
}
public function init()
{
$session = new Session();
$session->open();
if (empty($_SESSION['userid'])) {
return $this->redirect('index.php?r=login/login');
}
}
public function actionLogout()
{
$session = new \yii\web\Session();
$session->open();
unset($session['account_id']);
unset($session['account_name']);
return $this->redirect('index.php?r=backend/index');
}
public function actionRegis()
{
if (\yii::$app->request->isAjax) {
$module = \yii::$app->request->post('module');
$session = new Session();
$session->open();
$session['module'] = $module;
}
}
public function init()
{
$session = new Session();
$session->open();
if (empty($session['account_id'])) {
return $this->redirect('index.php?r=backend/index');
}
parent::init();
}
/**
* Creates a new Saleorderinvoice model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate()
{
$searchModel = \backend\models\Saleorderinvoiceline::find()->where(['invid' => 0]);
$model = new Saleorderinvoice();
if ($model->load(Yii::$app->request->post())) {
$chkcount = Saleorderinvoice::find()->where(['invoiceno' => $_POST['Saleorderinvoice']['invoiceno']])->count();
if ($chkcount > 0) {
// print_r($model->errors);
// echo 'Not save';
$session = new Session();
$session->open();
$session->setFlash('modelerror', 'เลขที่ Invoice ซ้ำ');
return $this->render('create', ['model' => $model, 'saleline' => $searchModel, 'rowcount' => 0, 'saleincluded' => null, 'saleincludedcount' => 0]);
}
$saledate = $_POST['Saleorderinvoice']['invoicedate'];
$model->invoicedate = date('d/M/Y H:i:s', strtotime($saledate));
// $model->createby =$session['username'];
if ($model->save()) {
$uploaded = UploadedFile::getInstance($model, 'upfile');
$result = 0;
if (!empty($uploaded)) {
$upfiles = time() . "." . $uploaded->getExtension();
$uploaded->saveAs('../../uploads/' . $upfiles);
$handle = fopen('../../uploads/' . $upfiles, 'r');
$n = 0;
while (($fileop = fgetcsv($handle, 1000, ",")) !== false) {
if ($n < 1) {
$n++;
continue;
}
$model2 = new \backend\models\Saleorderinvoiceline();
$model2->invid = $model->recid;
$model2->invline = $fileop[0];
$model2->partno = $fileop[1];
$model2->description = iconv("TIS-620", "UTF-8", $fileop[2]);
$model2->quantity = $fileop[3];
$model2->unitprice = $fileop[4];
$model2->totalamount = $fileop[5];
$model2->unit = 1;
if ($model2->save()) {
$result++;
}
}
fclose($handle);
if ($result > 0) {
$session = new \yii\web\Session();
$session->open();
$session->setFlash('msgsuccess', 'บันทึกรายการเรียบร้อย');
return $this->redirect(['update', 'id' => $model->recid]);
}
}
} else {
}
}
return $this->render('create', ['model' => $model, 'saleline' => $searchModel, 'rowcount' => 0, 'saleincluded' => null, 'saleincludedcount' => 0]);
}
/**
* Главный экшн для клиента это отчеты которые пришли от менеджера
* Проверен (21.12.15)
*/
public function actionReports()
{
//Сессия необходима для создания временного файла для хранения картинок до создания товара
$session = new Session();
$session->open();
//cs - CREATE SESSION ID
$session['cs_' . Yii::$app->user->identity->id] = md5(time() . rand(0, 10000));
$projects = Project::find()->where(['for_user_id' => Yii::$app->user->identity->id])->all();
return $this->render('reports', compact('projects'));
}
public function bootstrap($app)
{
$session = new Session();
$session->open();
if (isset($session['lang'])) {
$app->language = $session['lang'];
return;
}
$app->language = Yii::$app->params['defaultLang'];
}
public function actionCreateid()
{
if (\Yii::$app->request->isAjax) {
$pk = \Yii::$app->request->post("pk");
$pk2 = \Yii::$app->request->post("rid");
$session = new Session();
$session->open();
$session['recid'] = $pk;
$session['roleid'] = $pk;
}
}
/**
* Список поручений отправленные менеджером
*/
public function actionAssignments()
{
//Сессия необходима для создания временного файла для хранения картинок до создания товара
$session = new Session();
$session->open();
//cs - CREATE SESSION ID
$session['cs_' . Yii::$app->user->identity->id] = md5(time() . rand(0, 10000));
$searchModel = new AssignmentSearch();
$dataProvider = $searchModel->searchForTeam(Yii::$app->request->queryParams);
return $this->render('assignments', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]);
}
public function Add($id)
{
$session = new Session();
$session->open();
$cart = $session->get('cart', []);
if (empty($cart[$id])) {
$cart[$id] = 1;
} else {
$cart[$id]++;
}
}
public function actionShowjob()
{
$session = new Session();
$session->open();
$model = Alljobs::find()->where(['recid' => $session['recid']])->all();
if ($model) {
$session->remove('recid');
$this->layout = 'mylayout';
return $this->render('index', ['model' => $model]);
}
}
public function actionIndex()
{
$session = new Session();
$session->open();
$countApprove = Homeuser::find()->where(['requestby' => $session['userid'], 'jobstatus' => 1])->count();
$countProblem = Homeuser::find()->where(['requestby' => $session['userid'], 'jobstatus' => 200])->count();
$countFinished = Homeuser::find()->where(['requestby' => $session['userid'], 'jobstatus' => 300])->count();
$totalCount = Homeuser::find()->where(['requestby' => $session['userid']])->count();
$pages = new Pagination(['totalCount' => $totalCount, 'pageSize' => 5]);
$model = Homeuser::find()->where(['requestby' => $session['userid']])->offset($pages->offset)->limit($pages->limit)->all();
return $this->render('index', ['model' => $model, 'approve' => $countApprove, 'problem' => $countProblem, 'finished' => $countFinished, 'pages' => $pages]);
}
public function open()
{
if ($this->getIsActive()) {
$cookies = Yii::$app->request->cookies;
if (isset($cookies['OLDSESSID'])) {
$this->oldSessId = $cookies->getValue('OLDSESSID');
} else {
Yii::$app->response->cookies->add(new \yii\web\Cookie(['name' => 'OLDSESSID', 'value' => $this->id]));
}
}
parent::open();
}
public function actionDelete($id)
{
$productImage = BookImage::findOne($id);
$product = $productImage->book;
$image_url = $productImage->url;
if ($productImage->delete()) {
$session = new Session();
$session->open();
$session->setFlash('message', 'Data Deleted.');
unlink('../uploads/' . $image_url);
return $this->redirect(['index', 'book_id' => $product->id]);
}
}
/**
* PagesController implements the CRUD actions for Pages model.
*/
function actionIndex()
{
$session = new Session();
$session->open();
if (!empty($_POST['text'])) {
$session['text'] = $a = trim($_POST['text']);
} else {
$a = $session['text'];
}
$query = Pages::find()->where(['status' => '1'])->andWhere(['like', 'text', $a]);
$pagination = new Pagination(['defaultPageSize' => 1, 'totalCount' => $query->count(), 'pageParam' => 'i']);
$pages = $query->orderBy('id')->offset($pagination->offset)->limit($pagination->limit)->all();
return $this->render('index', ['pages' => $pages, 'pagination' => $pagination, 'a' => $a]);
}
/**
* Creates a new Reqstore model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate()
{
$model = new Reqstore();
if ($model->load(Yii::$app->request->post())) {
$session = new Session();
$session->open();
$model->requestby = $session['userid'];
if ($model->save()) {
return $this->redirect(['view', 'id' => $model->recid]);
}
} else {
return $this->render('create', ['model' => $model]);
}
}
public function actionAddsale()
{
$session = new Session();
$session->open();
if (!empty($_POST['sales'])) {
Invoicerefsale::deleteAll('invid = :invid', [':invid' => $session['invid']]);
foreach ($_POST['sales'] as $data) {
$model2 = new \backend\models\Invoicerefsale();
$model2->invid = $session['invid'];
$model2->saleid = $data;
$model2->save();
}
return $this->redirect(['saleorderinvoice/update', 'id' => $session['invid']]);
}
}
public function insertCustomerOnLogin()
{
$session = new Session();
$session->open();
$this->customer_user_name = $session['email'];
$this->customer_first_name = $session['fname'];
$this->customer_last_name = $session['lname'];
$this->customer_email = $session['email'];
if ($session['gender'] == 'male') {
$this->customer_gender = 'M';
$this->insert();
} else {
$this->customer_gender = 'F';
$this->insert();
}
return true;
}
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;
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Dasboarddetail::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
//$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where(['jobstatus'=>1]);
return $dataProvider;
}
// $query->andFilterWhere([
// 'recid' => $this->recid,
// 'jobtype' => $this->jobtype,
// 'jobaction' => $this->jobaction,
// 'jobdate' => $this->jobdate,
// 'aproveddate' => $this->aproveddate,
// 'requestby' => $this->requestby,
// 'approvedby' => $this->approvedby,
// 'jobstatus' => $this->jobstatus,
// 'startdate' => $this->startdate,
// 'enddate' => $this->enddate,
// 'operateby' => $this->operateby,
// ]);
// $query->andFilterWhere(['like', 'jobtitle', $this->jobtitle])
// ->andFilterWhere(['like', 'comment', $this->comment])
// ->andFilterWhere(['like', 'jobformat', $this->jobformat])
// ->andFilterWhere(['like', 'jobcondition', $this->jobcondition])
// ->andFilterWhere(['like', 'attachfile', $this->attachfile])
// ->andFilterWhere(['like', 'filetype', $this->filetype])
// ->andFilterWhere(['like', 'usdef1', $this->usdef1])
// ->andFilterWhere(['like', 'usdef2', $this->usdef2])
// ->andFilterWhere(['like', 'usdef3', $this->usdef3])
// ->andFilterWhere(['like', 'usdef4', $this->usdef4])
// ->andFilterWhere(['like', 'usdef5', $this->usdef5])
// ->andFilterWhere(['like', 'usdef6', $this->usdef6])
// ->andFilterWhere(['like', 'usdef7', $this->usdef7])
// ->andFilterWhere(['like', 'usdef8', $this->usdef8])
// ->andFilterWhere(['like', 'usdef9', $this->usdef9]);
$session = new Session();
$session->open();
$query->andFilterWhere(['=', 'jobstatus', $params])->andFilterWhere(['=', 'requestby', $session['userid']]);
return $dataProvider;
}
public function LoginUser()
{
$connection = Yii::$app->getDb();
$command = $connection->createCommand('
SELECT * FROM t_user WHERE username="******" AND password="******"');
$result = $command->queryOne();
if ($result != null) {
$session = new Session();
$session->open();
$session['username'] = $this->username;
$session['id'] = $result['id'];
$session['nik'] = $result['nik'];
$session['nama'] = $result['nama'];
$session['user_level'] = $result['user_level'];
$session['category'] = $result['category'];
$session['kecamatan'] = $result['kecamatan'];
}
return $result;
}
/**
* Lists all Udashboard models.
* @return mixed
*/
public function actionIndex()
{
// $searchModel = new UdashboardSearch();
// $dataProvider = $searchModel->search(Yii::$app->request->queryParams);
//
// return $this->render('index', [
// 'searchModel' => $searchModel,
// 'dataProvider' => $dataProvider,
// ]);
$session = new Session();
$session->open();
$countApprove = Homeuser::find()->where(['requestby' => $session['userid'], 'jobstatus' => 1])->count();
$countProblem = Homeuser::find()->where(['requestby' => $session['userid'], 'jobstatus' => 200])->count();
$countFinished = Homeuser::find()->where(['requestby' => $session['userid'], 'jobstatus' => 300])->count();
$totalCount = Homeuser::find()->where(['requestby' => $session['userid']])->count();
$pages = new Pagination(['totalCount' => $totalCount, 'pageSize' => 5]);
$model = Homeuser::find()->where(['requestby' => $session['userid']])->orderBy(['recid' => SORT_DESC])->offset($pages->offset)->limit($pages->limit)->all();
return $this->render('index', ['model' => $model, 'approve' => $countApprove, 'problem' => $countProblem, 'finished' => $countFinished, 'pages' => $pages]);
}
public function actionResponse()
{
$session = new Session();
$session->open();
$tud = $session['tud'];
// First try to find id
$person = Person::findOne(['tud_id' => $tud['uid']]);
if ($person) {
$person->updatePerson($tud);
return $this->login($person);
}
// Then try to find emailaddress (Which is also a valid identifier)
$person = Person::findOne(['emailaddress' => $tud['email']]);
if ($person) {
$person->updatePerson($tud);
return $this->login($person);
}
return $this->create($tud);
}
public function actionIndex()
{
$company = Company::find()->orderBy('id')->one();
if (!empty($_POST)) {
if (!empty($_FILES['Company'])) {
// remove old logo
if (!empty($company->logo)) {
$old_img = $company->logo;
unlink('../uploads/' . $old_img);
}
// upload new logo
$img = $_FILES['Company']['name']['logo'];
$ext = end(explode(".", $img));
$name = microtime();
$name = str_replace(' ', '', $name);
$name = str_replace('.', '', $name);
$name = $name . '.' . $ext;
$tmp = $_FILES['Company']['tmp_name']['logo'];
$company->logo = $name;
move_uploaded_file($tmp, '../uploads/' . $name);
}
$company->name = $_POST['Company']['name'];
$company->web_title = $_POST['Company']['web_title'];
$company->tel = $_POST['Company']['tel'];
$company->email = $_POST['Company']['email'];
$company->fax = $_POST['Company']['fax'];
$company->website = $_POST['Company']['website'];
$company->facebook = $_POST['Company']['facebook'];
$company->line_id = $_POST['Company']['line_id'];
$company->address = $_POST['Company']['address'];
$company->tax_code = $_POST['Company']['tax_code'];
$company->payment = $_POST['Company']['payment'];
$company->about = $_POST['Company']['about'];
if ($company->save()) {
$session = new Session();
$session->open();
$session->setFlash('message', 'Data Saved.');
return $this->redirect(['index']);
}
}
return $this->render('//Company/Index', ['company' => $company]);
}
