コード例 #1
0
ファイル: do_batch_action.php プロジェクト: fbone/mediboard4
     if (!$ds->query($query)) {
         CAppUI::setMsg("Erreur lors de la remise à zéro des champs booléens (" . $ds->error() . ")", UI_MSG_WARNING);
     } else {
         CAppUI::setMsg($ds->affectedRows() . " champs mis à jour", UI_MSG_OK);
     }
     $query = "\r\n    UPDATE `ex_concept`\r\n    SET\r\n    `prop` = REPLACE(`prop`, ' default|0', ''),\r\n    `prop` = REPLACE(`prop`, ' default|1', ''),\r\n    `prop` = REPLACE(`prop`, ' default|', '')\r\n    WHERE `prop` LIKE 'bool %';";
     if (!$ds->query($query)) {
         CAppUI::setMsg("Erreur lors de la remise à zéro des concepts booléens (" . $ds->error() . ")", UI_MSG_WARNING);
     } else {
         CAppUI::setMsg($ds->affectedRows() . " concepts mis à jour", UI_MSG_OK);
     }
     break;
 case "str_to_text":
     $where = array("prop" => "LIKE 'str%'");
     $concept = new CExConcept();
     $str_concepts = $concept->loadList($where);
     foreach ($str_concepts as $_concept) {
         $_concept->prop = preg_replace("/^(str)/", "text", $_concept->prop);
         if ($msg = $_concept->store()) {
             CAppUI::setMsg($msg, UI_MSG_WARNING);
         } else {
             CAppUI::setMsg("Concept modifié", UI_MSG_OK);
         }
     }
     if (count($str_concepts) == 0) {
         CAppUI::setMsg("Aucun concept modifié", UI_MSG_OK);
     }
     $ex_field = new CExClassField();
     $str_fields = $ex_field->loadList($where);
     foreach ($str_fields as $_field) {
         $_field->prop = preg_replace("/^(str)/", "text", $_field->prop);