API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 30th, 2015
148
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.97 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. require_once '/opt/cldp/bin/PHP-scripts/swiftmailer/lib/swift_required.php';
  3.  
  4. //--FUNCTIONS--//
  5. function curlGet($targ)
  6. {
  7. $errmsg = '';
  8.  
  9. //init the connection
  10. $ch = curl_init($targ);
  11. curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  12.  
  13. //execute the request and throw an exception if curl has an error
  14. $result = curl_exec($ch);
  15. if (!$result) {
  16. $errmsg .= "Error running curl_exec GET"; //DEV
  17. //throw new Exception("Error running curl_exec GET", $errorCode);
  18. }
  19.  
  20. //get the info about the transaction
  21. $info = curl_getinfo($ch);
  22. //print_r($info);
  23.  
  24. //if it wasn't a 200 response kill it
  25. if ($info['http_code'] != '200') {
  26. $errmsg .= "cURL http response was ".$info['http_code']." not 200 - ".$result; //DEV
  27. //throw new Exception("cURL http response was not 200", $errorCode);
  28. }
  29.  
  30. curl_close($ch);
  31.  
  32. if ($errmsg) {
  33. echo "PHP Curl error: ".$errmsg."\n";
  34. mail("jon.child@accedo.tv", "PHP Curl error for runpartnerdata ".date("Y-m-d"), $errmsg);
  35. exit;
  36. }
  37.  
  38. return $result;
  39. }
  40.  
  41. function formatEuro($num)
  42. {
  43. //$temp = "&#8364;".number_format($num / 100, 2, ".", ",");
  44. $temp = "$".number_format($num / 100, 2, ".", ",");
  45. return str_pad($temp, 15, " ", STR_PAD_LEFT);
  46. }
  47.  
  48. function sendMail($yesterday, $createdA, $closedA, $to, $headers, $solution_area)
  49. {
  50. $message = '';
  51. //CREATED text output
  52. $createdTxt = '<table>'."\n";
  53. $sum = 0;
  54.  
  55. $cnt = count($createdA);
  56. for ($i = 0; $i < $cnt; $i++) {
  57. $createdTxt .= '<tr><td align="right">'.formatEuro($createdA[$i]['value']).'&nbsp;-&nbsp;</td>';
  58. $createdTxt .= '<td><a href="https://www.pipelinedeals.com/deals/'.$createdA[$i]['deal_id'].'" target="_blank">';
  59. $createdTxt .= $createdA[$i]['deal_name']."</a></td></tr>\n";
  60. $createdTxt .= '<td></td><td>Company: '.$createdA[$i]['company_name']."</td></tr>\n";
  61. $sum += $createdA[$i]['value'];
  62. }
  63. $createdTxt .= '</table>'."\n";
  64.  
  65. $ess = '';
  66. if (count($createdA) != 1) {
  67. $ess = 'S';
  68. }
  69. $createdTxt = "<b>".formatEuro($sum)." - ".count($createdA)." NEW DEAL".$ess."</b><br>\n"."===========================<br>\n".$createdTxt."<br>\n<br>\n";
  70.  
  71.  
  72. //CLOSED text output
  73. $wonTxt = '<table>'."\n";
  74. $lostTxt = '<table>'."\n";
  75. $sumWon = 0;
  76. $sumLost = 0;
  77. $cntWon = 0;
  78. $cntLost = 0;
  79.  
  80. $cnt = count($closedA);
  81. for ($i = 0; $i < $cnt; $i++) {
  82. if ($closedA[$i]['wonlost'] == "Won") {
  83. $wonTxt .= '<tr><td align="right">'.formatEuro($closedA[$i]['value']).'&nbsp;-&nbsp;</td>';
  84. $wonTxt .= '<td><a href="https://www.pipelinedeals.com/deals/'.$closedA[$i]['deal_id'].'" target="_blank">'.$closedA[$i]['deal_name']."</a></td></tr>\n";
  85. $wonTxt .= '<td></td><td>Company: '.$closedA[$i]['company_name']."</td></tr>\n";
  86. $sumWon += $closedA[$i]['value'];
  87. $cntWon++;
  88. } else {
  89. $lostTxt .= '<tr><td align="right">'.formatEuro($closedA[$i]['value']).'&nbsp;-&nbsp;</td>';
  90. $lostTxt .= '<td><a href="https://www.pipelinedeals.com/deals/'.$closedA[$i]['deal_id'].'" target="_blank">'.$closedA[$i]['deal_name']."</a></td></tr>\n";
  91. $lostTxt .= '<td></td><td>Company: '.$closedA[$i]['company_name']."</td></tr>\n";
  92. $sumLost += $closedA[$i]['value'];
  93. $cntLost ++;
  94. }
  95. }
  96. $wonTxt .= '</table>'."\n";
  97. $lostTxt .= '</table>'."\n";
  98.  
  99. $ess = '';
  100. if ($cntWon != 1) {
  101. $ess = 'S';
  102. }
  103. $wonTxt = "<b>".formatEuro($sumWon)." - ".$cntWon." DEAL".$ess." WON</b><br>\n"."===========================<br>\n".$wonTxt."<br>\n<br>\n";
  104.  
  105. $ess = '';
  106. if ($cntLost != 1) {
  107. $ess = 'S';
  108. }
  109. $lostTxt = "<b>".formatEuro($sumLost)." - ".$cntLost." DEAL".$ess." LOST</b><br>\n"."===========================<br>\n".$lostTxt."<br>\n<br>\n";
  110.  
  111.  
  112. //ASSEMBLE MAIL
  113. $headers .= 'MIME-Version: 1.0'."\n";
  114. $headers .= 'Content-Type: text/html; charset="utf-8"'."\n";
  115.  
  116. $message .= '
  117. <html>
  118. <head>
  119. <meta http-equiv="Content-Type" content="text/html;charset=utf-8">
  120. <title></title>
  121. </head>
  122. <body>
  123. '."\n\n";
  124. $message .= $createdTxt.$wonTxt.$lostTxt."\n\n";
  125. $message .= '
  126. </body>
  127. </html>
  128. ';
  129.  
  130.  
  131. //send mail
  132. return mail($to, $solution_area." Activity for ".$yesterday, $message, $headers);
  133. }
  134.  
  135.  
  136. //--VARS--//
  137. $apiUrl = "https://api.pipelinedeals.com/api/v3/";
  138. $apikeyStr = "api_key=pD5Qyxl5M2raKheHYVz";// LB's
  139.  
  140. $muheaders = '';
  141. $tvheaders = '';
  142.  
  143. // info for email at end of process
  144.  
  145. // Multiscreen
  146. //$muto = "JC <jc@cloverleafdigital.com>"; // best for testing, immediately available
  147. //$muto = "Jon Child <jon.child@accedo.tv>";
  148. //$muto = "Fredrik Andersson <fredrik.andersson@accedo.tv>";
  149. $muto = "Oren Cohen <oren.cohen@accedo.tv>";
  150. $muheaders .= "Bcc: Jon Child <jon.child@accedo.tv>" . "\r\n";
  151. //$muheaders .= "Cc: Markus Hejdenberg <markus.hejdenberg@accedo.tv>, Bleuenn Le Goffic <bleuenn.legoffic@accedo.tv>" . "\r\n";
  152. //$muheaders .= "Cc: Kristina Frantz <kristina.frantz@accedo.tv>" . "\r\n";
  153. //$muheaders .= "From: JC <jc@cloverleafdigital.com>" . "\r\n";
  154. $muheaders .= "From: Accedo Solutions <daemon@app01.atl.dotdaily.net>" . "\r\n";
  155. //$muheaders .= "Reply-To: JC <jc@cloverleafdigital.com>" . "\r\n";
  156.  
  157. // TV client
  158. //$tvto = "JC <jc@cloverleafdigital.com>"; // best for testing, immediately available
  159. //$tvto = "Jon Child <jon.child@accedo.tv>";
  160. //$tvto = "Lawrence Brickman <lawrence.brickman@accedo.tv>";
  161. $tvto = "Oren Cohen <oren.cohen@accedo.tv>";
  162. $tvheaders .= "Bcc: Jon Child <jon.child@accedo.tv>" . "\r\n";
  163. //$tvheaders .= "Cc: Kristina Frantz <kristina.frantz@accedo.tv>" . "\r\n";
  164. //$tvheaders .= "From: JC <jc@cloverleafdigital.com>" . "\r\n";
  165. $tvheaders .= "From: Accedo Solutions <daemon@app01.atl.dotdaily.net>" . "\r\n";
  166. //$tvheaders .= "Reply-To: JC <jc@cloverleafdigital.com>" . "\r\n";
  167.  
  168.  
  169. $yesterday = date("Y-m-d", strtotime("- 1 day"));
  170. //$yesterday = "2015-07-01"; // 3 solutions created
  171. //$yesterday = "2015-06-24"; // 2 solutions closed
  172. echo $yesterday."\n";
  173.  
  174. $mucreatedA = array();
  175. $tvcreatedA = array();
  176. $muclosedA = array();
  177. $tvclosedA = array();
  178. //$solutionAreasA = array('918601' => 'Multiscreen', '918604' => 'TV client');
  179.  
  180. //GET DEALS CREATED ON DATE
  181. $targ = $apiUrl."deals.json?".$apikeyStr."&conditions[deal_created][from_date]=".$yesterday."&conditions[deal_created][to_date]=".$yesterday;
  182. //echo "NEW DEALS target: ".$targ."\n"; exit;
  183.  
  184. $result = curlGet($targ);
  185.  
  186. $deals = json_decode($result, 1);
  187. //print_r($deals['entries']); exit;
  188.  
  189. $ckPartnerIds = '';
  190. $cnt = count($deals['entries']);
  191. for ($i = 0; $i < $cnt; $i++) {
  192. if (isset($deals['entries'][$i]['custom_fields']['custom_label_1052581'])
  193. && ($deals['entries'][$i]['custom_fields']['custom_label_1052581'] == '918601'
  194. || $deals['entries'][$i]['custom_fields']['custom_label_1052581'] == '918604'))
  195. {
  196. $cid = $deals['entries'][$i]['company_id'];
  197. $cname = $deals['entries'][$i]['company']['name'];
  198. $dname = $deals['entries'][$i]['name'];
  199. $value = $deals['entries'][$i]['value_in_cents'];
  200. $did = $deals['entries'][$i]['id'];
  201. $pushA = array('company_id' => $cid, 'company_name' => $cname, 'deal_name' => $dname, 'value' => $value, 'deal_id' => $did);
  202. if ($deals['entries'][$i]['custom_fields']['custom_label_1052581'] == '918601') {
  203. array_push($mucreatedA, $pushA);
  204. } elseif ($deals['entries'][$i]['custom_fields']['custom_label_1052581'] == '918604') {
  205. array_push($tvcreatedA, $pushA);
  206. }
  207. }
  208. }
  209. //print_r($mucreatedA); echo "XXXXX\n"; print_r($tvcreatedA); echo "YYYYY\n"; exit;
  210.  
  211. //GET CLOSED ON DATE
  212. $targ = $apiUrl."deals.json?".$apikeyStr."&conditions[deal_closed][from_date]=".$yesterday."&conditions[deal_closed][to_date]=".$yesterday;
  213. //echo "CLOSED DEALS target: ".$targ."\n";
  214.  
  215. $result = curlGet($targ);
  216. //echo $result; exit;
  217.  
  218. $deals = json_decode($result, 1);
  219. //print_r($deals['entries']);
  220.  
  221. //$ckPartnerIds = '';
  222. $cnt = count($deals['entries']);
  223. for ($i = 0; $i < $cnt; $i++) {
  224. if (isset($deals['entries'][$i]['custom_fields']['custom_label_1052581'])
  225. && ($deals['entries'][$i]['custom_fields']['custom_label_1052581'] == '918601'
  226. || $deals['entries'][$i]['custom_fields']['custom_label_1052581'] == '918604'))
  227. {
  228. $cid = $deals['entries'][$i]['company_id'];
  229. $cname = $deals['entries'][$i]['company']['name'];
  230. $dname = $deals['entries'][$i]['name'];
  231. $value = $deals['entries'][$i]['value_in_cents'];
  232. $wonlost = $deals['entries'][$i]['deal_stage']['name'];
  233. $did = $deals['entries'][$i]['id'];
  234. $pushA = array('company_id' => $cid, 'company_name' => $cname, 'deal_name' => $dname,
  235. 'value' => $value, 'deal_id' => $did, 'wonlost' => $wonlost);
  236. if ($deals['entries'][$i]['custom_fields']['custom_label_1052581'] == '918601') {
  237. array_push($muclosedA, $pushA);
  238. } elseif ($deals['entries'][$i]['custom_fields']['custom_label_1052581'] == '918604') {
  239. array_push($tvclosedA, $pushA);
  240. }
  241. }
  242. }
  243. //print_r($muclosedA); echo "XXXXX\n"; print_r($tvclosedA); echo "YYYYY\n"; exit;
  244.  
  245. echo "sendMail Multiscreen = ".sendMail ($yesterday, $mucreatedA, $muclosedA, $muto, $muheaders, "Multiscreen"."\n");
  246. echo "sendMail TVC = ".sendMail ($yesterday, $tvcreatedA, $tvclosedA, $tvto, $tvheaders, "TV Client")."\n";
  247. echo $tvto . "\n" . $tvheaders . "\n";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!