public function searchDetails($params)
{
$query = UserActivities::find();
$query->select('company_name,monthName,ym,y,sum(aktieve_dagen) as aktieve_dagen,contactperson_id')->groupBy('ym', 'company_name', 'monthName');
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
if (!isset($params['monthName'])) {
$params['monthName'] = '';
}
if (!isset($params['company_id'])) {
$params['company_id'] = '';
}
$query->andFilterWhere(['monthName' => $params['monthName'], 'company_id' => $params['company_id']]);
return $dataProvider;
}
/**
* @param integer $cpid = contactperson_id
* @param integer $a = active_dagen
* @param integer $m = monthName
* @throws NotFoundHttpException if the model cannot be found
* return respons from zoho invoice creating
*/
public function actionInv($cpid, $a, $m)
{
\Yii::$app->response->format = \yii\web\Response::FORMAT_JSON;
$UserInvoiceMdl = UserInvoice::findOne(['user_id' => $cpid]);
$abonnementType = $query = UserActivities::find()->select("aktieve_dagen,full_name, monthName")->where("contactperson_id=" . $cpid . " and monthName =" . $m)->all();
//print_r($query); exit;
return \yii\helpers\Json::encode($query);
exit;
//haal contact persoon op
$curl = new curl\Curl();
$resp = $curl->setOption(CURLOPT_POSTFIELDS, http_build_query(array('')))->GET('https://invoice.zoho.com/api/v3/contacts/' . $UserInvoiceMdl->zoho_contact_id . '?authtoken=90545fa01029567ccd0ad3447cbf843c');
$obj = json_decode($resp);
// echo $obj->contact->primary_contact_id; exit; //638713000000068053
//echo $obj->contact_id; exit;
$curl = new curl\Curl();
$response = $curl->setOption(CURLOPT_POSTFIELDS, http_build_query(array('JSONString' => '{
"customer_id"="638713000000068045",
"template_id"="638713000000025001",
"line_items":[
{"item_id": "",
"name":"Jaar abonnement",
"item_name":"Jaar abonnement",
"status": "active",
"source": "user",
"is_linked_with_zohocrm": false,
"description": "Tarief voor P.adriaanse maand Juli 2015",
"rate": 0.41,
"quantity": 31.0,
"tax_id":"638713000000047019",
"tax_name": "BTW21","tax_percentage": 21
},
{"item_id": "",
"name":"Jaar abonnement",
"item_name":"Jaar abonnement",
"status": "active",
"source": "user",
"is_linked_with_zohocrm": false,
"description": "Tarief voor Arnord Zwagerman Juli 2015",
"rate": 0.41,
"quantity": 28.0,
"tax_id":"638713000000047019",
"tax_name": "BTW21","tax_percentage": 21
}
]
}')))->POST('https://invoice.zoho.com/api/v3/invoices?authtoken=90545fa01029567ccd0ad3447cbf843c');
return $response;
}
