Date format about mab-lab

[Medialoha]

Hello,

I'm not sure you miss something, I will check asap.

[Medialoha]

The rfc is converted before being inserted into db. The value _2013-11-18T17:04:17.000+01:00_ is already converted. I need the original value.

Edit the file report/report.php, line 90, change like this :

    Debug::logi("Seems to be a valid request... Try to decode JSON and save to DB.", 'REPORT');

    $json = json_decode($data, true);

    Debug::Logd($json['USER_CRASH_DATE'], 'CHECK_DATE');

    // open db connection
    DBHelper::open();

    $values = ReportHelper::buildMySQLValuesArr($json);

    Debug::Logd($json['USER_CRASH_DATE'], 'CHECK_DATE');

    $result = DBHelper::insertReport($values);

This will log the user crash date, before and after convertion.

[SirJohn2024]

I've looked at the code and found the problem, it lies here:

public static function buildMySQLValuesArr($json) {
$json['USER_CRASH_DATE'] = self::convertRFCDateToMySQLTimestamp($json['USER_CRASH_DATE']);

$values = array();
    ....

only USER_CRASH_DATE is converted, adding

$json['USER_APP_START_DATE'] = self::convertRFCDateToMySQLTimestamp($json['USER_APP_START_DATE']);

solves the problem, I can now write successfully to DB.

Thanks for your prompt response

Regards
Sergio

[Medialoha]

Thanks !

Script updated.