public function up()
{
$this->update('menu', ['name' => 'Maintenance'], ['id' => 57]);
$this->update('menu', ['parent' => 80], ['id' => 58]);
$this->update('menu', ["order" => 1], ["id" => 22]);
$this->update('menu', ["order" => 2], ["id" => 37]);
$this->update('menu', ["order" => 3], ["id" => 12]);
$this->update('menu', ["order" => 4], ["id" => 32]);
$this->update('menu', ["order" => 5], ["id" => 43]);
$this->update('menu', ["order" => 6], ["id" => 16]);
$this->update('menu', ["order" => 7], ["id" => 49]);
$this->update('menu', ["order" => 8], ["id" => 80]);
$this->update('menu', ["order" => 9], ["id" => 1]);
$this->update('menu', ["order" => 10], ["id" => 57]);
$this->update('menu', ["order" => 11], ["id" => 63]);
$companys = app\models\Company::find()->All();
foreach ($companys as $company) {
$company->loadComp($company);
$this->update($company->prefix . 'docType', ["transactionType_id" => null], ["id" => "5"]);
//return doc error
$this->update($company->prefix . 'accType', ["name" => "assets & debits", "desc" => "Assets & Debits"], ["id" => "4"]);
//return doc error
//Assets & Debits
$this->update($company->prefix . 'accType', ["name" => "capital & surplus", "desc" => "Capital & Surplus"], ["id" => "5"]);
//Capital & Surplus
$this->updateC('app\\models\\Accounts', 50, ['name' => 'דיבידנד', 'src_tax' => '30', 'type' => 5, 'currency_id' => 'ILS']);
$this->updateC('app\\models\\Accounts', 51, ['name' => 'יתרת רווח והפסד', 'src_tax' => '0', 'type' => 5, 'currency_id' => 'ILS']);
}
Yii::$app->db->close();
Yii::$app->db->dsn = Yii::$app->dbMain->dsn;
//"mysql:host=localhost;dbname=devmultiadam";//
Yii::$app->db->tablePrefix = Yii::$app->dbMain->tablePrefix;
//"CA15_";//
Yii::$app->db->username = Yii::$app->dbMain->username;
//"root";//
Yii::$app->db->password = Yii::$app->dbMain->password;
//"VBy7t6r5";//
Yii::$app->db->charset = 'utf8';
Yii::$app->db->open();
return true;
}
public function up()
{
echo "m151129_074847_acctype will be set.\n";
//(95, 'In Advance Income Tax payment', 'outcome/create/2', 'type=>2', 37, 0),
echo "menu:" . $this->updateC('app\\models\\Menu', ['id' => 95], ['name' => 'In Advance Income Tax payment', 'route' => 'outcome/create/3', 'parent' => 37]);
//Test Report
$companys = app\models\Company::find()->All();
foreach ($companys as $company) {
$company->loadComp($company);
$this->updateC('app\\models\\Acctype', ['id' => 11], ['name' => 'workers', 'desc' => 'Workers', 'openformat' => '']);
}
Yii::$app->db->close();
Yii::$app->db->dsn = Yii::$app->dbMain->dsn;
//"mysql:host=localhost;dbname=devmultiadam";//
Yii::$app->db->tablePrefix = Yii::$app->dbMain->tablePrefix;
//"CA15_";//
Yii::$app->db->username = Yii::$app->dbMain->username;
//"root";//
Yii::$app->db->password = Yii::$app->dbMain->password;
//"VBy7t6r5";//
Yii::$app->db->charset = 'utf8';
Yii::$app->db->open();
return true;
}
table tr td{ border-left: #000 solid 1px; border-bottom: #000 solid 1px; padding: 5px;}
table tr th{ border-left: #000 solid 1px; border-bottom: #000 solid 1px; border-top: #000 solid 1px; padding: 5px; text-align: left; font-weight: normal;}
table{ border-right: #000 solid 1px;}
table tr th p{ margin-bottom: 10px;}
#line{ color: #FFF; font-size: 5px;}
</style>
<?php
use yii\helpers\Url;
$truck_model = new \app\models\Truck();
$config = new \app\models\Config_system();
$driver = new app\models\Driver();
$customer_model = new \app\models\Customer();
$changwat_model = new app\models\Changwat();
$producttype_model = new app\models\ProductType();
$thaibaht = new app\models\Thaibaht();
$company_model = new \app\models\Company();
$company = $company_model->find()->one();
?>
<!--
#ข้อมูลใบปฏิบัติงาน
Comment By Kimniyom
-->
<div style=" position: absolute; left: 50px; top: 30px;">
<div style="width: 80px;">
<img src="<?php
echo Url::to('@web/web/uploads/logo/' . $company['logo'], true);
?>
"/>
</div>
</div>
