function import_csv($csv)
{
$error_mess = array();
$update = 0;
$create = 0;
$error = 0;
while ($tab = $csv->readLine()) {
$parentOk = false;
if ($tab['Parent'] !== NULL) {
$parent = \Pasteque\providersService::getByName($tab['Parent']);
$image = NULL;
if ($parent) {
$parentOk = true;
$tab['Parent'] = $parent->id;
}
} else {
// provider isn't subprovider
$parentOk = true;
}
if ($parentOk) {
$prov = new \Pasteque\provider($tab['Parent'], $tab['Designation'], $image, $tab['Ordre']);
$provider_exist = \Pasteque\providersService::getByName($prov->label);
//UPDATE provider
if ($provider_exist) {
$prov->id = $provider_exist->id;
if (\Pasteque\providersService::updateprov($prov)) {
$update++;
} else {
$error++;
$error_mess[] = \i18n("On line %d: Cannot update provider: '%s'", PLUGIN_NAME, $csv->getCurrentLineNumber(), $tab['Designation']);
}
//CREATE provider
} else {
$id = \Pasteque\providersService::createprov($prov);
if ($id) {
$create++;
} else {
$error++;
$error_mess[] = \i18n("On line %d: Cannot create provider: '%s'", PLUGIN_NAME, $csv->getCurrentLineNumber(), $tab['Designation']);
}
}
} else {
$error++;
$error_mess[] = \i18n("On line %d: provider parent doesn't exist", PLUGIN_NAME, $csv->getCurrentLineNumber());
}
}
$message = \i18n("%d line(s) inserted, %d line(s) modified, %d error(s)", PLUGIN_NAME, $create, $update, $error);
$csv->close();
\Pasteque\tpl_msg_box($message, $error_mess);
}
$dispOrder = 0;
if ($_POST['dispOrder'] !== "") {
$dispOrder = intval($_POST['dispOrder']);
}
$prov = new \Pasteque\Provider($_POST['label'], $img !== null, $_POST['firstName'], $_POST['lastName'], $_POST['email'], $_POST['phone1'], $_POST['phone2'], $_POST['website'], $_POST['fax'], $_POST['addr1'], $_POST['addr2'], $_POST['zipCode'], $_POST['city'], $_POST['region'], $_POST['country'], $_POST['notes'], $_POST['visible'], $dispOrder);
$id = \Pasteque\providersService::createprov($prov, $img);
if ($id !== FALSE) {
$message = \i18n("provider saved. <a href=\"%s\">Go to the provider page</a>.", PLUGIN_NAME, \Pasteque\get_module_url_action(PLUGIN_NAME, 'provider_edit', array('id' => $id)));
} else {
$error = \i18n("Unable to save changes");
}
}
}
$provider = NULL;
if (isset($_GET['id'])) {
$provider = \Pasteque\providersService::get($_GET['id']);
}
?>
<h1><?php
\pi18n("Edit a provider", PLUGIN_NAME);
?>
</h1>
<?php
\Pasteque\tpl_msg_box($message, $error);
?>
<form class="edit" action="<?php
echo \Pasteque\get_current_url();
?>
" method="post" enctype="multipart/form-data">
// You should have received a copy of the GNU General Public License
// along with Pastèque. If not, see <http://www.gnu.org/licenses/>.
// providers action
namespace ProductProviders;
$message = NULL;
$error = NULL;
if (isset($_POST['delete-prov'])) {
if (\Pasteque\providersService::deleteprov($_POST['delete-prov'])) {
$message = \i18n("Changes saved");
} else {
$error = \i18n("Unable to save changes");
$error .= " " . \i18n("Only empty provider can be deleted", PLUGIN_NAME);
}
}
$providers = \Pasteque\providersService::getAll();
?>
<h1><?php
\pi18n("Providers", PLUGIN_NAME);
?>
</h1>
<?php
\Pasteque\tpl_msg_box($message, $error);
?>
<?php
\Pasteque\tpl_btn('btn', \Pasteque\get_module_url_action(PLUGIN_NAME, "provider_edit"), \i18n('Add a provider', PLUGIN_NAME), 'img/btn_add.png');
\Pasteque\tpl_btn('btn', \Pasteque\get_module_url_action(PLUGIN_NAME, "providersManagement"), \i18n('Import providers', PLUGIN_NAME), 'img/btn_add.png');
?>
