<?php
require_once __DIR__ . '/../vendor/autoload.php';
define("MAINDIR", __DIR__ . '/../');
require_once __DIR__ . '/../config.php';
use GitGis\Whatsapp\Model\Message;
use GitGis\Whatsapp\Model\MessageDAO;
use GitGis\Whatsapp\Model\Group;
use GitGis\Whatsapp\Model\GroupDAO;
use GitGis\Whatsapp\Model\WhatsappDAO;
$groupDao = new GroupDAO();
$group = $groupDao->fetch(1);
$messageDao = new MessageDAO();
for ($cnt = 0; $cnt < 200; $cnt++) {
$message = new Message();
$message->setKind(Message::KIND_TEXT_MSG);
$message->setCtime(time());
$message->setUserId(1);
$message->setData('Test ' . $cnt);
$message->setStime(time());
$message->setGroupId($group->getId());
$message = $messageDao->save($message);
$messageDao->addStatus($message, Message::MESSAGE_STATUS_TO_SEND);
}
public static function getSentPage($page = 0)
{
$app = \Slim\Slim::getInstance();
$limit = 50;
if ($_GET['format'] == 'csv') {
$page = 0;
$limit = 10000;
}
$userDAO = new UserDAO();
$messageDAO = new MessageDAO();
$groupDAO = new GroupDAO();
$groups = $groupDAO->getList();
$groups = $groups['list'];
$formUtils = new FormUtils();
$startTime = $formUtils->toTimestamp($_GET['start_date'] . ' 00:00');
$endTime = $formUtils->toTimestamp($_GET['end_date'] . ' 23:59');
if ($endTime <= 0) {
$endTime = time();
}
if ($startTime <= 0) {
$startTime = $endTime - 7 * 24 * 3600;
}
$app->view->set('start_date', $startTime);
$app->view->set('end_date', $endTime);
$query = $_GET;
$query['start_date'] = $startTime;
$query['end_date'] = $endTime;
if (!$userDAO->hasRole('ADMIN')) {
$strong = \Strong\Strong::getInstance();
$user = $strong->getUser();
$query['user_id'] = $user['id'];
}
$pager = new Pager(MAINURL . '/reports/sent/?' . http_build_query($_GET), $limit);
$pager->setPage($page);
$query = $pager->getQueryArray($query);
$list = $messageDAO->getList($query);
$pager->setCount(count($list['list']));
if (isset($list['total'])) {
$pager->setTotal($list['total']);
}
$reportTable = array();
foreach ($list['list'] as $message) {
$statuses = $messageDAO->getStatuses($message);
foreach ($statuses as $status) {
if (empty($status['target'])) {
continue;
}
$key = $status['message_id'];
if (!empty($reportTable[$key])) {
$reportRow = $reportTable[$key];
} else {
$reportRow = array();
$group = $groups[$message->getGroupId()];
$reportRow['group'] = $group->getNickname();
$reportRow['groupCnt'] = count($groupDAO->getNumbers($group->getId()));
$reportRow['ctime'] = $message->getCtime();
$reportRow['msg'] = $message->getData();
$reportRow['targets'] = array();
$reportRow['sent'] = array();
$reportRow['recv'] = array();
$reportRow['error'] = 0;
$reportRow['status'] = 0;
}
$reportRow['targets'] = $message->getTarget();
switch ($status['status']) {
case Message::MESSAGE_STATUS_ERROR:
$reportRow['status'] = 'ERR';
break;
case Message::MESSAGE_STATUS_RECEIVED_BY_SERVER:
case Message::MESSAGE_STATUS_RECEIVED_BY_PHONE:
$reportRow['status'] = 'RECV';
$reportRow['recv'][$status['target']] = 1;
break;
case Message::MESSAGE_STATUS_SENT:
$reportRow['status'] = 'SENT';
$reportRow['sent'][$status['target']] = 1;
if ($reportRow['sent_time'] < $status['mtime']) {
$reportRow['sent_time'] = $status['mtime'];
}
break;
}
$reportTable[$key] = $reportRow;
}
}
foreach ($reportTable as $k => $v) {
$v['sentCnt'] = count($v['sent']);
$v['recvCnt'] = count($v['recv']);
$reportTable[$k] = $v;
}
$app->view->set('menu', 'reports');
$app->view->set('reportTable', array_values($reportTable));
$app->view->set('query', $query);
$app->view->set('pager', $pager);
if ($_GET['format'] == 'csv') {
header("Content-type: text/csv");
header("Content-disposition: attachment; filename=sent.csv");
$app->render('reports/sent.twig.csv');
} else {
$app->render('reports/sent.twig.html');
}
}
/**
* Creates video message and redirects to edit
*/
public static function getSendVideo()
{
$app = \Slim\Slim::getInstance();
$dao = new MessageDAO();
$item = new Message();
$item->setKind(Message::KIND_VIDEO_MSG);
$item->setCtime(time());
$strong = \Strong\Strong::getInstance();
$user = $strong->getUser();
$item->setUserId($user['id']);
$item = $dao->save($item);
$app->redirect(MAINURL . '/messages/edit/' . $item->getId());
}
{
$retVal = '';
for ($i = 0; $i < strlen($str); $i++) {
$retVal .= sprintf("%02X ", ord($str[$i]));
}
return $retVal;
}
function logToCronFile($msg)
{
echo date("Y-m-d H:i:s") . ' ' . time() . " " . $msg . "\n";
file_put_contents(__DIR__ . '/logs/whatsapp.' . date('Ymd') . '.log', date("Y-m-d H:i:s") . " " . $msg . "\n", FILE_APPEND | LOCK_EX);
}
ob_start();
$senderDAO = new SenderDAO();
$groupDAO = new GroupDAO();
$messageDAO = new MessageDAO();
$senders = $senderDAO->getList();
foreach ($senders['list'] as $sender) {
if ('' == $sender->getPassword()) {
logToCronFile("No password for sender: " . $sender->getUsername());
continue;
}
$sender = $senderDAO->fetch($sender->getId());
if (($sender->getFlags() & \GitGis\Whatsapp\Model\Sender::FLAG_UNSYNC) > 0) {
logToCronFile("Syncing " . $sender->getUsername());
$groups = $groupDAO->getList(array('user_id' => $sender->getUserId()));
$contacts = array();
foreach ($groups['list'] as $groupId => $group) {
$groupDAO->clearSynced($groupId);
$groupNumbers = $groupDAO->getNumbers($groupId);
foreach (array_keys($groupNumbers) as $number) {
/**
* Send message to WhatsApp, then add statuses to DB
*
* @param Message $message
*/
public function sendMessage(Message $message, Sender $sender)
{
$messageDAO = new MessageDAO();
if ('' == $sender->getPassword()) {
$messageDAO->addStatus($message, Message::MESSAGE_STATUS_ERROR, 'Sender not registered - go sender and use confirm SMS function');
return;
}
$statuses = $messageDAO->getStatuses($message);
$sentOk = array();
foreach ($statuses as $status) {
if (empty($status['target'])) {
continue;
}
switch ($status['status']) {
case Message::MESSAGE_STATUS_SENT:
case Message::MESSAGE_STATUS_RECEIVED_BY_SERVER:
case Message::MESSAGE_STATUS_RECEIVED_BY_PHONE:
$sentOk[$status['target']] = 1;
$messageDAO->setMessageTargetStatus($message, $status['target'], $status['status']);
break;
}
}
echo "Already sent to: " . implode(",", array_keys($sentOk)) . "\n";
$groupDao = new GroupDAO();
$syncedNumbers = $groupDao->getNumbers($message->getGroupId(), true);
try {
$w = $this->getWhatsProt($sender);
if (empty($w)) {
return;
}
$targets = explode(',', $message->getTarget());
$targets = array_combine($targets, $targets);
$statuses = $messageDAO->getStatuses($message);
foreach ($statuses as $status) {
if ($status['status'] == Message::MESSAGE_STATUS_RECEIVED_BY_SERVER) {
unset($targets[$status['target']]);
}
}
$filteredTargets = array();
$notSynced = array();
$allTargets = array();
foreach ($targets as $target) {
if ($target == $sender->getUsername()) {
continue;
}
if (empty($syncedNumbers[$target])) {
$notSynced[$target] = $target;
continue;
}
if (!empty($sentOk[$target])) {
continue;
}
$allTargets[] = $target;
if (count($filteredTargets) <= 48) {
$filteredTargets[] = $target;
}
}
echo "Filtered: " . implode(",", $filteredTargets) . "\n";
echo "Not synced: " . implode(",", array_keys($notSynced)) . "\n";
if (empty($filteredTargets)) {
$messageDAO->addStatus($message, Message::MESSAGE_STATUS_ERROR, "No synced numbers. Sync Group.");
}
$targets = $filteredTargets;
foreach ($allTargets as $target) {
$messageDAO->setMessageTargetStatus($message, $target, 0);
}
$customFields = $messageDAO->getCustomFields($message);
$this->currentMessage = $message;
$this->currentTargets = $targets;
switch ($message->getKind()) {
case Message::KIND_TEXT_MSG:
$data = $message->getData();
if (false && strpos($data, '$field') === false) {
$w->cleanDebug();
$this->lastSentMessageId = 0;
sleep(strlen($data) / 4);
$w->sendBroadcastMessage($targets, $data);
$whatsapp_id = $this->lastSentMessageId;
$debugMsgReceiver = $w->getDebugBuf();
$this->printDebug($w->getDebugBuf());
if (!$whatsapp_id) {
$messageDAO->addStatus($message, Message::MESSAGE_STATUS_ERROR, $debugMsgReceiver);
break;
}
} else {
foreach ($filteredTargets as $target) {
$sendRetVal = null;
$data = $message->getData();
if (!empty($customFields[$target])) {
for ($i = 1; $i < 6; $i++) {
$data = str_replace('$field' . $i, $customFields[$target]['field' . $i], $data);
}
}
$w->cleanDebug();
$this->lastSentMessageId = 0;
$w->sendMessageComposing($target);
sleep(strlen($data) / 4);
$w->sendMessage($target, $data);
$whatsapp_id = $this->lastSentMessageId;
$debugMsgReceiver = $w->getDebugBuf();
$this->printDebug($w->getDebugBuf());
if (!$whatsapp_id) {
$messageDAO->addStatus($message, Message::MESSAGE_STATUS_ERROR, $debugMsgReceiver);
continue;
}
}
}
break;
case Message::KIND_PHOTO_MSG:
if (false) {
$w->cleanDebug();
$this->lastSentMessageId = 0;
sleep(8);
$w->sendBroadcastImage($targets, WEBDIR . '/uploads/' . $message->getData(), false);
$whatsapp_id = $this->lastSentMessageId;
$debugMsgReceiver = $w->getDebugBuf();
$this->printDebug($w->getDebugBuf());
if (!$whatsapp_id) {
$messageDAO->addStatus($message, Message::MESSAGE_STATUS_ERROR, $debugMsgReceiver);
break;
}
} else {
foreach ($filteredTargets as $target) {
$sendRetVal = null;
$w->cleanDebug();
$this->lastSentMessageId = 0;
sleep(4);
$w->sendMessageImage($target, WEBDIR . '/uploads/' . $message->getData(), false);
$whatsapp_id = $this->lastSentMessageId;
$debugMsgReceiver = $w->getDebugBuf();
$this->printDebug($w->getDebugBuf());
if (!$whatsapp_id) {
$messageDAO->addStatus($message, Message::MESSAGE_STATUS_ERROR, $debugMsgReceiver);
continue;
}
}
}
break;
case Message::KIND_AUDIO_MSG:
if (false) {
$w->cleanDebug();
$this->lastSentMessageId = 0;
sleep(8);
$w->sendBroadcastAudio($targets, WEBDIR . '/uploads/' . $message->getData(), false);
$whatsapp_id = $this->lastSentMessageId;
$debugMsgReceiver = $w->getDebugBuf();
$this->printDebug($w->getDebugBuf());
if (!$whatsapp_id) {
$messageDAO->addStatus($message, Message::MESSAGE_STATUS_ERROR, $debugMsgReceiver);
break;
}
} else {
foreach ($filteredTargets as $target) {
$sendRetVal = null;
$w->cleanDebug();
$this->lastSentMessageId = 0;
sleep(4);
$w->sendMessageAudio($target, WEBDIR . '/uploads/' . $message->getData(), false);
$whatsapp_id = $this->lastSentMessageId;
$debugMsgReceiver = $w->getDebugBuf();
$this->printDebug($w->getDebugBuf());
if (!$whatsapp_id) {
$messageDAO->addStatus($message, Message::MESSAGE_STATUS_ERROR, $debugMsgReceiver);
continue;
}
}
}
break;
case Message::KIND_VIDEO_MSG:
if (false) {
$w->cleanDebug();
$this->lastSentMessageId = 0;
sleep(8);
$w->sendBroadcastVideo($targets, WEBDIR . '/uploads/' . $message->getData(), false);
$whatsapp_id = $this->lastSentMessageId;
$debugMsgReceiver = $w->getDebugBuf();
$this->printDebug($w->getDebugBuf());
if (!$whatsapp_id) {
$messageDAO->addStatus($message, Message::MESSAGE_STATUS_ERROR, $debugMsgReceiver);
break;
}
} else {
foreach ($filteredTargets as $target) {
$sendRetVal = null;
$w->cleanDebug();
$this->lastSentMessageId = 0;
sleep(4);
$w->sendMessageVideo($target, WEBDIR . '/uploads/' . $message->getData(), false);
$whatsapp_id = $this->lastSentMessageId;
$debugMsgReceiver = $w->getDebugBuf();
$this->printDebug($w->getDebugBuf());
if (!$whatsapp_id) {
$messageDAO->addStatus($message, Message::MESSAGE_STATUS_ERROR, $debugMsgReceiver);
continue;
}
}
}
break;
}
$messageDAO->setMessageTargetStatus($message, $status['target'], Message::MESSAGE_STATUS_SENT);
} catch (\Exception $ex) {
$this->printDebug($w->getDebugBuf());
$messageDAO->addStatus($message, Message::MESSAGE_STATUS_ERROR, $ex->getMessage());
}
$this->currentTargets = null;
$this->currentMessage = null;
}
