Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /** @noinspection SqlInsertValues */
- DB::exec('
- INSERT INTO integration_ftp (
- `customer_id`,
- `supplier_id`,
- `time_interval`,
- `enabled`,
- `host`,
- `username`,
- `password`,
- `products`,
- `varieties`,
- `orders`,
- `local`,
- `created_at`
- ) VALUES (
- :customer_id,
- :supplier_id,
- :time_interval,
- :enabled,
- :host,
- :username,
- :password,
- :products,
- :varieties,
- :orders,
- :local,
- NOW()
- ) ON DUPLICATE KEY UPDATE
- customer_id=:customer_id,
- supplier_id=:supplier_id,
- time_interval=:time_interval,
- enabled=:enabled,
- host=:host,
- username=:username,
- password=:password,
- products=:products,
- varieties=:varieties,
- orders=:orders,
- local=:local;', [
- ':customer_id ' => ($FIC->getClient() instanceof Customer) ? $FIC->getClient()->getId() : null,
- ':supplier_id' => ($FIC->getClient() instanceof Supplier) ? $FIC->getClient()->getId() : null,
- ':time_interval' => $FIC->getInterval(),
- ':enabled' => $FIC->getEnabled(),
- ':host' => $FIC->getHost(),
- ':username' => $FIC->getUsername(),
- ':password' => $FIC->getPassword(),
- ':products' => $FIC->getProductsPath(),
- ':varieties' =>$FIC->getVarietiesPath(),
- ':orders' =>$FIC->getOrdersPath(),
- ':local' =>$FIC->getLocal(),
- ]);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement