callstatus_2

Скрипты подщитывают кол-во строк, отвечающих требованиям, если таких больше 0, то производится замена!!!

#! /bin/sh

echo "SELECT COUNT(*) FROM vtiger_pbxmanager WHERE callstatus LIKE 'in-progress' AND totalduration > 0;" | mysql -u root -pPaSsWoRd vtiger | grep 0 || echo "UPDATE vtiger_pbxmanager SET callstatus = REPLACE (callstatus, 'in-progress', 'completed') WHERE callstatus LIKE '%in-progress%' COLLATE utf8_general_ci;" | mysql -u root -pPaSsWoRd vtiger

#! /bin/sh

echo "SELECT COUNT(*) FROM vtiger_pbxmanager WHERE callstatus LIKE 'ringing';" | mysql -u root -pPaSsWoRd vtiger | grep 0 || echo "UPDATE vtiger_pbxmanager SET callstatus = REPLACE (callstatus, 'ringing', 'completed') WHERE callstatus LIKE '%ringing%' COLLATE utf8_general_ci;" | mysql -u root -pPaSsWoRd vtiger