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;
}
