SELECT
   COUNT (SM_ID) TOTAL_MT,
   SUM ((case when SM_STATUS= 1 then 1 else 0 end)) TOTAL_EXITO_MT_VAS
FROM VAS.SMS_DATA_SMC R1
WHERE SUBMISSION_TIME >= TO_DATE ('16/12/2018 00:00:00', 'dd/mm/yyyy HH24:MI:SS')
    AND SUBMISSION_TIME <= TO_DATE ('16/12/2018 23:59:59', 'dd/mm/yyyy HH24:MI:SS')
    AND MT_MSC_ADDR IS NOT NULL
    AND MT_MSC_ADDR NOT LIKE '569%'
    AND MT_MSC_ADDR <> '0'
    AND FINAL_TIME IS NOT NULL

PHP_FUNCTION(array_sum)
{
	zval *input,
		 *entry,
		 entry_n;

	ZEND_PARSE_PARAMETERS_START(1, 1)
		Z_PARAM_ARRAY(input)
	ZEND_PARSE_PARAMETERS_END();

	ZVAL_LONG(return_value, 0);

	ZEND_HASH_FOREACH_VAL(Z_ARRVAL_P(input), entry) {
		if (Z_TYPE_P(entry) == IS_ARRAY || Z_TYPE_P(entry) == IS_OBJECT) {
			continue;
		}
		ZVAL_COPY(&entry_n, entry);
		convert_scalar_to_number(&entry_n);
		fast_add_function(return_value, return_value, &entry_n);
	} ZEND_HASH_FOREACH_END();
}

SELECT
   COUNT (SM_ID) TOTAL_MT,
   SUM ((case when SM_STATUS= 1 then 1 else 0 end)) TOTAL_EXITO_MT_VAS,
   ROUND (( (TOTAL_EXITO_MT_VAS / TOTAL_MT) * 100),2) TASA_MT
FROM VAS.SMS_DATA_SMC R1
WHERE SUBMISSION_TIME >= TO_DATE ('16/12/2018 00:00:00', 'dd/mm/yyyy HH24:MI:SS')
    AND SUBMISSION_TIME <= TO_DATE ('16/12/2018 23:59:59', 'dd/mm/yyyy HH24:MI:SS')
    AND MT_MSC_ADDR IS NOT NULL
    AND MT_MSC_ADDR NOT LIKE '569%'
    AND MT_MSC_ADDR <> '0'
    AND FINAL_TIME IS NOT NULL

$arr = array(

  "I4" => 7 ,  "I3" => 7 ,
  "I2" => 7 ,  "I1" => 8 ,

  "B4" => 8 ,  "B3" => 8 ,
  "B2" => 8 ,  "B1" => 9 ,

  "S4" => 10 ,     "S3" => 10 ,
  "S2" => 10.50 ,  "S1" => 12 ,

  "G4" => 15 ,  "G3" => 15.50 ,
  "G2" => 16 ,  "G1" => 17 ,

  "P4" => 27 ,  "P3" => 28 ,
  "P2" => 30 ,  "P1" => 35 ,

  "D4" => 70 ,   "D3" => 80 ,
  "D2" => 120 ,  "D1" => 180

);