コード例 #1
0
ファイル: Save.php プロジェクト: sysraj86/carnivalcrm
    $check_notify = FALSE;
}
foreach ($focus->column_fields as $field) {
    if (isset($_POST[$field])) {
        $value = $_POST[$field];
        $focus->{$field} = $value;
    }
}
foreach ($focus->additional_column_fields as $field) {
    if (isset($_POST[$field])) {
        $value = $_POST[$field];
        $focus->{$field} = $value;
    }
}
$focus->name = $mod_strings["LBL_NAME_FIRST"] . ' ' . $focus->transports_tbookings_name;
$focus->save($check_notify);
$return_id = $focus->id;
$deleted_count = 0;
// save to modules TransportBookingsLine
$line = array('id_booking' => $_POST['id_booking'], 'name_booking' => $_POST['name_booking'], 'operating_date' => $_POST['operating_date'], 'unit_price' => $_POST['unit_price'], 'type' => $_POST['type'], 'route' => $_POST['route'], 'deleted' => $_POST['deleted']);
// save contract_values
$transport_bookings_line_count = count($line['id_booking']);
for ($i = 0; $i < $transport_bookings_line_count; $i++) {
    $deleted = $line['deleted'][$deleted_count];
    if (($line['name_booking'][$i] == '' || $line['name_booking'][$i] == '0') && ($line['operating_date'][$i] == '' || $line['operating_date'][$i] == '0') && ($line['unit_price'][$i] == '' || $line['unit_price'][$i] == '0') && ($line['type'][$i] == '' || $line['type'][$i] == '0') && ($line['route'][$i] == '' || $line['route'][$i] == '0')) {
        $deleted = 1;
    }
    $transport_bookings_line = new TransportBookingsLine();
    $transport_bookings_line->id = $line['id_booking'][$i];
    $transport_bookings_line->transportbookings_id = $return_id;
    $transport_bookings_line->name_booking = $line['name_booking'][$i];
コード例 #2
0
 function createTransportBooking($bean, $vanchuyen = '')
 {
     global $db;
     $sql = "\r\n            SELECT \r\n              a.id \r\n            FROM\r\n              `transportbookings` a \r\n              JOIN `transports_portbookings_c` b \r\n                ON a.`id` = b.`transportsc2aeookings_idb` \r\n                AND b.`deleted` = 0 \r\n              JOIN `cars` c \r\n                ON c.`transport_id` = b.`transports6e65nsports_ida` \r\n                AND c.`deleted` = 0 \r\n                AND c.`id` = '{$vanchuyen->vanchuyen_name}' \r\n              JOIN `groupprograportbookings_c` d \r\n                ON d.`groupprogrdcceookings_idb` = a.`id` \r\n                AND d.`groupprogrd5earograms_ida` = '{$bean->id}' \r\n                AND d.`deleted` = 0 \r\n            WHERE a.`deleted` = 0 \r\n            ";
     $TransportBooking = new TransportBookings();
     $result = $db->query($sql);
     while ($row = $db->fetchByAssoc($result)) {
         $TransportBooking->id = $row['id'];
     }
     $TransportBooking->groupprogratbookings_name = $bean->name;
     $TransportBooking->groupprogrd5earograms_ida = $bean->id;
     $sql = "\r\n            SELECT \r\n              a.* \r\n            FROM\r\n              `transports` a \r\n              JOIN cars b \r\n                ON b.`transport_id` = a.`id` \r\n                AND b.`deleted` = 0 \r\n                AND b.`id` = '{$vanchuyen->vanchuyen_name}' \r\n            WHERE a.`deleted` = 0\r\n            ";
     $result = $db->query($sql);
     $row = $db->fetchByAssoc($result);
     $TransportBooking->transports6e65nsports_ida = $row['id'];
     $TransportBooking->transports_tbookings_name = $row['name'];
     $TransportBooking->address = $row['address'];
     $TransportBooking->tel_to = $row['phone'];
     $TransportBooking->confirm = 0;
     $TransportBooking->name = 'Transport Bookings To ' . $row['name'];
     $TransportBooking->assigned_user_name = $bean->assigned_user_name;
     $TransportBooking->assigned_user_id = $bean->assigned_user_id;
     $return = $TransportBooking->save();
     return $return;
 }