private function calc($account_type)
{
$accounts = Accounts::find()->where(['type' => $account_type])->All();
$sum = 0;
$data = array();
$stime = "00:00:01";
$etime = "23:59:59";
$from_date = "{$this->year}-01-01 {$stime}";
$to_date = "{$this->year}-12-31 {$etime}";
foreach ($accounts as $account) {
$sum = $account->getTotal($from_date, $to_date);
if ($sum != 0) {
$accounty = array('id' => $account->id, 'name' => $account->name, 'sum' => $sum, 'id6111' => $account->id6111);
for ($x = 1; $x <= 12; $x++) {
if ($x <= 9) {
$a = "0{$x}";
} else {
$a = $x;
}
$last = 31;
while (!checkdate($x, $last, $this->year)) {
$last--;
}
$accounty[$x] = $account->getTotal("{$this->year}-{$a}-01 {$stime}", "{$this->year}-{$a}-{$last} {$etime}");
}
$data[] = $accounty;
}
}
return $data;
}
/**
* @param $id
*/
public static function edit($id)
{
$post = Posts::findByPK($id);
if (!Request::is_authenticated()) {
Session::push('flash-message', 'You must login before!');
Response::redirect('login?next=post/edit/' . $id);
} else {
if (Request::user()->id !== $post['id_account']) {
Session::push('flash-message', 'You does not have permission to edit the other Member\'s post!');
Response::redirect('');
}
}
if ("POST" == Request::method()) {
$id_member = Request::user()->id;
$data = Request::POST()->post;
$title = Request::POST()->title;
$cat = Request::POST()->category;
Posts::edit($id, $id_member, $title, $data, $cat);
# set flash messages
Session::push('flash-message', 'Your post has changed successfully!');
Response::redirect('post/read/' . $id);
} else {
$users = Accounts::find(['type' => 2]);
$categories = Categories::all();
View::render('member/edit-post', ['post' => $post, 'users' => $users, 'categories' => $categories]);
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Accounts::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'type' => $this->type, 'id6111' => $this->id6111, 'cat_id' => $this->cat_id, 'pay_terms' => $this->pay_terms, 'src_tax' => $this->src_tax, 'src_date' => $this->src_date, 'parent_account_id' => $this->parent_account_id, 'system_acc' => $this->system_acc, 'owner' => $this->owner, 'modified' => $this->modified, 'created' => $this->created]);
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'contact', $this->contact])->andFilterWhere(['like', 'department', $this->department])->andFilterWhere(['like', 'vatnum', $this->vatnum])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'phone', $this->phone])->andFilterWhere(['like', 'dir_phone', $this->dir_phone])->andFilterWhere(['like', 'cellular', $this->cellular])->andFilterWhere(['like', 'fax', $this->fax])->andFilterWhere(['like', 'web', $this->web])->andFilterWhere(['like', 'address', $this->address])->andFilterWhere(['like', 'city', $this->city])->andFilterWhere(['like', 'zip', $this->zip])->andFilterWhere(['like', 'currency_id', $this->currency_id])->andFilterWhere(['like', 'comments', $this->comments]);
return $dataProvider;
}
public function accounts()
{
$accountQ = Accounts::find();
if (substr_count($this->acc, ",") != 0) {
$accs = explode(",", $this->acc);
foreach ($accs as $acc) {
$accountQ = $this->between($acc, $accountQ);
}
} else {
$accountQ = $this->between($this->acc, $accountQ);
}
return $this->chkType($accountQ)->asArray()->all();
}
/**
* Retrieves a list of models based on the current search/filter conditions.
* @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
*/
public function search($params)
{
$query = Accounts::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
return $dataProvider;
}
$criteria->compare('id', $this->id, true);
$criteria->compare('company_id', $this->company_id, true);
$criteria->compare('file_id', $this->file_id, true);
return new CActiveDataProvider($this, array('criteria' => $criteria));
}
private function calc($account_type)
{
$accounts = Accounts::find()->where(['type' => $account_type])->All();
$sum = 0;
$data = array();
foreach ($accounts as $account) {
$sum = $account->getTotal($this->from_date . " 00:00:01", $this->to_date . " 23:59:59");
if ($sum != 0) {
$data[] = array('id' => $account->id, 'name' => $account->name, 'sum' => $sum, 'id6111' => $account->id6111);
}
}
return $data;
}
/**
* Retrieves a list of models based on the current search/filter conditions.
*
* Typical usecase:
* - Initialize the model fields with values from filter form.
* - Execute this method to get CActiveDataProvider instance which will filter
* models according to data in model fields.
* - Pass data provider to CGridView, CListView or any similar widget.
*
* @return CActiveDataProvider the data provider that can return the models
* based on the search/filter conditions.
*/
public function search($params)
{
// @todo Please modify the following code to remove attributes that should not be searched.
$query = Accounts::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
return $dataProvider;
}
$criteria->compare('id', $this->id);
$criteria->compare('name', $this->name, true);
return new CActiveDataProvider($this, array('criteria' => $criteria));
}
/**
* Use this function for authenticated member and ustadz
* if the authenticated is failure, the user will be redirect to
* warning page that they can input username and pass again
*
* @param $username : username user
* @param $password : password user
* @return bool
*/
public static function auth($username, $password)
{
$data = Accounts::find(['username' => $username, 'password' => md5($password)]);
if ($data) {
# validate was successed
# Set a session ID
$account = array($data['id'], $data['username'], $data['name'], $data['type']);
$session = new Session();
$session->set('id_account', implode('|', $account));
return TRUE;
}
# validate was failure
return FALSE;
}
private function calc($account_type)
{
$accounts = Accounts::find()->where(['type' => $account_type])->All();
$sum = 0;
$data = array();
foreach ($accounts as $account) {
$line = $account->getTotal($this->from_date . " 00:00:00", $this->to_date . " 23:59:59");
if ($line != 0) {
$data[] = array('id' => $account->id, 'name' => $account->name, 'sum' => $line, 'id6111' => $account->id6111);
$sum += $line;
}
}
$data[] = array('id' => '', 'name' => Yii::t('app', 'Total'), 'sum' => $sum, 'id6111' => '');
return $data;
}
/**
* Retrieves a list of models based on the current search/filter conditions.
* @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
*/
public function search($params)
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$query = Accounts::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
return $dataProvider;
}
$criteria->compare('id', $this->id);
$criteria->compare('AccTemplate_id', $this->AccTemplate_id);
$criteria->compare('eavFields_id', $this->eavFields_id);
return new CActiveDataProvider($this, array('criteria' => $criteria));
}
public static function index()
{
# if user was login before and the session is still valid
if (Request::is_authenticated()) {
if (Request::is_admin()) {
AdminController::index();
} else {
MemberController::index();
}
} else {
$posts = Posts::all((new DbCriteria())->order_by('created_at')->DESC());
# set criteria
$criteria = (new DbCriteria())->order_by('viewers')->DESC()->LIMIT(5);
$hotposts = Posts::all($criteria)->fetchAll();
$users = Accounts::find(['type' => 2]);
$categories = Categories::all();
# /app/views/home.php
View::render('home', ['hotposts' => $hotposts, 'posts' => $posts, 'users' => $users, 'categories' => $categories]);
}
}
public static function addMember()
{
if ("POST" == Request::method()) {
$username = Request::POST()->username;
$email = Request::POST()->email;
$pass = Request::POST()->password;
$name = Request::POST()->name;
$type = Request::POST()->type;
$photo = File::upload('img', 'photo');
# if username has used by another member
if (Accounts::find(['username' => $username])) {
Session::push('flash-message', 'That username has used by other member, please use another!');
Response::redirect('accounts/add');
}
Accounts::create($username, $pass, $name, $email, $photo, $type);
# push flash-message
Session::push('flash-message', 'That members has successfuly added!');
Response::redirect('accounts');
} else {
$categories = Categories::all()->fetchAll(\PDO::FETCH_CLASS);
View::render('admin/account-add', ['categories' => $categories]);
}
}
public static function findAllByType($type)
{
return Accounts::find()->where(array('type' => $type))->All();
}
<table class='formy'>
<tr>
<th><?php
echo Yii::t('app', "Account");
?>
</th>
<th><?php
echo Yii::t('app', "Acct. balance");
?>
</th>
</tr>
<?php
$temp = \yii\helpers\ArrayHelper::map(\app\models\Accounts::find()->All(), 'id', 'name');
$temp[0] = Yii::t('app', 'Chose Account');
for ($i = 0; $i < 10; $i++) {
echo "<tr>\n<td>\n";
echo \yii\helpers\Html::dropDownList('account[]', 0, $temp);
echo "</td><td>\n";
echo "<input type=\"text\" class=\"bal\" name=\"bal[]\" dir=\"ltr\" />\n";
echo "</td>\n</tr>\n";
}
?>
</table>
public function actionSearch($q = null, $id = null, $type = 0)
{
\Yii::$app->response->format = \yii\web\Response::FORMAT_JSON;
$out = ['results' => ['id' => '', 'text' => '']];
if (!is_null($q)) {
$query = new \yii\db\Query();
$query->select('id, name AS text')->from('{{%accounts}}')->where('name LIKE "%' . $q . '%"')->andWhere(['type' => $type])->limit(20);
$command = $query->createCommand();
$data = $command->queryAll();
$out['results'] = array_values($data);
} elseif ($id > 0) {
$out['results'] = ['id' => $id, 'text' => Accounts::find($id)->name];
}
return $out;
}
public static function register()
{
# if user was login before
if (Request::is_authenticated()) {
# redirect to main page
Response::redirect('');
}
if ("POST" == Request::method()) {
$username = Request::POST()->username;
$email = Request::POST()->email;
$pass = Request::POST()->password;
$name = Request::POST()->name;
$photo = File::upload('img', 'photo');
# if username has used by another member
if (Accounts::find(['username' => $username])) {
Session::push('flash-message', 'That username has used by other member, please use another!');
Response::redirect('register');
}
Accounts::create($username, $pass, $name, $email, $photo);
# set a session
self::auth($username, $pass);
Session::push('flash-message-info', "Welcome to iniForum, <strong>{$name}</strong>!");
Response::redirect('');
} else {
View::render('member/register');
}
}
?>
<div>
<?php
echo \app\widgets\Refnum::widget(['model' => $model, 'attribute' => 'refnum']);
?>
</div>
<?php
echo $form->field($model, 'date')->widget(DateControl::classname(), ['type' => 'date']);
?>
<?php
echo $form->field($model, 'opp_account_id')->widget(Select2::className(), ['data' => \yii\helpers\ArrayHelper::map(Accounts::find()->where(array('type' => 7))->all(), 'id', 'name')]);
//7=banks
?>
<div class="form-actions">
<?php
echo \yii\helpers\Html::submitButton(Yii::t('app', 'Create'), ['class' => 'btn btn-success']);
?>
</div>
<?php
kartik\form\ActiveForm::end();
?>
<div class="form">
<?php
use yii\helpers\ArrayHelper;
use kartik\select2\Select2;
$form = kartik\form\ActiveForm::begin(array('id' => 'accounts-form' . $model->type, 'options' => array('enctype' => 'multipart/form-data')));
$id6111 = ArrayHelper::map(\app\models\AccId6111::find()->All(), 'id', 'name');
$id6111[0] = Yii::t('app', 'None');
$currncies = ArrayHelper::map(\app\models\Currates::GetRateList(), 'currency_id', 'name');
$accounts = ArrayHelper::map(\app\models\Accounts::find()->all(), 'id', 'name');
$accounts[0] = Yii::t('app', 'None');
$acccat = ArrayHelper::map(\app\models\AccCat::find()->where(["type_id" => $model->type])->all(), 'id', 'name');
?>
<?php
echo $form->errorSummary($model);
?>
<?php
echo $form->field($model, 'type', ['template' => '{input}'])->hiddenInput();
?>
<div class="col-md-4 col-sm-6">
<?php
app\widgets\TbPanel::begin(array('header' => Yii::t('app', "Account General Details")));
?>
<?php
echo $form->field($model, 'name');
?>
<?php
echo $form->field($model, 'cat_id')->dropDownList($acccat);
?>
</tr>
</tfoot>
<tbody id="det">
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<?php
$this->registerJs("var baseAddress='" . yii\helpers\BaseUrl::base() . "';" . "var accountSelect='" . str_replace("\n", "", $form->field($model, 'ops', ['template' => '{input}'])->dropDownList(\yii\helpers\ArrayHelper::map(Accounts::find()->All(), 'id', 'name'))) . "';" . "var msg='" . Yii::t('app', 'sum is not 0') . "';", \yii\web\View::POS_HEAD);
$this->registerJsFile(yii\helpers\BaseUrl::base() . '/assets/transaction.js', ['depends' => [\yii\web\JqueryAsset::className()]]);
?>
<div class="form-actions">
<?php
echo \yii\helpers\Html::submitButton(Yii::t('app', 'Save'), ['class' => 'btn btn-success']);
?>
</div>
<?php
kartik\form\ActiveForm::end();
?>
<?php
public function make($cid)
{
$this->id = rand(0, 999999);
//$this->iniArr=array('b110'=>0,'b100'=>0,'m100'=>0,'c100'=>0,'d100'=>0,'d110'=>0,'d120'=>0,);
//$this->docArr=array(0=>0,305=>0,300=>0,);
$bkmv = '';
//$this->line=1;
//$yiidatetimesec=Yii::$app->locale->getDateFormat('yiidatetimesec');
//$phpdbdatetime=Yii::$app->locale->getDateFormat('phpdbdatetime');
$from_date = $this->from_date . " 00:00:00";
$to_date = $this->to_date . " 23:59:59";
//$types=array(3,4,9,11,13,14);
//accounts
$accounts = Accounts::find()->All();
$record = array('id' => 'B110', 'name' => OpenFormatType::getDesc('B110'), 'count' => 0);
foreach ($accounts as $account) {
$this->line++;
$bkmv .= $account->openfrmt($this->line, $from_date, $to_date);
$record['count']++;
}
$this->iniArr[] = $record;
//items
$items = Item::find()->All();
$record = array('id' => 'M100', 'name' => OpenFormatType::getDesc('M100'), 'count' => 0);
foreach ($items as $item) {
$this->line++;
$bkmv .= $item->openfrmt($this->line, $from_date, $to_date);
$record['count']++;
}
$this->iniArr[] = $record;
//
//transactions
$transactions = Transactions::find()->where(['BETWEEN', 'valuedate', $from_date, $to_date])->All();
$record = array('id' => 'B100', 'name' => OpenFormatType::getDesc('B100'), 'count' => 0);
foreach ($transactions as $transaction) {
$this->line++;
$bkmv .= $transaction->openfrmt($this->line, $from_date, $to_date);
$record['count']++;
}
$this->iniArr[] = $record;
//docs
$docs = Docs::find()->where(['BETWEEN', 'due_date', $from_date, $to_date])->All();
//OpenFormatType::getDesc('C100')
$record = array('id' => 'C100', 'name' => OpenFormatType::getDesc('C100'), 'count' => 0);
$d110 = array('id' => 'D110', 'name' => OpenFormatType::getDesc('D110'), 'count' => 0);
$d120 = array('id' => 'D120', 'name' => OpenFormatType::getDesc('D120'), 'count' => 0);
foreach ($docs as $doc) {
if ($doc->docType->openformat != '0') {
$this->line++;
$bkmv .= $doc->openfrmt($this->line, $from_date, $to_date);
foreach ($doc->docDetailes as $detial) {
$this->line++;
$bkmv .= $detial->openfrmt($this->line, $from_date, $to_date);
$d110['count']++;
}
foreach ($doc->docCheques as $detial) {
$this->line++;
$bkmv .= $detial->openfrmt($this->line, $from_date, $to_date);
$d120['count']++;
}
$type = $doc->OpenfrmtType();
$this->docArr[$type] = isset($this->docArr[$type]) ? $this->docArr[$type] + 1 : 0;
$this->docSumArr[$type] = isset($this->docSumArr[$type]) ? $this->docSumArr[$type] + $doc->total : $doc->total;
$record['count']++;
}
}
$this->iniArr[] = $record;
$this->iniArr[] = $d110;
$this->iniArr[] = $d120;
$company = \app\models\Settings::findOne(['company.name']);
//A100
$bkmv = $company->a100(1, $this->id, $from_date, $to_date) . $bkmv;
//Z900
$bkmv = $bkmv . $company->z900($this->line + 1, $this->id, $this->line + 1);
$bkmvFile = new Files();
$bkmvFile->name = 'bkmvdata.txt';
$bkmvFile->path = 'openformat/';
//
$bkmvFile->expire = 360;
$bkmvFile->save();
$bkmvFile->writeFile($bkmv);
$this->bkmvId = $bkmvFile->id;
//A000
$ini = $company->a000(1, $this->id, $this->line + 1, $from_date, $to_date);
foreach ($this->iniArr as $line) {
$ini .= $line['id'] . sprintf("%015d", $line['count']) . "\r\n";
}
//Z
$iniFile = new Files();
$iniFile->name = 'ini.txt';
$iniFile->path = 'openformat/';
//
$iniFile->expire = 360;
$iniFile->save();
$iniFile->writeFile($ini);
$this->iniId = $iniFile->id;
return $this->id;
}
