Ejemplo n.º 1
0
 public function actionPrintTest($id, $uid, $page = 1, $maxItemPerPage = 17)
 {
     $this->layout = 'printout';
     $model = $this->findModel($id);
     $dest = [];
     $locDest = null;
     $user = \app\models\ResUsers::findOne($uid);
     // var_dump(count($model->stockMoves));
     $renderTo = 'print';
     if ($model->type == 'in') {
     } elseif ($model->type == 'out') {
     } elseif ($model->type == 'internal') {
         $renderTo = 'printDummy';
     } else {
     }
     foreach ($model->stockMoves as $move) {
         if (!isset($dest[$move->location_dest_id])) {
             $dest[$move->location_dest_id] = $move->locationDest->id;
             $locDest = $move->location_dest_id;
         }
     }
     $partner = false;
     if (count($dest) != 1) {
         throw new \yii\web\NotAcceptableHttpException("Something Wrong With data that Your Trying to Access");
     } else {
         $partner = StockLocation::findOne($locDest);
     }
     return $this->render($renderTo, ['model' => $model, 'partner' => $partner, 'page' => $page, 'maxItemPerPage' => $maxItemPerPage, 'user' => $user]);
 }
Ejemplo n.º 2
0
 /**
  * Get All User List for Searching with ajax in select2 widget
  * @param  char $search 	query search
  * @param  integer $id 		id of user
  * @return array         	['user_id'=>'User Profile Name']
  **/
 public function actionSearchUser($search = null, $id = null)
 {
     $out = ['more' => false];
     $q = new Query();
     if (!is_null($search)) {
         $q->select('usr.id, prf.name as text')->from(ResUsers::tableName() . ' as usr')->leftJoin(ResPartner::tableName() . ' prf', 'prf.id=usr.partner_id')->where('LOWER(prf.name) LIKE :search OR LOWER(usr.login) like :search')->addParams([':search' => '%' . strtolower($search) . '%']);
         $users = $q->createCommand()->queryAll();
         $out['results'] = array_values($users);
     } elseif ($id > 0) {
         $out['results'] = ['id' => $id, 'text' => ResUsers::find()->where(['id' => $id])->with('partner')->one()->partner->name];
     } else {
         $out['results'] = ['id' => 0, 'text' => 'No matching records found'];
     }
     echo Json::encode($out);
 }
Ejemplo n.º 3
0
<div class="col-md-12">
	<?php 
/*$data = ResUsers::find()
		->select(['login as value', 'login as label', 'id as id'])
		->asArray()
		->all();
	echo $form->field($model, 'user_id')->widget(\yii\jui\AutoComplete::classname(), [
		'clientOptions' => [
			'source' => $data,
		],
	])->textInput()->label('Group')*/
?>
	<?php 
// $data = ArrayHelper::getColumn(ResUsers::find()->select('login')->distinct()->all(),'login');
echo $form->field($model, 'tag_user')->widget(Select2::classname(), ['name' => 'tag_user', 'data' => ArrayHelper::map(ResUsers::find()->select('login')->distinct()->all(), 'login', 'login'), 'options' => ['placeholder' => 'Cari Sales...', 'class' => 'form-controler', 'multiple' => true]])->label('Sales Man');
?>
</div>

<div class="col-md-12">
	<?php 
/*$data = ResPartner::find()
		->select(['display_name as value', 'display_name as label', 'id as id'])
		->asArray()
		->all();
	echo $form->field($model, 'partner_id')->widget(\yii\jui\AutoComplete::classname(), [
		'clientOptions' => [
			'source' => $data,
		],
	])->textInput()->label('Costumer') */
?>
Ejemplo n.º 4
0
 /**
  * [getCustomerActivityCompositionByCustomer description]
  * @param  integer $partner_id [description]
  * @param  string $type       [description]
  * @return array             [description]
  */
 private function getCustomerActivityCompositionByCustomer($partner_id, $type = 'pie')
 {
     $plan = SalesActivityPlan::find();
     $plan->select('res_partner.name, count(sales_activity_plan.user_id) as cout')->leftJoin(ResUsers::tableName(), 'res_users.id=sales_activity_plan.user_id')->leftJoin(ResPartner::tableName(), 'res_partner.id=res_users.partner_id')->where('sales_activity_plan.actual_partner_id = :actual_partner_id')->addParams([':actual_partner_id' => $partner_id])->groupBy(['res_partner.name']);
     $series = [];
     foreach ($plan->createCommand()->queryAll() as $idx => $act) {
         $series[$idx] = ['name' => $act['name'], 'y' => floatval($act['cout'])];
     }
     return $series;
 }
Ejemplo n.º 5
0
 public function actionGetAllCreatorList($search, $id = null)
 {
     $out = ['more' => false];
     $q = new \yii\db\Query();
     if (!is_null($search)) {
         // $soCreator = array_values(\yii\helpers\ArrayHelper::map(SaleOrder::find()->distinct()->select('create_uid')->asArray()->all(),'create_uid','create_uid'));
         // var_dump($soCreator);
         $users = ResUsers::find()->select('id, login as text')->where('lower(login) like :loginSearch')->addParams([':loginSearch' => '%' . $search['term'] . '%']);
         // var_dump($users->createCommand()->queryAll());
         $out['results'] = array_values($users->createCommand()->queryAll());
     } elseif ($id > 0) {
         $out['results'] = ['id' => $id, 'text' => ResUsers::find()->where(['id' => $id])->with('partner')->one()->partner->name];
     } else {
         $out['results'] = ['id' => 0, 'text' => 'No matching records found'];
     }
     echo \yii\helpers\Json::encode($out);
 }