向zendDesk发送ticket

use Yii;use yii\helpers\Json;use yii\console\Controller;use api\User;use api\Company;use api\TrialRequest;use api\UserPermission;define("ZDAPIKEY", "*******");  define("ZDUSER", "service@******.com");  define("ZDURL", "https://******.zendesk.com/api/v2");class ZendeskController extends Controller{public $enableCsrfValidation=false;public static function curlWrap($url, $json, $action)  {  $ch = curl_init();  curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);  curl_setopt($ch, CURLOPT_MAXREDIRS, 10 );  curl_setopt($ch, CURLOPT_URL, ZDURL.$url);  curl_setopt($ch, CURLOPT_USERPWD, ZDUSER."/token:".ZDAPIKEY);  switch($action){  case "POST":  curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");  curl_setopt($ch, CURLOPT_POSTFIELDS, $json);  break;  case "GET":  curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "GET");  break;  case "PUT":  curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "PUT");  curl_setopt($ch, CURLOPT_POSTFIELDS, $json);  break;  case "DELETE":  curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "DELETE");  break;  default:  break;  }curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-type: application/json'));  curl_setopt($ch, CURLOPT_USERAGENT, "MozillaXYZ/1.0");  curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);  curl_setopt($ch, CURLOPT_TIMEOUT, 10);  $output = curl_exec($ch);  curl_close($ch);  //$decoded = json_decode($output);  return $output;  }public function actionConfirmEmail(){//todo 用户注册后5分钟内没有完成email验证$trialRequests=TrialRequest::find()->where(['verified' => 0,])->andWhere(['<','created_at',date('Y-m-d H:i:s',strtotime('-60 minute'))])->all();$subject=count($trialRequests).'个用户注册后1小时内没有完成email验证';$desc='用户信息：';if(count($trialRequests) != 0){foreach($trialRequests as $value){$work_email=$value['work_email'];$phone_number = $value['phone_number'];$company = $value['company'];$created_at = $value['created_at'];$txt = sprintf("\nemail:%s\tphone:%s\tcompany:%s\tcreated_at:%s",$work_email,$phone_number,$company,$created_at);$desc=$desc.$txt;}$arr['new_tick_assignee'] = "******";$arr['new_req_name'] = "iBot";$arr['new_req_email'] = "noreply@*****.com";$arr['new_tick_subj'] = $subject;$arr['new_tick_desc'] = $desc;// CREATE JSON FORMATTED VARIABLE TO PASS AS PARAMETER TO API  $create = json_encode(  array(  'ticket' => array(  'requester' => array(  'name' => $arr['new_req_name'],  'email' => $arr['new_req_email']  ),  'assignee_id' => $arr['new_tick_assignee'],  'subject' => $arr['new_tick_subj'],  'description' => $arr['new_tick_desc']  )  ),  JSON_FORCE_OBJECT  );$data = self::curlWrap("/tickets.json", $create, "POST");if($data == false)  Yii::error("发送未验证email用户信息失败", __METHOD__);//todo add more error message}}public function actionSelectPlan(){//todo 完成email验证的用户，一天内没有选择plan试用$sql = "select * from user_permission where company_id in (select id from zuser.company where work_email in (select work_email from zuser.trial_request where verified=1 )) and (plan_code is null or plan_code='') and created_at < date_add(now(),INTERVAL -1 day)";$userPermissions=UserPermission::findBySql($sql)->all();$subject=count($userPermissions).'个用户1天内没有选择plan试用';$desc='用户信息：';if(count($userPermissions) != 0){foreach($userPermissions as $value){$work_email=$value['email'];$user_id = $value['user_id'];$company_id = $value['company_id'];$phone_number = '';$username = '';$company_name = '';$user = User::findOne(['id' => $user_id]);if($user != null){$phone_number = $user->phone_number;$username = $user->username;}$company = Company::findOne(['id' => $company_id]);if($company != null){$company_name = $company->name;}$txt = sprintf("\nemail:%s\tphone:%s\tusername:%s\tcompany:%s",$work_email,$phone_number,$username,$company_name);$desc=$desc.$txt;}// CREATE AN ARRAY WITH POST DATA AND DESIRED TICKET CONTENT/ATTRIBUTES$arr['new_tick_assignee'] = "*****";    $arr['new_req_name'] = "iBot";$arr['new_req_email'] = "noreply@*****.com";$arr['new_tick_subj'] = $subject;$arr['new_tick_desc'] = $desc;// CREATE JSON FORMATTED VARIABLE TO PASS AS PARAMETER TO API$create = json_encode(array('ticket' => array('requester' => array('name' => $arr['new_req_name'],'email' => $arr['new_req_email']),'assignee_id' => $arr['new_tick_assignee'],'subject' => $arr['new_tick_subj'],'description' => $arr['new_tick_desc'])),JSON_FORCE_OBJECT);$data = self::curlWrap("/tickets.json", $create, "POST");if($data == false)Yii::error("发送未选择试用用户信息失败",__METHOD__);}}public function actionCancelPackage(){//取消套餐$sql = 'select * from user_permission where subscription_status=2 and trial_ended_at >= now()';$userPermissions = UserPermission::findBySql($sql)->all();$subject=count($userPermissions).'个用户取消套餐';$desc='用户信息：';if(count($userPermissions) != 0){foreach($userPermissions as $value){$work_email=$value['email'];$user_id = $value['user_id'];$company_id = $value['company_id'];$phone_number = '';$username = '';$company_name = '';$user = User::findOne(['id' => $user_id]);if($user != null){$phone_number = $user->phone_number;$username = $user->username;}$company = Company::findOne(['id' => $company_id]);if($company != null){$company_name = $company->name;}$txt = sprintf("\nemail:%s\tphone:%s\tusername:%s\tcompany:%s",$work_email,$phone_number,$username,$company_name);$desc=$desc.$txt;}$arr['new_tick_assignee'] = "*****";$arr['new_req_name'] = "iBot";$arr['new_req_email'] = "noreply@*****.com";$arr['new_tick_subj'] = $subject;$arr['new_tick_desc'] = $desc;// CREATE JSON FORMATTED VARIABLE TO PASS AS PARAMETER TO API$create = json_encode(array('ticket' => array('requester' => array('name' => $arr['new_req_name'],'email' => $arr['new_req_email']),'assignee_id' => $arr['new_tick_assignee'],'subject' => $arr['new_tick_subj'],'description' => $arr['new_tick_desc'])),JSON_FORCE_OBJECT);$data = self::curlWrap("/tickets.json", $create, "POST");if($data == false)Yii::error("发送取消套餐用户信息失败",__METHOD__);}}}