<?php
/*
* Script: manage.php
* new manage custom fields page
*
* Authors:
* Nicolas Ruflin
*
* Last edited:
* 2007-07-19
*
* License:
* GPL v2 or above
*
* Website:
* http://www.simpleinvoices.org
*/
if(isset($_POST['save'])) {
saveCustomField($_POST['plugin'],$_POST['categorie'],$_POST['name'],$_POST['description']);
}
ini_set("display_errors","On");
//Note: If input is language specific it has to be in the form: {$LANG['value']} or {$LANG["value"]}
<?php
/*
* Script: manage.php
* new manage custom fields page
*
* Authors:
* Nicolas Ruflin
*
* Last edited:
* 2007-07-19
*
* License:
* GPL v2 or above
*
* Website:
* http://www.simpleinvoices.org
*/
if (isset($_POST['save'])) {
saveCustomField($_POST[plugin], $_POST[categorie], $_POST[name], $_POST[description]);
}
ini_set("display_errors", "On");
//Note: If input is language specific it has to be in the form: {$LANG['value']} or {$LANG["value"]}
function convertCustomFields() {
/* check if any value set -> keeps all data for sure */
global $dbh;
$sql = "SELECT * FROM ".TB_PREFIX."custom_fields";
$sth = $dbh->prepare($sql);
$sth->execute();
while($custom = $sth->fetch()) {
if(preg_match("/(.+)_cf([1-4])/",$custom['cf_custom_field'],$match)) {
//print_r($match);
switch($match[1]) {
case "biller": $cat = 1; break;
case "customer": $cat = 2; break;
case "product": $cat = 3; break;
case "invoice": $cat = 4; break;
default: $case = 0;
}
$cf_field = "custom_field".$match[2];
if($match[1] != "biller") {
$sql = "SELECT id, :field FROM :table";
$tablename = TB_PREFIX.$match[1] . "s";
}
else {
$sql = "SELECT id, :field FROM :table";
$tablename = TB_PREFIX.$match[1];
}
/*
* If custom field name is set
*/
if($custom['cf_custom_label'] != NULL) {
$store = true;
}
//error_log($sql);
$tth = $dbh->prepare($sql);
$tth->bindValue(':table', $tablename);
$tth->bindValue(':field', $cf_field);
$tth->execute();
$store = false;
/*
* If any field is set, create custom field
*/
while($res = $tth->fetch()) {
if($res[1] != NULL) {
$store = true;
break;
}
//echo($res[0]."<br />");
}
if($store) {
print_r($res);
echo "<br />".$sql." ".$res['id'];
//create new text custom field
saveCustomField(3,$cat,$custom['cf_custom_field'],$custom['cf_custom_label']);
$id = lastInsertId();
error_log($id);
$plugin = getPluginById($id);
//insert all data
$uth = $dbh->prepare($sql);
$uth->bindValue(':table', $tablename);
$uth->bindValue(':field', $cf_field);
$uth->execute();
while($res2 = $uth->fetch()) {
$plugin->saveInput($res2[$cf_field], $res2['id']);
}
}
}
}
}
