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>