public function search(array $params)
{
$query = Trip::find();
$query->with('number', 'employee');
$query->orderBy(['numberPossession.from' => SORT_DESC]);
$dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => false]);
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
if (!empty($this->mobileNumber)) {
$numberIds = array_map(function ($item) {
return $item['_id'];
}, Number::find()->select(['_id'])->asArray()->where(['like', 'number', $this->mobileNumber])->all());
$query->andWhere(['in', 'numberId', $numberIds]);
}
if (!empty($this->employeeName)) {
$employeeIds = array_map(function ($item) {
return (int) $item['id'];
}, Employee::findByName($this->employeeName, true)->select('id')->asArray()->all());
$query->andWhere(['in', 'employeeId', $employeeIds]);
}
if ($this->complete === self::INCOMPLETE) {
$query->andWhere(['complete' => false]);
}
if ($this->rentNumberFrom !== $this->rentNumberTo) {
$query->andWhere(['numberPossession.from' => ['$gt' => new MongoDate(strtotime($this->rentNumberFrom)), '$lte' => new MongoDate(strtotime($this->rentNumberTo))]]);
}
$query->andFilterWhere(['like', 'destination', $this->destination]);
return $dataProvider;
}
public function actionNumberList($q = null)
{
$query = Number::find()->select(['number'])->where(['like', 'number', $q])->asArray();
$query->andWhere(['options' => Number::OPTION_TRIP]);
$out = [];
foreach ($query->all() as $item) {
$out[] = ['value' => $item['number']];
}
echo Json::encode($out);
}
public function actionUpdate()
{
foreach (Number::find()->all() as $number) {
$history = [];
foreach ($number->history as $item) {
/** @var Employee $employee */
$employee = Employee::findOne(['id' => $item['ownerId']]);
if (!is_null($employee)) {
$newItem = ['ownerName' => $employee->fullName, 'ownerPost' => $employee->post];
if (isset($item['rentDate'])) {
$newItem['rentDate'] = $item['rentDate'];
}
if (isset($item['returnDate'])) {
$newItem['returnDate'] = $item['returnDate'];
}
$history[] = $newItem;
}
$number->history = $history;
$number->save(false);
}
}
}
/**
* @return array
* @throws \yii\mongodb\Exception
*/
public function getOutsideDb()
{
return array_filter($this->outSideDb, function ($item) {
return !Number::find()->where(['number' => $item['number']])->exists();
});
}
public function export()
{
$dataProvider = new ActiveDataProvider(['pagination' => false]);
$dataProvider->query = Number::find()->with('owner')->where(['destination' => self::DESTINATION_PHONE]);
return $dataProvider;
}
public function init()
{
parent::init();
$this->nowInDb = Number::find()->where(['number' => $this->number])->count() ? true : false;
}
public function actionAll()
{
$numbers = Number::find()->with('owner')->orderBy('number')->all();
return $this->render('all', ['numbers' => $numbers]);
}
