function plug_umdico($p, $o)
{
ses('qdvoc', qd('umvoc'));
ses('qdvoc_b', qd('umvoc_arts'));
$ret = udc_build($p);
$ret .= msqlink('', 'ummo_umvoc_1', '') . ' ';
$ret .= lkt('', '/plug/umvoc', picto('link'));
return $ret;
}
function patch_tracks()
{
$qdi = qd('idy');
$qdk = qd('tracks');
//$sql='RENAME TABLE '.$qdi.' TO '.$qdk.';'; msquery($sql);
//$sql='ALTER TABLE '.$qdk.' DROP lu, DROP img, DROP thm;'; msquery($sql);
$sql = 'ALTER TABLE ' . $qdk . ' CHANGE `ib` `i.ib` INT(7) NOT NULL, CHANGE `name` `i.name` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL DEFAULT "", CHANGE `mail` `i.mail` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL DEFAULT "", CHANGE `day` `i.day` INT(10) NOT NULL, CHANGE `nod` `i.nod` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL DEFAULT "", CHANGE `frm` `i.frm` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL DEFAULT "", CHANGE `suj` `i.suj` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL DEFAULT "0", CHANGE `msg` `i.msg` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL, CHANGE `re` `i.re` ENUM("0","1","2","3","4") CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL, CHANGE `lu` `i.lu` INT(7) NOT NULL, CHANGE `img` `i.img` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL DEFAULT "", CHANGE `thm` `i.thm` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL DEFAULT "", CHANGE `host` `i.host` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL DEFAULT "";';
//msquery($sql);
}
function statsee_j($p, $o, $res = '')
{
if (!$p) {
$p = 0;
}
//$r=sql('iq,qb,page,time','qdv','','id>'.$p.' order by id desc');
$r = sql_inner('ip,qb,page,DATE_FORMAT(' . qd('live') . '.time,\'%H:%i:%s\')', 'qdp', 'qdv', 'iq', '', 'where ' . qd('live') . '.id>' . $p . ' order by ' . qd('live') . '.id desc limit 50');
//p($r);
if ($r) {
foreach ($r as $k => $v) {
$ret[] = array($k, $v[3], $v[0], $v[2]);
}
}
return make_table($ret, 'txtx', 'txtx');
}
function plug_umwords($p, $o)
{
$rid = 'plg' . randid();
ses('qdvoc', qd('umvoc'));
ses('qdvoc_b', qd('umvoc_arts'));
$bt = umwords_menu($p, $o, $rid);
return $bt . divd($rid, $ret);
}
function plug_umvoc($p, $o)
{
ses('nl', 1);
ses('umvcnod', 'ummo_umvoc_1');
ses('qdvoc', qd('umvoc'));
ses('qdvoc_b', qd('umvoc_arts'));
$ret = slct_j($p) . ' ';
$ret .= lj('', 'usrch___4', picto('del')) . ' ';
$ret .= input(1, 'usrch', $p, '') . ' ';
$ret .= lj('popsav', 'ucbk_plug___umvoc_ud*search_' . ajx($p) . '__usrch|udsnd', 'chercher') . ' ';
$ret .= checkbox_j('udsnd', 1, 'soundex') . br() . br();
//|chk
$ret .= divd('ucbk', ud_search($p, '1', '')) . br();
$ret .= msqlink('', ses('umvcnod'), '') . ' ';
$ret .= lkt('', '/plug/umvoc', picto('link'));
return $ret;
}
<?php
$agent_call_detail = q("SELECT deal_id, COUNT(id) as total_call FROM `agent_call_dialed` where is_redial='0' AND modified_at>=CURRENT_DATE - INTERVAL 1 DAY GROUP BY deal_id HAVING COUNT(id)<5");
foreach ($agent_call_detail as $each_data) {
$received_call = qs("select * from agent_call_dialed where is_received='1' and deal_id='{$each_data['deal_id']}'");
if (empty($received_call)) {
echo "<br>Yes need to redial for deal: " . $each_data['deal_id'];
qd("deal_sid", "deal_id='{$each_data['deal_id']}'");
if ($each_data['total_call'] == 1) {
echo "<br>Total Count: 1<br>";
$last_updated_record = q("select *,(NOW() - INTERVAL 5 MINUTE) as ccc,NOW() from agent_call_dialed where deal_id='{$each_data['deal_id']}' AND modified_at<=NOW() - INTERVAL 5 MINUTE order by modified_at DESC");
d($last_updated_record);
if (count($last_updated_record) == 0) {
echo "wait to call";
continue;
} else {
echo "dial";
}
} else {
echo "<br>Total Count: " . $each_data['total_call'];
}
$redial_data = qs("select * from agent_call_dialed where deal_id='{$each_data['deal_id']}' order by id ASC");
$phone_value = $redial_data['customer_phone'];
$new_agent_numbers = explode(",", $redial_data['agent_numbers']);
$dealId = $each_data['deal_id'];
$apiCall = new callWebhook();
$apiCall->callNow($phone_value, $new_agent_numbers, $dealId, "0");
echo "<br><br>Call Generated -<br>Agents:";
d($new_agent_numbers);
echo "<br>Customer Phone:";
}
function removeTripSchedulers($tripCode)
{
$removalTables = array("callscheduler", "dispachercallscheduler", "tripconfirmationsummary", "tripconfirmationtexts");
//"manualtextscheduler"
foreach ($removalTables as $eachTable) {
qd($eachTable, " tripCode = '{$tripCode}' ");
}
}
