public function initialize()
{
$this->add(new Text('name', array('maxlength' => 100, 'type' => 'text', 'placeholder' => 'Nombre de la cuenta', 'required' => 'required', 'class' => 'form-control', 'id' => 'name')));
$this->add(new Text('nit', array('maxlength' => 20, 'type' => 'text', 'placeholder' => 'NIT', 'class' => 'form-control', 'id' => 'nit')));
$this->add(new Email('email', array('maxlength' => 100, 'type' => 'email', 'placeholder' => 'Dirección de correo eléctronico', 'required' => 'required', 'class' => 'form-control', 'id' => 'email')));
$this->add(new Text('phone', array('maxlength' => 30, 'type' => 'text', 'placeholder' => 'Número de télefono o celular', 'required' => 'required', 'class' => 'form-control', 'id' => 'phone')));
$this->add(new Text('address', array('maxlength' => 100, 'type' => 'text', 'placeholder' => 'Dirección', 'required' => 'required', 'class' => 'form-control', 'id' => 'phone')));
$countries = array("" => "Seleccione una opción");
foreach (Country::find() as $country) {
$countries[$country->idCountry] = $country->name;
}
$this->add(new Select('idCountry', $countries, array('class' => 'form-control', 'required' => 'required')));
$this->add(new Select('state', array(), array('class' => 'form-control', 'required' => 'required')));
$this->add(new Select('city', array(), array('class' => 'form-control', 'required' => 'required')));
$this->add(new Text('accountName', array('maxlength' => 100, 'type' => 'text', 'placeholder' => 'Nombre de la cuenta', 'required' => 'required', 'class' => 'form-control', 'id' => 'name')));
$this->add(new Email('accountEmail', array('maxlength' => 100, 'type' => 'email', 'placeholder' => 'Dirección de correo eléctronico', 'required' => 'required', 'class' => 'form-control', 'id' => 'email')));
$this->add(new Text('accountPhone', array('maxlength' => 30, 'type' => 'text', 'placeholder' => 'Número de télefono o celular', 'required' => 'required', 'class' => 'form-control', 'id' => 'phone')));
$this->add(new Text('accountAddress', array('maxlength' => 100, 'type' => 'text', 'placeholder' => 'Dirección', 'required' => 'required', 'class' => 'form-control', 'id' => 'phone')));
$this->add(new Select('idAccountplan', array()));
$accounttypes = array("" => "Seleccione una opción");
foreach (Accounttype::find() as $accounttype) {
$accounttypes[$accounttype->idAccounttype] = $accounttype->name;
}
$this->add(new Select('idAccounttype', $accounttypes, array('class' => 'select2 form-control', 'required' => 'required')));
$this->add(new Check('status', array('value' => 1, 'id' => 'status', 'class' => 'onoffswitch-checkbox', 'id' => 'status')));
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer the ID of the model to be loaded
*/
public function loadModel($id)
{
$model = Accounttype::model()->findByPk((int) $id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
?>
<?php
echo $form->error($model, 'accounttypename');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'parentaccounttypeid');
?>
<?php
echo $form->hiddenField($model, 'parentaccounttypeid');
?>
<input type="text" name="parentaccounttypename" id="parentaccounttypename" readonly style="width:80%" value="
<?php
echo Accounttype::model()->findByPk($model->parentaccounttypeid) !== null ? Accounttype::model()->findByPk($model->parentaccounttypeid)->accounttypename : '';
?>
">
<?php
$this->beginWidget('zii.widgets.jui.CJuiDialog', array('id' => 'parentaccounttype_dialog', 'options' => array('title' => Yii::t('app', 'Account Type'), 'width' => 'auto', 'autoOpen' => false, 'modal' => true)));
$this->widget('zii.widgets.grid.CGridView', array('id' => 'parentaccounttype-grid', 'dataProvider' => $parentaccounttype->searchwstatus(), 'filter' => $parentaccounttype, 'template' => '{summary}{pager}<br>{items}{pager}{summary}', 'columns' => array(array('header' => '', 'type' => 'raw', 'value' => 'CHtml::Button("+",
array("name" => "send_absstatus",
"id" => "send_absstatus",
"onClick" => "$(\\"#parentaccounttype_dialog\\").dialog(\\"close\\");
$(\\"#parentaccounttypename\\").val(\\"$data->accounttypename\\");
$(\\"#Accounttype_parentaccounttypeid\\").val(\\"$data->accounttypeid\\");"))'), array('name' => 'accounttypeid', 'visible' => false, 'value' => '$data->accounttypeid', 'htmlOptions' => array('width' => '1%')), 'accounttypename', array('class' => 'CCheckBoxColumn', 'name' => 'recordstatus', 'selectableRows' => '0', 'header' => 'Record Status', 'checked' => '$data->recordstatus'))));
$this->endWidget('zii.widgets.jui.CJuiDialog');
echo CHtml::Button('...', array('onclick' => '$("#parentaccounttype_dialog").dialog("open"); return false;'));
?>
<?php
echo $form->error($model, 'parentaccountid');
public function actionUpload()
{
parent::actionUpload();
$folder = $_SERVER['DOCUMENT_ROOT'] . Yii::app()->request->baseUrl . '/upload/';
// folder for uploaded files
$file = $folder . basename($_FILES['uploadfile']['name']);
if (move_uploaded_file($_FILES['uploadfile']['tmp_name'], $file)) {
$row = 0;
if (($handle = fopen($file, "r")) !== FALSE) {
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
if ($row > 0) {
$model = Account::model()->findByPk((int) $data[0]);
if ($model === null) {
$model = new Account();
}
$model->accountid = (int) $data[0];
$model->accountcode = $data[1];
$model->accountname = $data[2];
if ($data[3] != '') {
$model->parentaccountid = (int) $data[3];
} else {
$model->parentaccountid = null;
}
if ($data[4] != '') {
$accounttype = Accounttype::model()->findbysql("select * from accounttype where upper(accounttypename) = upper('" . $data[4] . "')");
if ($accounttype != null) {
$model->accounttypeid = $accounttype->accounttypeid;
} else {
$model->accounttypeid = null;
}
} else {
$model->accounttypeid = null;
}
if ($data[5] != '') {
$currency = Currency::model()->findbysql("select * from currency where upper(currencyname) = upper('" . $data[5] . "')");
if ($currency != null) {
$model->currencyid = $currency->currencyid;
} else {
$model->currencyid = null;
}
} else {
$model->currencyid = null;
}
$model->recordstatus = $data[6];
try {
if (!$model->save()) {
$this->messages = $this->messages . Catalogsys::model()->getcatalog(' upload error at ' . $data[0]);
}
} catch (Exception $e) {
$this->messages = $this->messages . $e->getMessage();
}
}
$row++;
}
} else {
$this->messages = $this->messages . ' memory or harddisk full';
}
fclose($handle);
} else {
$this->messages = $this->messages . ' check your directory permission';
}
if ($this->messages == '') {
$this->messages = 'success';
}
echo $this->messages;
}
