public function actionOpenbalance() { $model = new Transactions(); if (isset($_POST['account'])) { $year = $_POST['year']; $date = "{$year}-01-01 00:00:01"; $accountArr = $_POST['account']; $balanceArr = $_POST['bal']; foreach ($accountArr as $index => $account) { $sum = $balanceArr[$index]; if ($account) { $submodel = new Transactions(); $submodel->refnum1 = ''; $submodel->valuedate = $date; $submodel->details = Yii::t('app', "Opening Balance"); $submodel->type = \app\helpers\Linet3Helper::getSetting('transactionType.openBalance'); $submodel->currency_id = \app\helpers\Linet3Helper::getSetting('company.cur'); $submodel->owner_id = Yii::$app->user->id; $submodel->linenum = 0; $submodel->addDoubleLine($account, \app\helpers\Linet3Helper::getSetting('company.acc.openbalance'), $sum); //$submodel->num; } } \Yii::$app->getSession()->setFlash('success', Yii::t('app', 'Open Balance saved')); //$this->redirect(array('OpenBalance')); } return $this->render('opbalance', array('model' => $model)); }
public function actionCreate($type = 0) { $model = new FormOutcome(); if ($type == 1) { $model->account_id = \app\helpers\Linet3Helper::getSetting("company.acc.payvat"); $model->sum = Accounts::findOne($model->account_id)->getBalance(); } if ($type == 2) { $model->account_id = \app\helpers\Linet3Helper::getSetting("company.acc.natinspay"); $model->sum = Accounts::findOne($model->account_id)->getBalance(); } if ($type == 3) { $model->account_id = \app\helpers\Linet3Helper::getSetting("company.acc.pretax"); $model->sum = Accounts::findOne($model->account_id)->getBalance(); } // Uncomment the following line if AJAX validation is needed if (Yii::$app->request->isAjax && $model->load(Yii::$app->request->post())) { Yii::$app->response->format = \yii\web\Response::FORMAT_JSON; return \yii\widgets\ActiveForm::validate($model); } if ($model->load(Yii::$app->request->post())) { if ($model->transaction()) { \Yii::$app->getSession()->setFlash('success', Yii::t('app', 'transaction Success')); } } return $this->render('create', array('model' => $model)); }
public function save() { if (!$this->validate()) { return false; } $transAction = new Transactions(); $transAction->type = \app\helpers\Linet3Helper::getSetting('transactionType.manual'); if (isset($this->sourcepos) && (double) $this->sourcepos != 0) { $sum = $this->sourcepos; } else { $sum = $this->sourceneg * -1; } $transAction->owner_id = Yii::$app->user->id; $transAction->linenum = 1; $transAction->currency_id = $this->currency_id; $transAction->refnum1 = $this->refnum1_ids; $transAction->refnum2 = $this->refnum2; $transAction->details = $this->details; $transAction->valuedate = $this->valuedate; $trans = Yii::$app->db->beginTransaction(\yii\db\Transaction::READ_UNCOMMITTED); //-shuld start transaction here so lets lock down try { $transAction = $transAction->addSingleLine($this->account_id, $sum); if ($transAction) { foreach ($this->ops as $i => $acc) { if (isset($this->sumpos[$i]) && (double) $this->sumpos[$i] != 0) { $smallsum = $this->sumpos[$i]; } else { $smallsum = $this->sumneg[$i] * -1; } if (abs($smallsum) > 0.0001) { $transAction = $transAction->addSingleLine($acc, $smallsum, $this->valuedates[$i]); } } } //commit it here $trans->commit(); } catch (\Exception $e) { $trans->rollBack(); $message = $e->getMessage(); $this->addError('details', $message); return false; } //put your code here return true; }
public function save($runValidation = true, $attributes = NULL) { $class = get_class($this); if ($class == 'Accounts') { if (Accounts::findOne($this->id)) { $this->isNewRecord = false; } } $a = parent::save($runValidation, $attributes); if ($a) { //if (isset($_POST['Files'])) { //$this->attributes = $_POST['Files']; $tmps = \yii\web\UploadedFile::getInstancesByName('Files'); // proceed if the images have been set if (isset($tmps) && count($tmps) > 0) { \Yii::info('saved'); // go through each uploaded image $configPath = \app\helpers\Linet3Helper::getSetting("company.path"); foreach ($tmps as $image => $pic) { $img_add = new Files(); $img_add->name = $pic->name; //it might be $img_add->name for you, filename is just what I chose to call it in my model $img_add->path = "files/"; $img_add->parent_type = get_class($this); $img_add->parent_id = $this->id; // this links your picture model to the main model (like your user, or profile model) $img_add->save(); // DONE if ($pic->saveAs($img_add->getFullFilePath())) { // add it to the main model now } else { echo 'Cannot upload!'; } } if (isset($_FILES)) { Yii::info(print_r($_FILES, true)); unset($_FILES); $tmps = \yii\web\UploadedFile::reset(); } //} } } //endFile return $a; }
public function save($runValidation = true, $attributes = NULL) { //adam: if ($this->eavType == 'boolean') { if ($this->value == '1') { $this->value = 'true'; } else { $this->value = 'false'; } } else { if ($this->eavType == 'file') { $configPath = Linet3Helper::getSetting("company.path"); $a = \yii\web\UploadedFile::getInstanceByName('Settings[' . $this->id . '][value]'); //var_dump($a); //exit; if ($a) { $this->value = $a; $ext = $this->value->extension; //$fileName = $yiiBasepath."/files/".$configPath."/settings/".$this->id.".".$ext; //echo $this->id.get_class($this); $logo = new \app\models\Files(); $logo->name = $this->id . "." . $ext; //it might be $img_add->name for you, filename is just what I chose to call it in my model $logo->path = "settings/"; $logo->parent_type = get_class($this); $logo->parent_id = $this->id; // this links your picture model to the main model (like your user, or profile model) $logo->public = true; $id = $logo->save(); // DONE //echo $logo->id; //Yii::$app->end(); if ($this->value->saveAs($logo->getFullFilePath())) { $this->value = $logo->hash; //"/files/".$configPath."/settings/".$this->id.".".$ext; } //Yii::$app->end(); } } } return parent::save($runValidation, $attributes); }
public function send() { //Yii::import('application.extensions.smtpmail.PHPMailer'); $mailer = new \yii\swiftmailer\Mailer(["transport" => ['class' => 'Swift_SmtpTransport', 'host' => \app\helpers\Linet3Helper::getSetting('company.mail.server'), 'username' => \app\helpers\Linet3Helper::getSetting('company.mail.user'), 'password' => \app\helpers\Linet3Helper::getSetting('company.mail.password'), 'port' => \app\helpers\Linet3Helper::getSetting('company.mail.port'), 'encryption' => \app\helpers\Linet3Helper::getSetting('company.mail.ssl') ? 'tls' : '']]); $mail = $mailer->compose('layouts/html', ['content' => $this->body]); //$mail->SetFrom($this->from); //echo $this->files; if ($this->files != '') { $file = Files::findOne($this->files); if ($file != null) { //echo $file->getFullPath().";;".$file->name; $mail->attach($file->getFullFilePath(), ["fileName" => $file->name]); } } $mail->setFrom(\app\helpers\Linet3Helper::getSetting('company.mail.address'))->setTo($this->to)->setSubject($this->subject); if ($this->cc != '') { $mail->setCc($this->cc); } if ($this->bcc != '') { $mail->setBcc($this->bcc); } //$mail->AddCC($this->cc); //.$this->cc //$mail->AddBcc($this->bcc); //$mail-> //$mail->setHtmlBody($this->body); //$mail; if (!$mail->send()) { //echo "Mailer Error: " . $mail->ErrorInfo; throw new Exception(Yii::t('app', "Mailer Error: ") . $mail->ErrorInfo . $mail->Username); } else { $this->sent++; $this->save(); if (!\app\helpers\Linet3Helper::isConsole()) { \Yii::$app->getSession()->setFlash('success', Yii::t('app', 'Message sent!')); } //echo "Message sent!"; } //*/ //Yii::$app->end(); }
public function save() { //print_r($this->Deposit); $num = 0; //$linenum=1; $tranType = \app\helpers\Linet3Helper::getSetting('transactionType.chequedeposit'); if ($this->refnum == '' || $this->date == '' || !is_array($this->Deposit)) { return false; } $accout = new Transactions(); $accout->type = $tranType; $accout->refnum1 = ''; //$this->refnum; $accout->refnum2 = $this->refnum; $accout->details = Yii::t('app', 'Deposit') . " #" . $this->refnum; $accout->valuedate = $this->date . $this->refnum; $accout->owner_id = Yii::$app->user->id; $accout->linenum = 1; $transaction = Yii::$app->db->beginTransaction(\yii\db\Transaction::READ_UNCOMMITTED); //-shuld start transaction here try { foreach ($this->Deposit as $line => $val) { list($a, $b) = explode(',', $line); $cheq = Doccheques::findOne(array("doc_id" => $a, "line" => $b)); $oppt_acc = PaymentType::findOne($cheq->type)->oppt_account_id; $accout->currency_id = $cheq->currency_id; $accout->addDoubleLine($oppt_acc, $this->account_id, $cheq->sum); $cheq->bank_refnum = $num; $cheq->save(); } $transaction->commit(); } catch (\Exception $e) { $transaction->rollBack(); $message = $e->getMessage(); $this->addError('refnum', $message); } return true; //num }
public function transaction() { if ($this->validate()) { $num = 0; $line = 1; $tranType = \app\helpers\Linet3Helper::getSetting("transactionType.supplierPayment"); $tran = new Transactions(); $tran->num = $num; $tran->type = $tranType; $tran->refnum1 = $this->refnum_ids; $tran->refnum2 = ''; $tran->valuedate = $this->date; $tran->details = $this->details; $tran->currency_id = $this->currency_id; $tran->owner_id = Yii::$app->user->id; $tran->linenum = $line; $trans = Yii::$app->db->beginTransaction(\yii\db\Transaction::READ_UNCOMMITTED); //-shuld start transaction here so lets lock down try { $tran->addSingleLine($this->account_id, $this->sum * -1); $tran->addSingleLine($this->opp_account_id, $this->sum * 1); if ((int) $this->src_tax != 0) { $tran->addDoubleLine(5, $this->account_id, $this->src_tax); } //commit it here $trans->commit(); } catch (\Exception $e) { $trans->rollBack(); $message = $e->getMessage(); $this->addError('details', $message); return false; } $this->saveRef($num, $this->sum); return true; } return false; }
public function actionLinet2import() { $model = new FormLinet2Import(); if (isset($_POST['FormLinet2Import'])) { $configPath = \app\helpers\Linet3Helper::getSetting("company.path"); $file = Company::getFilePath() . "linet2.bak"; $model->file = $_POST['FormLinet2Import']['file']; $model->file = \yii\web\UploadedFile::getInstance($model, 'file'); if ($model->file === null) { throw new \yii\web\HttpException(501, Yii::t('app', 'Error in request.')); } //no file if ($model->file->saveAs($file)) { $model->file = $file; $model->import(); //$model->read(); } } return $this->render('linet2Import', array('model' => $model)); Yii::$app->end(); }
public function pay() { $this->dates(); $date = $this->to_date; /* $tnum = Transaction(0, TRAN_PRETAX, IRS, $ref1, $ref2, $date, $details, $this->tax_sum); $tnum = Transaction($tnum, TRAN_PRETAX, PRETAX, $ref1, $ref2, $date, $details, $this->tax_sum * -1.0); $tnum = Transaction($tnum, TRAN_PRETAX, IRS, $ref1, $ref2, $date, $details, $this->custtax_total); $tnum = Transaction($tnum, TRAN_PRETAX, CUSTTAX, $ref1, $ref2, $date, $details, $this->custtax_total * -1.0); */ $irs = \app\helpers\Linet3Helper::getSetting('company.acc.irs'); $pretax = \app\helpers\Linet3Helper::getSetting('company.acc.pretax'); $custtax = \app\helpers\Linet3Helper::getSetting('company.acc.custtax'); $cur = \app\helpers\Linet3Helper::getSetting('company.cur'); $owner = Yii::$app->user->id; $line = 1; $accout = new Transactions(); $accout->account_id = $irs; //IRS $accout->type = 14; //$accout->refnum1 = $this->from_date; //$accout->refnum2 = $this->to_date; $accout->valuedate = $date; $accout->details = Yii::t('app', 'tax') . " " . $this->from_month . "-" . $this->to_month . "/" . $this->year; $accout->currency_id = $cur; $accout->owner_id = $owner; $accout->linenum = $line; $accout->sum = $this->tax_sum; $line++; $num = $accout->save(); $accout = new Transactions(); $accout->account_id = $pretax; //PRETAX $accout->type = 14; $accout->num = $num; //$accout->refnum1 = $this->from_date; //$accout->refnum2 = $this->to_date; $accout->valuedate = $date; $accout->details = Yii::t('app', 'tax') . " " . $this->from_month . "-" . $this->to_month . "/" . $this->year; $accout->currency_id = $cur; $accout->owner_id = $owner; $accout->linenum = $line; $accout->sum = $this->tax_sum * -1; $line++; $accout->save(); $accout = new Transactions(); $accout->account_id = $irs; //IRS $accout->type = 14; $accout->num = $num; //$accout->refnum1 = $this->from_date; //$accout->refnum2 = $this->to_date; $accout->valuedate = $date; $accout->details = Yii::t('app', 'tax') . " " . $this->from_month . "-" . $this->to_month . "/" . $this->year; $accout->currency_id = $cur; $accout->owner_id = $owner; $accout->linenum = $line; $accout->sum = $this->custtax_total; $line++; $accout->save(); $accout = new Transactions(); $accout->account_id = $custtax; //CUSTTAX $accout->type = 14; $accout->num = $num; //$accout->refnum1 = $this->from_date; //$accout->refnum2 = $this->to_date; $accout->valuedate = $date; $accout->details = Yii::t('app', 'tax') . " " . $this->from_month . "-" . $this->to_month . "/" . $this->year; $accout->currency_id = $cur; $accout->owner_id = $owner; $accout->linenum = $line; $accout->sum = $this->custtax_total * -1.0; $line++; $accout->save(); }
protected function end() { //A1 type //N9 vatid $companyid = \app\helpers\Linet3Helper::getSetting('company.vat.id'); return sprintf("Z%09d", $companyid); }
public static function pdfDoc($model) { $yiiBasepath = Yii::$app->basePath; $yiiUser = \app\helpers\Linet3Helper::getUserId(); //$configPath = app\helpers\Linet3Helper::getSetting("company.path"); $user = User::findOne($yiiUser); if (!$user->hasCert()) { //create new $settings = array('commonName' => $user->username, 'emailAddress' => $user->email); if (\app\helpers\Linet3Helper::getSetting('company.en.city') != '') { $settings['localityName'] = \app\helpers\Linet3Helper::getSetting('company.en.city'); } if (\app\helpers\Linet3Helper::getSetting('company.en.name') != '') { $settings['organizationName'] = \app\helpers\Linet3Helper::getSetting('company.en.name'); } $ssl = new \app\helpers\SSLHelper($settings); $filename = $user->getCertFilePath(); \app\helpers\Linet3Helper::setSetting('company.' . $yiiUser . '.certpasswd', $ssl->createUserCert($filename)); //$user->save(); } $configCertpasswd = \app\helpers\Linet3Helper::getSetting('company.' . $yiiUser . '.certpasswd'); $name = $model->docType->name . "-" . "{$model->docnum}.pdf"; $file = PrintDoc::findFile($model, $name); if (!$file) { $model->preview = 2; $docfile = PrintDoc::printMe($model); /*//adam $file = new Files(); $file->name = $name; $file->path = "docs/"; $file->parent_type = get_class($model); $file->parent_id = $model->id; $file->hidden = 1; $file->public = 0; $file->save(); $file->writeFile($docfile); exit; //adam*/ //$mPDF1 = new Pdf; //$mPDF1->execute(['WriteHTML' => $docfile]); $pdf = new Pdf(['mode' => Pdf::MODE_UTF8, 'format' => Pdf::FORMAT_A4, 'orientation' => Pdf::ORIENT_PORTRAIT, 'methods' => ['SetFooter' => ['Linet 3.1 Accounting Software']]]); $mpdf = $pdf->api; //$mpdf->fonttrans['freeserif'] = 'freeserif2'; //$mpdf->PDFAauto = true; $mpdf->WriteHtml($docfile); $file = new Files(); $file->name = $name; $file->path = "docs/"; $file->parent_type = get_class($model); $file->parent_id = $model->id; $file->hidden = 1; $file->public = 0; $file->save(); //var_dump($file->getErrors()); //exit; $file->writeFile($mpdf->output("bla", "S")); } $name = $model->docType->name . "-" . "{$model->docnum}-signed.pdf"; $doc_file = PrintDoc::findFile($model, $name); if (!$doc_file) { //'digi';// $cerfile = User::getCertFilePath($yiiUser); //loads a sample PDF file Yii::$classMap['Farit_Pdf'] = $yiiBasepath . '/vendor/Farit/Pdf.php'; Yii::$classMap['Farit_Pdf_ElementRaw'] = $yiiBasepath . '/vendor/Farit/ElementRaw.php'; Yii::$classMap['Zend_Memory'] = $yiiBasepath . '/vendor/Zend/Memory.php'; Yii::$classMap['Zend_Memory_Manager'] = $yiiBasepath . '/vendor/Zend/Memory/Manager.php'; Yii::$classMap['Zend_Memory_Container'] = $yiiBasepath . '/vendor/Zend/Memory/Container.php'; Yii::$classMap['Zend_Memory_Container_Interface'] = $yiiBasepath . '/vendor/Zend/Memory/Container/Interface.php'; Yii::$classMap['Zend_Memory_Container_Locked'] = $yiiBasepath . '/vendor/Zend/Memory/Container/Locked.php'; Yii::$classMap['Zend_Pdf'] = $yiiBasepath . '/vendor/Zend/Pdf.php'; Yii::$classMap['Zend_Pdf_Parser'] = $yiiBasepath . '/vendor/Zend/Pdf/Parser.php'; Yii::$classMap['Zend_Pdf_Page'] = $yiiBasepath . '/vendor/Zend/Pdf/Page.php'; Yii::$classMap['Zend_Pdf_UpdateInfoContainer'] = $yiiBasepath . '/vendor/Zend/Pdf/UpdateInfoContainer.php'; Yii::$classMap['Zend_Pdf_Target'] = $yiiBasepath . '/vendor/Zend/Pdf/Target.php'; Yii::$classMap['Zend_Pdf_Destination'] = $yiiBasepath . '/vendor/Zend/Pdf/Destination.php'; Yii::$classMap['Zend_Pdf_Destination_Zoom'] = $yiiBasepath . '/vendor/Zend/Pdf/Destination/Zoom.php'; Yii::$classMap['Zend_Pdf_Destination_Explicit'] = $yiiBasepath . '/vendor/Zend/Pdf/Destination/Explicit.php'; Yii::$classMap['Zend_Pdf_RecursivelyIteratableObjectsContainer'] = $yiiBasepath . '/vendor/Zend/Pdf/RecursivelyIteratableObjectsContainer.php'; Yii::$classMap['Zend_Pdf_StringParser'] = $yiiBasepath . '/vendor/Zend/Pdf/StringParser.php'; Yii::$classMap['Zend_Pdf_ElementFactory'] = $yiiBasepath . '/vendor/Zend/Pdf/' . 'ElementFactory' . '.php'; Yii::$classMap['Zend_Pdf_ElementFactory_Interface'] = $yiiBasepath . '/vendor/Zend/Pdf/ElementFactory/' . 'Interface' . '.php'; Yii::$classMap['Zend_Pdf_ElementFactory_Proxy'] = $yiiBasepath . '/vendor/Zend/Pdf/ElementFactory/Proxy.php'; Yii::$classMap['Zend_Pdf_Element_Reference_Table'] = $yiiBasepath . '/vendor/Zend/Pdf/Element/Reference/Table.php'; Yii::$classMap['Zend_Pdf_Element_Reference_Context'] = $yiiBasepath . '/vendor/Zend/Pdf/Element/Reference/Context.php'; Yii::$classMap['Zend_Pdf_Element_Dictionary'] = $yiiBasepath . '/vendor/Zend/Pdf/Element/Dictionary.php'; Yii::$classMap['Zend_Pdf_Element'] = $yiiBasepath . '/vendor/Zend/Pdf/Element.php'; Yii::$classMap['Zend_Pdf_Element_Object'] = $yiiBasepath . '/vendor/Zend/Pdf/Element/Object.php'; Yii::$classMap['Zend_Pdf_Element_Null'] = $yiiBasepath . '/vendor/Zend/Pdf/Element/Null.php'; Yii::$classMap['Zend_Pdf_Element_Name'] = $yiiBasepath . '/vendor/Zend/Pdf/Element/Name.php'; Yii::$classMap['Zend_Pdf_Element_Numeric'] = $yiiBasepath . '/vendor/Zend/Pdf/Element/Numeric.php'; Yii::$classMap['Zend_Pdf_Element_Reference'] = $yiiBasepath . '/vendor/Zend/Pdf/Element/Reference.php'; Yii::$classMap['Zend_Pdf_Element_Array'] = $yiiBasepath . '/vendor/Zend/Pdf/Element/Array.php'; Yii::$classMap['Zend_Pdf_Element_String'] = $yiiBasepath . '/vendor/Zend/Pdf/Element/String.php'; Yii::$classMap['Zend_Pdf_Element_String_Binary'] = $yiiBasepath . '/vendor/Zend/Pdf/Element/String/Binary.php'; Yii::$classMap['Zend_Pdf_Trailer'] = $yiiBasepath . '/vendor/Zend/Pdf/Trailer.php'; Yii::$classMap['Zend_Pdf_Trailer_Keeper'] = $yiiBasepath . '/vendor/Zend/Pdf/Trailer/Keeper.php'; $pdf = \Farit_Pdf::load($file->getFullFilePath()); if (file_exists($cerfile)) { $certificate = file_get_contents($cerfile); if (empty($certificate)) { throw new \Exception('Cannot open the certificate file'); } $pdf->attachDigitalCertificate($certificate, $configCertpasswd); $docfile = $pdf->render(); $doc_file = new Files(); $doc_file->name = $name; $doc_file->path = "docs/"; $doc_file->parent_type = get_class($model); $doc_file->parent_id = $model->id; $doc_file->public = 1; $doc_file->hidden = 0; $doc_file->save(); $doc_file->writeFile($docfile); } else { $link = ""; $text = Yii::t('app', "Error! <br />\nIt is not possible to create a digitally signed PDF file and/or send it by mail without having certificate file located at current users' configuration page.\nYou should make a certificate file with third party software and import it through 'certificate file' field, separately for each user, within configuration zone of the user. You also should input the password for the certificate file in 'password for digital signature certificate' field in the above mentioned user configuration page.\nYou can find instructions for making self signed certificate file with Acrobat reader (One of the options. There are many applications able to make such a certificate out there) here: "); throw new \Exception($text); //Yii::$app->end(); } } return $doc_file; }
echo Yii::t('app', 'Fax'); ?> : <?php echo Linet3Helper::getSetting('company.fax'); ?> <br /> <?php echo Linet3Helper::getSetting('company.website'); ?> <br /> <?php echo Yii::t('app', 'VAT No.'); ?> : <?php echo Linet3Helper::getSetting('company.vat.id'); ?> <br /> </div> <div class="logo"> <?php if (Linet3Helper::hasLogo()) { echo yii\helpers\Html::img(Linet3Helper::getLogo(), ['class' => 'logo']); } ?> </div> </div> <hr class="lineHR" />
private function stock($item_id, $qty) { if (\app\helpers\Linet3Helper::getSetting('company.stock')) { // remove from stock. $stockAction = $this->docType->stockAction; if ($stockAction) { if ($this->docType->stockSwitch) { //if has check box if (!$this->stockSwitch) { //if not checked return; } } $account_id = \app\models\User::getWarehouse($this->owner); $oppt_account_id = $this->account_id; if ((int) $this->oppt_account_id != 0) { if ($this->doctype == 15) { //only if transfer //mybe shuld be only if oppt_account_type==8 wherehouse $account_id = $this->account_id; $oppt_account_id = $this->oppt_account_id; } } return stockAction::newTransaction($this->id, $account_id, $oppt_account_id, $item_id, $qty * $stockAction); } } return false; }
public function pay() { $this->dates(); $this->payvat_acc = \app\helpers\Linet3Helper::getSetting('company.acc.payvat'); $date = $this->to_date; $cur = \app\helpers\Linet3Helper::getSetting('company.cur'); $owner = Yii::$app->user->id; $line = 1; $accout = new Transactions(); $accout->account_id = $this->selvat_acc; $accout->type = 6; //$accout->refnum1 = $this->from_date; //$accout->refnum2 = $this->to_date; $accout->valuedate = $date; $accout->details = Yii::t('app', 'vat') . " " . $this->from_month . "-" . $this->to_month . "/" . $this->year; $accout->currency_id = $cur; $accout->owner_id = $owner; $accout->linenum = $line; $accout->sum = $this->selvat_total * -1.0; $line++; $num = $accout->save(); $accout = new Transactions(); $accout->account_id = $this->payvat_acc; $accout->type = 6; $accout->num = $num; //$accout->refnum1 = $this->from_date; //$accout->refnum2 = $this->to_date; $accout->valuedate = $date; $accout->details = Yii::t('app', 'vat') . " " . $this->from_month . "-" . $this->to_month . "/" . $this->year; $accout->currency_id = $cur; $accout->owner_id = $owner; $accout->linenum = $line; $accout->sum = $this->selvat_total; $line++; $accout->save(); $accout = new Transactions(); $accout->account_id = $this->buyvat_acc; $accout->type = 6; $accout->num = $num; //$accout->refnum1 = $this->from_date; //$accout->refnum2 = $this->to_date; $accout->valuedate = $date; $accout->details = Yii::t('app', 'vat') . " " . $this->from_month . "-" . $this->to_month . "/" . $this->year; $accout->currency_id = $cur; $accout->owner_id = $owner; $accout->linenum = $line; $accout->sum = $this->buyvat_total; $line++; $accout->save(); $accout = new Transactions(); $accout->account_id = $this->payvat_acc; $accout->type = 6; $accout->num = $num; //$accout->refnum1 = $this->from_date; //$accout->refnum2 = $this->to_date; $accout->valuedate = $date; $accout->details = Yii::t('app', 'vat') . " " . $this->from_month . "-" . $this->to_month . "/" . $this->year; $accout->currency_id = $cur; $accout->owner_id = $owner; $accout->linenum = $line; $accout->sum = $this->buyvat_total * -1.0; $line++; $accout->save(); $accout = new Transactions(); $accout->account_id = $this->assetvat_acc; $accout->type = 6; $accout->num = $num; //$accout->refnum1 = $this->from_date; //$accout->refnum2 = $this->to_date; $accout->valuedate = $date; $accout->details = Yii::t('app', 'vat') . " " . $this->from_month . "-" . $this->to_month . "/" . $this->year; $accout->currency_id = $cur; $accout->owner_id = $owner; $accout->linenum = $line; $accout->sum = $this->assetvat_total; $line++; $accout->save(); $accout = new Transactions(); $accout->account_id = $this->payvat_acc; $accout->type = 6; $accout->num = $num; //$accout->refnum1 = $this->from_date; //$accout->refnum2 = $this->to_date; $accout->valuedate = $date; $accout->details = Yii::t('app', 'vat') . " " . $this->from_month . "-" . $this->to_month . "/" . $this->year; $accout->currency_id = $cur; $accout->owner_id = $owner; $accout->linenum = $line; $accout->sum = $this->assetvat_total * -1.0; $line++; $accout->save(); //$s = $this->selvat_total * -1.0; //$tnum = Transaction(0, VAT, SELLVAT, $ref1, $ref2, $date, _('VAT'), $s); //$tnum = Transaction($tnum, VAT, PAYVAT, $ref1, $ref2, $date, _('VAT'), $sellvat); //$b = $this->buyvat_total * -1.0; //$tnum = Transaction(0, VAT, BUYVAT, $ref1, $ref2, $date, _('VAT'), $buyvat); //$tnum = Transaction($tnum, VAT, PAYVAT, $ref1, $ref2, $date, _('VAT'), $b); //$a = $this->assetvat_total * -1.0; //$tnum = Transaction(0, VAT, ASSETVAT, $ref1, $ref2, $date, _('VAT'), $assetvat); //$tnum = Transaction($tnum, VAT, PAYVAT, $ref1, $ref2, $date, _('VAT'), $a); }
?> "> <?php NavBar::end(); ?> <div class="row"> <div id='sidebar' class="col-md-2"> <a class='block' href="<?php echo yii\helpers\BaseUrl::base() . '/settings/dashboard'; ?> "> <?php if (\app\helpers\Linet3Helper::hasLogo()) { echo Html::img(\app\helpers\Linet3Helper::getLogo(), ['width' => '100px']); } else { echo Html::tag('h7', \app\helpers\Linet3Helper::getSetting('company.name')); } ?> <!--<span class="label user-label">16</span>--> </a> <div class="media-body hidden-tablet"> <!--<h5 class="media-heading"><?php //echo Yii::$app->user->fname . " " . Yii::app()->user->lname; ?> </h5>--> <ul class="unstyled user-info"> <li>
echo app\widgets\GridView::widget(array('id' => 'profloss-grid', 'dataProvider' => $model->docsTable(), 'columns' => array(array('header' => Yii::t('app', 'ID'), 'attribute' => 'id'), array('header' => Yii::t('app', 'Name'), 'attribute' => 'name'), array('header' => Yii::t('app', 'Count'), 'attribute' => 'count'), array('header' => Yii::t('app', 'Sum'), 'attribute' => 'sum')))); //*/ ?> </div> <p><?php echo Yii::t('app', 'Data extracted through'); ?> : Linet <?php echo \app\helpers\Linet3Helper::getVersion(); ?> </p> <p><?php echo Yii::t('app', 'Registration Certificate No.'); ?> : <?php echo \app\helpers\Linet3Helper::getSetting('system.auth'); ?> </p> <p><?php echo Yii::t('app', 'Extraction date and time'); ?> : <?php echo Yii::$app->formatter->asDate(time(), app\models\Docs::DATETIME_FORMAT); ?> </p> <br /> </div> <?php app\widgets\MiniForm::end(); $this->registerJs("var baseAddress='" . yii\helpers\BaseUrl::base() . "';" . '$("#printThis").click(function (e) {e.preventDefault();window.print();});', \yii\web\View::POS_READY);
public static function getLogo() { if (!\app\helpers\Linet3Helper::isConsole()) { return \Yii::$app->urlManager->createAbsoluteUrl("/site/download/" . Linet3Helper::getSetting('company.logo')); //$base . ; } else { //console $download = \app\models\Download::findOne(["id" => Linet3Helper::getSetting('company.logo')]); $id = (int) $download->file_id; $logo = \app\models\Files::findOne($id); return $logo->getFullFilePath(); } }
/** * Returns the static model of the specified AR class. * Please note that you should have this exact method in all your CActiveRecord descendants! * @param string $className active record class name. * @return DatabasesPerm the static model class */ public static function buildUserMenu($settings = []) { if (Yii::$app->user->isGuest) { return array(array('label' => Yii::t('app', 'Login'), 'url' => array('/site/login'), 'visible' => Yii::$app->user->isGuest)); } $settings['company.doublebook'] = \app\helpers\Linet3Helper::getSetting('company.doublebook'); return Menu::buildMenu(0, $settings); }
function hasCert() { $configPath = \app\helpers\Linet3Helper::getSetting("company.path"); return file_exists($this->getCertFilePath()); }
public function beforeSave($insert) { $this->num = $this->newNum(); if ($this->reg_date == null) { $this->reg_date = date("Y-m-d H:i:s"); } $cur = \app\helpers\Linet3Helper::getSetting('company.cur'); $acc = Accounts::findOne($this->account_id); if ($acc === null) { $acccur = $this->currency_id; } else { $acccur = $acc->currency_id; } if ($this->currency_id == '') { $this->currency_id = $cur; $this->sum = $this->leadsum; } //leadsum if ($cur == $this->currency_id) { $this->leadsum = $this->sum; } else { $rate = Currates::GetRate($this->currency_id, $this->valuedate); $this->leadsum = $this->sum * $rate; } //set sum accourding to acc if (!isset($this->sum)) { //adam need to dubl chk if ($this->currency_id != $acccur) { $this->currency_id = $acccur; $rate = Currates::GetRate($acccur, $this->valuedate); if ($rate == 0) { throw new \Exception(Yii::t('app', 'The rate for') . $this->currency_id . Yii::t('app', 'is invalid')); } $this->sum = $this->leadsum / $rate; } } //secsum $seccur = \app\helpers\Linet3Helper::getSetting('company.seccur'); //$seccur = Yii::$app->user->settings['company.seccur']; if ($seccur != '') { if ($seccur == $this->currency_id) { $this->secsum = $this->sum; } else { $rate = Currates::GetRate($this->currency_id, $this->valuedate); if ($rate == 0) { throw new \Exception(Yii::t('app', 'The sec rate for') . $seccur . $this->currency_id . Yii::t('app', 'is invalid')); } $this->secsum = $this->leadsum / $rate; } } return true; }
protected function openfrmtFieldStr($field, $line, $begin = null, $end = null) { //, $value = ""; if ($value == '' && $field->export != 'NA') { $value = $field->export; } if ($field->export == "file.line") { $value = $line; } if ($field->export == "company.vatnum") { $value = \app\helpers\Linet3Helper::getSetting('company.vat.id'); } if (strpos($field->export, "this.") === 0) { if (isset($this->{str_replace("this.", "", $field->export)})) { $value = $this->{str_replace("this.", "", $field->export)}; } } if (strpos($field->export, "system.") === 0) { $value = \app\helpers\Linet3Helper::getSetting($field->export); } if (strpos($field->export, "func.") === 0) { $value = $this->{str_replace("func.", "", $field->export)}(); } if (strpos($field->export, "limit.") === 0) { $value = $this->{str_replace("limit.", "", $field->export)}($begin, $end); } if ($field->export == "start") { $value = $begin; } if ($field->export == "end") { $value = $end; } /* * **************************************************************************************************** */ $template = "%0" . $field->size . "d"; if ($field->type == 's') { $template = "% " . $field->size . "s"; } if ($field->type == 'n') { $template = "%0" . $field->size . "d"; } if ($field->type == 'date') { //date return $this->readOFDate($value); } if ($field->type == 'hour') { //hour //$phpdbdatetime = Yii::$app->locale->getDateFormat('yiidatetime'); //phpdbdatetime return $this->readOFTime($value); } if ($field->type == '99') { //v99 $template = "%0" . $field->size . "d"; $value = round($value * 100); if ($value < 0) { $value = $value * -1; } return sprintf($template, $value); } if ($field->type == 'v99') { //v99 $template = "%0" . ($field->size - 1) . "d"; $value = round($value * 100); if ($value >= 0) { $sign = "+"; } else { $sign = "-"; $value = $value * -1; } return $sign . sprintf($template, $value); } if ($field->type == 'v9999') { //v9999 $template = "%0" . ($field->size - 1) . "d"; $value = round($value * 10000); if ($value >= 0) { $sign = "+"; } else { $sign = "-"; $value = $value * -1; } return $sign . sprintf($template, $value); } //ini_set('mbstring.substitute_character', "none"); //$value= mb_convert_encoding($value, 'UTF-8', 'UTF-8'); $value = htmlentities($value); $value = str_replace("&", "&", $value); $value = @iconv("UTF-8", "CP1255", $value); //$value=mb_convert_encoding($value, "windows-1255",'utf-8'); $value = substr($value, 0, $field->size); return sprintf($template, $value); }
/** * Returns the static model of the specified AR class. * Please note that you should have this exact method in all your CActiveRecord descendants! * @param string $className active record class name. * @return Company the static model class */ public function getName() { $this->select($this->id); //ettings::refresh(); $name = \app\helpers\Linet3Helper::getSetting('company.name'); return $name; }