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 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 init()
{
date_default_timezone_set('Asia/Tel_Aviv');
//\Yii::$app->language = 'he_il';
//if ($this->company==null) {
// Yii::$app->user->Set('Company', 0);
//}
if (!Yii::$app->user->isGuest) {
\app\helpers\Linet3Helper::SetTheme();
date_default_timezone_set(Yii::$app->user->getParam('timezone'));
Yii::$app->language = Yii::$app->user->getParam('language');
Yii::$app->timezone = Yii::$app->user->getParam('timezone');
//Yii::$app->theme = Yii::$app->user->getParam('theme');
if (isset(Yii::$app->session['company'])) {
$this->company = Yii::$app->session['company'];
//if(Yii::$app->user->getParam('company')!=0){
// $this->company = Yii::$app->user->getParam('company');
//Yii::$app->session['company']=0;
//}
}
} else {
//default theme
//Yii::$app->theme = 'admin4';
}
Yii::info("Selected Company ID: " . $this->company);
if ($this->company == 0) {
if ($this->id != 'company') {
//print "'".Yii::$app->controller->id."'";
$this->redirect(\yii\helpers\BaseUrl::base() . '/company/index');
Yii::$app->end();
} else {
//echo $this->id;
//Yii::$app->end();
Yii::$app->db->close();
Yii::$app->db->dsn = Yii::$app->dbMain->dsn;
Yii::$app->db->tablePrefix = Yii::$app->dbMain->tablePrefix;
Yii::$app->db->username = Yii::$app->dbMain->username;
Yii::$app->db->password = Yii::$app->dbMain->password;
Yii::$app->db->open();
}
} else {
//hasAccess!
//$this->company = Company::findByPk($this->company);
$company = Company::findOne($this->company);
if ($company !== null) {
Company::loadComp($company);
} else {
$this->redirect(\yii\helpers\BaseUrl::base() . '/company/index');
}
}
//*/
return parent::init();
}
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 init()
{
date_default_timezone_set('Asia/Tel_Aviv');
if (!\Yii::$app->user->isGuest) {
\app\helpers\Linet3Helper::SetTheme();
date_default_timezone_set(\Yii::$app->user->getParam('timezone'));
\Yii::$app->language = Yii::$app->user->getParam('language');
}
if (Yii::$app->params['newInstall']) {
if ($this->id != 'install') {
//print "'".Yii::$app->controller->id."'";
$this->redirect(\yii\helpers\BaseUrl::base() . '/install/index');
Yii::$app->end();
}
} else {
//include('upgrade.php');
}
//Yii::app()->clientScript->registerScriptFile($baseUrl.'/js/yourscript.js');
return parent::init();
}
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 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();
}
use yii\helpers\Html;
use app\assets\AppAsset;
use app\assets\PrintAsset;
/*
use yii\bootstrap\Nav;
use yii\bootstrap\NavBar;
use yii\widgets\Breadcrumbs;
use app\assets\PrintAsset;
use app\models\Menu;
*/
/* @var $this \yii\web\View */
/* @var $content string */
//
if (!\app\helpers\Linet3Helper::isConsole()) {
//$base=yii\helpers\BaseUrl::base();
PrintAsset::register($this);
AppAsset::register($this);
//$logopath = $base."/site/download/" . Linet3Helper::getSetting('company.logo');
} else {
//console
$this->registerCssFile(Yii::$app->params['url'] . "/css/print.css");
//Yii::$app->basePath.
$this->registerCssFile(Yii::$app->params['url'] . "/css/site.css");
if (\Yii::$app->language == 'he_il') {
$this->registerCssFile(Yii::$app->params['url'] . "/css/print-rtl.css");
$this->registerCssFile(Yii::$app->params['url'] . "/css/site-rtl.css");
}
}
$this->beginPage();
public function vatnumVal($attribute, $params)
{
$value = $this->{$attribute};
if (\app\helpers\Linet3Helper::vatnumVal($value)) {
$this->addError($attribute, Yii::t('app', 'Not a valid VAT id'));
}
}
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;
}
public static function getCertFilePath($id = null)
{
if ($id == null) {
$id = \app\helpers\Linet3Helper::getUserId();
}
$user = User::findOne($id);
if ($user !== null) {
return Company::getFilePath() . "cert/" . $id . ".p12";
}
}
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);
}
protected function end()
{
//A1 type
//N9 vatid
$companyid = \app\helpers\Linet3Helper::getSetting('company.vat.id');
return sprintf("Z%09d", $companyid);
}
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;
}
/**
* 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;
}
public function getVersion()
{
return \app\helpers\Linet3Helper::getVersion();
}
?>
">
<?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 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();
}
/**
* 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);
}
public function delete()
{
return \app\helpers\Linet3Helper::getOverride("removeDB", ["dbMaster" => new dbMaster()], $this->moduleName);
}
private function saveSetting($key, $value)
{
return \app\helpers\Linet3Helper::setSetting($key, $value);
}
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();
}
}
<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" />
<div class="toBox">
<table>
<tr>
<td><?php
echo Yii::t('app', 'To');
?>
:</td>
<td><?php
echo $model->company;
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);
}
