*/ $tmp_date = explode("-", $data["date_period_first"]); $tmp_date = date("Y-m-d", mktime(0, 0, 0, $tmp_date[1], $tmp_date[2] - 1, $tmp_date[0])); $sql_obj = new sql_query(); $sql_obj->string = "INSERT INTO services_customers_periods (id_service_customer, date_start, date_end) VALUES ('" . $obj_customer->id_service_customer . "', '" . $data["migration_date_period_usage_first"] . "', '" . $tmp_date . "')"; $sql_obj->execute(); } } else { /* Adjust an existing service "*/ // enable/disable service if needed if ($obj_customer->service_get_status() != $data["active"]) { if ($data["active"]) { // service has been enabled $obj_customer->service_enable(); // generate service period - this won't invoice, but allows us to get a date // for when the invoice will be generated service_periods_generate($obj_customer->id); } else { // service has been disabled $obj_customer->service_disable(); } } // adjust dates if possible - only possible for services that have yet to be billed, any periods that currently // exist are uninvoiced and can be safely deleted. if ($data["date_period_first"]) { log_write("notification", "process", "Adjusted service start date to " . time_format_humandate($data["date_period_first"]) . ""); // handle service information $obj_sql = new sql_query(); $obj_sql->string = "UPDATE services_customers SET date_period_first='" . $data["date_period_first"] . "', date_period_next='" . $data["date_period_next"] . "' WHERE id='" . $obj_customer->id_service_customer . "' LIMIT 1";