public function findstatusbyuser($workflow) { $status = Wfgroup::model()->findbysql("select b.*\r\nfrom workflow a\r\ninner join wfgroup b on b.workflowid = a.workflowid\r\ninner join groupaccess c on c.groupaccessid = b.groupaccessid\r\ninner join usergroup d on d.groupaccessid = c.groupaccessid\r\ninner join useraccess e on e.useraccessid = d.useraccessid\r\nwhere upper(a.wfname) = upper('" . $workflow . "') and upper(e.username)=upper('" . Yii::app()->user->name . "')"); if ($status != null) { return $status->wfbefstat; } else { return 0; } }
/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate() { parent::actionCreate(); $this->lookupdata(); $model = new Prheader(); $model->recordstatus = Wfgroup::model()->findstatusbyuser('inspr'); if (Yii::app()->request->isAjaxRequest) { if ($model->save()) { echo CJSON::encode(array('status' => 'success', 'prheaderid' => $model->prheaderid, 'divcreate' => $this->renderPartial('_form', array('model' => $model, 'prmaterial' => $this->prmaterial), true))); Yii::app()->end(); } } }
/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate() { parent::actionCreate(); $this->lookupdata(); $model = new Invoice(); $model->invoicetypeid = 1; $model->recordstatus = Wfgroup::model()->findstatusbyuser('insinvap'); if (Yii::app()->request->isAjaxRequest) { if ($model->save()) { echo CJSON::encode(array('status' => 'success', 'invoiceid' => $model->invoiceid, 'divcreate' => $this->renderPartial('_form', array('model' => $model, 'invoicedet' => $this->invoicedet, 'invoiceacc' => $this->invoiceacc), true))); Yii::app()->end(); } } }
/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate() { parent::actionCreate(); $this->lookupdata(); $model = new Deliveryadvice(); $model->recordstatus = Wfgroup::model()->findstatusbyuser('insda'); $model->useraccessid = Useraccess::model()->findbysql("select * from useraccess \n where upper(username)=upper('" . Yii::app()->user->name . "')")->useraccessid; if (Yii::app()->request->isAjaxRequest) { if ($model->save()) { echo CJSON::encode(array('status' => 'success', 'deliveryadviceid' => $model->deliveryadviceid, 'divcreate' => $this->renderPartial('_form', array('model' => $model, 'deliveryadvicedetail' => $this->deliveryadvicedetail), true))); Yii::app()->end(); } } }
/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate() { parent::actionCreate(); $this->lookupdata(); $model = new Soheader(); $model->recordstatus = Wfgroup::model()->findstatusbyuser('insso'); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (Yii::app()->request->isAjaxRequest) { if ($model->save()) { echo CJSON::encode(array('status' => 'success', 'soheaderid' => $model->soheaderid, 'divcreate' => $this->renderPartial('_form', array('model' => $model, 'sodetail' => $this->sodetail), true))); Yii::app()->end(); } } }
/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate() { parent::actionCreate(); $grdetail = new Grdetail('search'); $grdetail->unsetAttributes(); // clear any default values if (isset($_GET['Grdetail'])) { $grdetail->attributes = $_GET['Grdetail']; } $model = new Grheader(); $model->recordstatus = Wfgroup::model()->findstatusbyuser('insgr'); if (Yii::app()->request->isAjaxRequest) { if ($model->save()) { echo CJSON::encode(array('status' => 'success', 'grheaderid' => $model->grheaderid, 'divcreate' => $this->renderPartial('_form', array('model' => $model, 'grdetail' => $grdetail), true))); Yii::app()->end(); } } }
public function actionUpload() { parent::actionUpload(); $folder = $_SERVER['DOCUMENT_ROOT'] . Yii::app()->request->baseUrl . '/upload/'; // folder for uploaded files $file = $folder . basename($_FILES['uploadfile']['name']); if (move_uploaded_file($_FILES['uploadfile']['tmp_name'], $file)) { $row = 0; if (($handle = fopen($file, "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { if ($row > 0) { $empid = Employee::model()->findbyattributes(array('oldnik' => $data[0])); $model = new Employeeschedule(); if ($empid != null) { $model = Employeeschedule::model()->findByattributes(array('employeeid' => $empid->employeeid, 'month' => $data[2], 'year' => $data[3])); if ($model == null) { $model = new Employeeschedule(); } $model->employeeid = $empid->employeeid; $model->month = $data[2]; $model->year = $data[3]; $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[4])); if ($d != null) { $model->d1 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[5])); if ($d != null) { $model->d2 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[6])); if ($d != null) { $model->d3 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[7])); if ($d != null) { $model->d4 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[8])); if ($d != null) { $model->d5 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[9])); if ($d != null) { $model->d6 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[10])); if ($d != null) { $model->d7 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[11])); if ($d != null) { $model->d8 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[12])); if ($d != null) { $model->d9 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[13])); if ($d != null) { $model->d10 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[14])); if ($d != null) { $model->d11 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[15])); if ($d != null) { $model->d12 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[16])); if ($d != null) { $model->d13 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[17])); if ($d != null) { $model->d14 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[18])); if ($d != null) { $model->d15 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[19])); if ($d != null) { $model->d16 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[20])); if ($d != null) { $model->d17 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[21])); if ($d != null) { $model->d18 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[22])); if ($d != null) { $model->d19 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[23])); if ($d != null) { $model->d20 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[24])); if ($d != null) { $model->d21 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[25])); if ($d != null) { $model->d22 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[26])); if ($d != null) { $model->d23 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[27])); if ($d != null) { $model->d24 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[28])); if ($d != null) { $model->d25 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[29])); if ($d != null) { $model->d26 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[30])); if ($d != null) { $model->d27 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[31])); if ($d != null) { $model->d28 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[32])); if ($d != null) { $model->d29 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[33])); if ($d != null) { $model->d30 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[34])); if ($d != null) { $model->d31 = $d->absscheduleid; } $model->recordstatus = Wfgroup::model()->findstatusbyuser('insempsched'); } try { if (!$model->save()) { $this->messages = $this->messages . Catalogsys::model()->getcatalog(' upload error at ' . $data[0]); } else { $a = Yii::app()->user->name; $connection = Yii::app()->db; $transaction = $connection->beginTransaction(); try { $sql = 'call ApproveEmployeeSchedule(:vid, :vlastupdateby)'; $command = $connection->createCommand($sql); $command->bindvalue(':vid', $model->employeescheduleid, PDO::PARAM_INT); $command->bindvalue(':vlastupdateby', $a, PDO::PARAM_STR); $command->execute(); $transaction->commit(); } catch (Exception $e) { $this->messages = $this->messages . Catalogsys::model()->getcatalog(' upload error at ' . $data[0]); } } } catch (Exception $e) { $this->messages = $this->messages . $e->getMessage(); } } $row++; } } else { $this->messages = $this->messages . ' memory or harddisk full'; } fclose($handle); } else { $this->messages = $this->messages . ' check your directory permission'; } if ($this->messages == '') { $this->messages = 'success'; } echo $this->messages; }
public function actionUpload() { parent::actionUpload(); $folder = $_SERVER['DOCUMENT_ROOT'] . Yii::app()->request->baseUrl . '/upload/'; // folder for uploaded files $file = $folder . basename($_FILES['uploadfile']['name']); if (move_uploaded_file($_FILES['uploadfile']['tmp_name'], $file)) { $row = 0; if (($handle = fopen($file, "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { if ($row > 0) { if ($data[0] != '') { $model = new Genjournal(); $model->journaldate = $data[0]; $model->postdate = $data[0]; $model->referenceno = $data[1]; $model->recordstatus = Wfgroup::model()->findstatusbyuser('insgenjournal'); $model->save(); $oldid = $model->genjournalid; } if ($oldid != 0) { $detail = new Journaldetail(); $detail->genjournalid = $oldid; $account = Account::model()->findbysql("select accountid from account where upper(accountcode) = '" . $data[2] . "'"); if ($account != null) { $detail->accountid = $account->accountid; } if ($data[3] != '') { $detail->debit = $data[3]; $detail->credit = 0; } if ($data[4] != '') { $detail->debit = 0; $detail->credit = $data[4]; } $currency = Currency::model()->findbysql("select currencyid from currency where upper(currencyname) = '" . $data[5] . "'"); if ($currency != null) { $detail->currencyid = $currency->currencyid; } $detail->detailnote = $data[1]; if (!$detail->save()) { $this->messages = $this->messages . Catalogsys::model()->getcatalog(' upload error at ' . $data[0]); } } } } } else { $this->messages = $this->messages . ' memory or harddisk full'; } fclose($handle); } else { $this->messages = $this->messages . ' check your directory permission'; } if ($this->messages == '') { $this->messages = 'success'; } echo $this->messages; }
public function actionUpload() { parent::actionUpload(); $folder = $_SERVER['DOCUMENT_ROOT'] . Yii::app()->request->baseUrl . '/upload/'; // folder for uploaded files $file = $folder . basename($_FILES['uploadfile']['name']); if (move_uploaded_file($_FILES['uploadfile']['tmp_name'], $file)) { $row = 0; if (($handle = fopen($file, "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { if ($row > 0) { $model = Wfgroup::model()->findByPk((int) $data[0]); if ($model === null) { $model = new Wfgroup(); } $model->wfgroupid = (int) $data[0]; $workflow = Workflow::model()->findbyattributes(array('wfname' => $data[1])); if ($workflow !== null) { $model->workflowid = $workflow->workflowid; } $groupaccess = Groupaccess::model()->findbyattributes(array('wfname' => $data[2])); if ($groupaccess !== null) { $model->groupaccessid = $groupaccess->groupaccessid; } $model->wfbefstat = $data[3]; $model->wfrecstat = $data[4]; $model->recordstatus = (int) $data[5]; try { if (!$model->save()) { $this->messages = $this->messages . Catalogsys::model()->getcatalog(' upload error at ' . $data[0]); } } catch (Exception $e) { $this->messages = $this->messages . $e->getMessage(); } } $row++; } } else { $this->messages = $this->messages . ' memory or harddisk full'; } fclose($handle); } else { $this->messages = $this->messages . ' check your directory permission'; } if ($this->messages == '') { $this->messages = 'success'; } echo $this->messages; }