/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new ProductGroup();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['ProductGroup'])) {
$model->attributes = $_POST['ProductGroup'];
if ($model->save()) {
$this->redirect(array('view', 'id' => $model->ckey));
}
}
$this->render('create', array('model' => $model));
}
public function createAction()
{
$this->view->Title = "Quản lý nhóm sản phẩm";
$this->view->headTitle($this->view->Title);
if ($this->getRequest()->isPost()) {
$request = $this->getRequest()->getParams();
$error = $this->_checkForm($request);
if (count($error) == 0) {
$Product = new ProductGroup();
$Product->merge($request);
$Product->save();
$this->Member->log('Nhóm sản phẩm:' . $Product->name . '(' . $Product->id . ')', 'Tạo mới');
My_Plugin_Libs::setSplash('Nhóm sản phẩm: <b>' . $Product->name . '</b> đã tạo thành công. ');
$this->_redirect($this->_helper->url('index', 'productgroup', 'admin'));
}
if (count($error)) {
$this->view->error = $error;
}
}
}
private function updatesimple($typic, $grtype, $result, &$info)
{
if ($typic == 2) {
$sql = "SELECT a.id AS p_id, a.ckey AS p_key, a.cname AS p_name , a.lid AS p_lid " . " FROM tmp_xml a WHERE a.user="******" AND a.ctype=" . $typic;
} else {
$sql = "SELECT a.id AS p_id, a.ckey AS p_key, a.cname AS p_name , a.lid AS p_lid," . " b.id AS g_id, b.ckey AS g_key, b.cname AS g_name, b.lid as g_lid " . " FROM tmp_xml a LEFT JOIN tmp_xml b ON a.cgr=b.ckey AND b.user="******" AND b.ctype=" . $grtype . " WHERE a.user="******" AND a.ctype=" . $typic;
}
$recs = Yii::app()->db->createCommand($sql)->query();
//we got the records for tmp_xml table
$i = 0;
$j = 0;
$jj = 0;
if (count($recs) > 0) {
foreach ($recs as $value) {
$doprod = 0;
$doprodid = 0;
$edid = 0;
if ($value['p_lid'] === null) {
if ($result[$value['p_id']] === null) {
$doprod = -1;
$doprodid = 1;
} else {
$edid = (int) $result[$value['p_id']];
if ($edid > 0) {
$doprodid = 2;
$doprod = $edid;
} else {
$doprod = -1;
$doprodid = 1;
}
}
} else {
if ($result[$value['p_id']] === null) {
$doprod = $value['p_lid'];
} else {
$edid = $result[$value['p_id']];
if ($edid > 0) {
$doprodid = 3;
$doprod = $edid;
} else {
$doprod = -1;
$doprodid = 4;
}
}
}
$grid = 0;
if ($doprod < 0) {
if ($typic != 2) {
if ($value['g_lid'] === null) {
if ($typic == 0) {
$prodid = ProductgroupId::model()->findByPk(array('ckey' => $value['g_key'], 'db' => 1));
} else {
$prodid = CountryId::model()->findByPk(array('ckey' => $value['g_key'], 'db' => 1));
}
if ($prodid === null) {
if ($typic == 0) {
$group = new ProductGroup();
$group->tnam = $value['g_name'];
$group->save();
$grid = $group->ckey;
$groupid = new ProductgroupId();
} else {
$group = new Country();
$group->name = $value['g_name'];
$group->save();
$grid = $group->id;
$groupid = new CountryId();
}
$groupid->ckey = $value['g_key'];
$groupid->db = 1;
$groupid->id = $grid;
$groupid->save();
$i++;
} else {
$grid = $prodid->id;
}
} else {
$grid = $value['g_lid'];
}
} else {
$grid = 1;
}
if ($grid > 0) {
if ($typic == 0) {
$prod = new Product();
$prod->tnam = $value['p_name'];
$prod->cgr = $grid;
$it = TmpXml::model()->find('ctype=:ctype AND ckey=:ckey AND user=:user', array(':ctype' => 10, ':ckey' => $value['p_key'], ':user' => Yii::app()->user->uid));
if ($it) {
$prod->it = (int) $it->cname;
}
$prod->save();
$grid = $prod->ckey;
} else {
if ($typic == 1) {
$prod = new Client();
$prod->name = $value['p_name'];
$prod->country_id = $grid;
$prod->save();
$grid = $prod->id;
$this->updateprop($value['p_key'], $grid);
$this->updatebank($value['p_key'], $grid);
} else {
$prod = new Department();
$prod->name = $value['p_name'];
$prod->save();
$grid = $prod->id;
$this->updatebank($value['p_key'], $grid, 0);
}
}
$j++;
if ($doprodid == 1) {
if ($typic == 0) {
$prodid = new ProductId();
} else {
if ($typic == 1) {
$prodid = new ClientId();
} else {
$prodid = new DepartmentId();
}
}
$prodid->ckey = $value['p_key'];
$prodid->db = 1;
$prodid->id = $grid;
$prodid->save();
} else {
if ($typic == 0) {
$prodid = ProductId::model()->findByPk(array('ckey' => $value['p_key'], 'db' => 1));
} else {
if ($typic == 1) {
$prodid = ClientId::model()->findByPk(array('ckey' => $value['p_key'], 'db' => 1));
} else {
$prodid = DepartmentId::model()->findByPk(array('ckey' => $value['p_key'], 'db' => 1));
}
}
if (!($prodid === null)) {
$prodid->id = $grid;
$prodid->save();
}
}
}
}
if ($doprodid == 2) {
if ($typic == 0) {
$prodid = new ProductId();
} else {
if ($typic == 1) {
$prodid = new ClientId();
} else {
$prodid = new DepartmentId();
}
}
$prodid->ckey = $value['p_key'];
$prodid->db = 1;
$prodid->id = $edid;
$prodid->save();
} else {
if ($doprodid == 3) {
if ($typic == 0) {
$prodid = ProductId::model()->findByPk(array('ckey' => $value['p_key'], 'db' => 1));
} else {
if ($typic == 1) {
$prodid = ClientId::model()->findByPk(array('ckey' => $value['p_key'], 'db' => 1));
} else {
$prodid = DepartmentId::model()->findByPk(array('ckey' => $value['p_key'], 'db' => 1));
}
}
if (!($prodid === null)) {
$prodid->id = $edid;
$prodid->save();
}
}
}
if ($doprod > 0) {
if ($typic == 0) {
$prod = Product::model()->findByPk($doprod);
if (!($prod === null)) {
if ($prod->tnam != $value['p_name']) {
$prod->tnam = $value['p_name'];
$prod->save();
$jj = 0;
}
}
} else {
if ($typic == 1) {
$prod = Client::model()->findByPk($doprod);
if (!($prod === null)) {
if ($prod->name != $value['p_name']) {
$prod->name = $value['p_name'];
$prod->save();
$jj = 0;
}
$this->updateprop($value['p_key'], $prod->id);
$this->updatebank($value['p_key'], $prod->id);
}
} else {
if (!($prop = DepartmentProp::model()->findByPk(array('id' => $doprod, '_key' => 'stop')))) {
$prod = Department::model()->findByPk($doprod);
if (!($prod === null)) {
if ($prod->name != $value['p_name']) {
$prod->name = $value['p_name'];
$prod->save();
$jj = 0;
}
}
$this->updatebank($value['p_key'], $doprod, 0);
}
}
}
}
}
}
if ($typic == 0) {
$info[] = 'Создано новых групп товаров:' . $i;
$info[] = 'Создано новых товаров:' . $j;
$info[] = 'Обновлено товаров:' . $jj;
} else {
if ($typic == 1) {
$info[] = 'Создано новых групп клиентов:' . $i;
$info[] = 'Создано новых клиентов:' . $j;
$info[] = 'Обновлено клиентов:' . $jj;
} else {
$info[] = 'Создано новых фирм:' . $j;
$info[] = 'Обновлено фирм:' . $jj;
}
}
return;
}
