Exemplo n.º 1
0
function dev_db_update($table, $data, $where, $ignore_null = 0, &$query_str)
{
    //echo 'updating, ';
    $updates = array();
    $temp_values = array();
    $update_string = '';
    $query_str;
    foreach ($data as $a) {
        array_push($temp_values, dev_prep_input($a));
    }
    $count = 0;
    foreach (array_keys($data) as $a) {
        //convert into query string
        if ($ignore_null == 1) {
            $temp_values[$count] = dev_ignore_null_entry($table, $a, $temp_values[$count], $where);
        }
        array_push($updates, "{$a} = {$temp_values[$count]}");
        $count++;
    }
    $update_string = implode(', ', $updates);
    $query = "UPDATE `{$table}` SET {$update_string} WHERE {$where}";
    //echo "$query<br />";
    $query_str = $query;
    mysql_query($query) ? $status = true : ($status = false);
    return $status;
}
Exemplo n.º 2
0
function dev_draw_form_field($type = '', $name = '', $label = '', $value = '', $required = false, $id = '', $readonly = false, $properties = '')
{
    $output = '';
    $label_text = '';
    $varname = $name;
    $properties = dev_value_to_array($properties);
    if (!isset($properties['class'])) {
        $properties['class'] = $type ? $type : 'formdata';
    }
    foreach ($properties as $a => $b) {
        $attribs[] = "{$a}=\"{$b}\"";
    }
    $attrib = implode(' ', $attribs);
    $id = 'id="' . ($id != '' ? $id : $name) . '"';
    $disabled = $readonly === false ? '' : 'readonly';
    if ($readonly == 3) {
        $type = 'static';
    }
    if ($label != '' && $type != 'static') {
        $label_text = '<label for="' . $name . '">' . ($required ? '*' : '') . $label . ': </label>';
    }
    if ($type != 'date' && $type != 'select') {
        $name .= is_array($value) ? '[]' : '';
    }
    $value = dev_value_to_array($value, true);
    switch ($type) {
        default:
        case 'text':
            foreach ($value as $a) {
                $output .= $label_text . ' <br />' . "\n\t" . '<input type="text" ' . $disabled . ' name="' . $name . '" ' . $id . ' value="' . $a . '" ' . $attrib . ' /><br />';
            }
            break;
        case 'prompt':
            foreach ($value as $a) {
                $output .= $label_text . ' <br />' . "\n\t" . '<input type="text" ' . $disabled . ' name="' . $name . '" ' . $id . ' value="' . $a . '" ' . $attrib . ' onFocus="this.value=\'\'" /><br />';
            }
            break;
        case 'password':
            foreach ($value as $a) {
                $output .= $label_text . ' <br />' . "\n\t" . '<input type="password" ' . $disabled . ' name="' . $name . '" ' . $id . ' value="' . $a . '" ' . $attrib . ' /><br />';
            }
            break;
        case 'textarea':
            foreach ($value as $a) {
                $output .= $label_text . ' <br />' . "\n\t" . '<textarea ' . $disabled . ' name="' . $name . '" ' . $id . ' ' . $attrib . '>' . $a . '</textarea><br />';
            }
            break;
        case 'select':
            $output .= $label_text . ' <br />' . "\n";
            $output .= '<select name="' . $name . '" ' . $disabled . ' ' . $id . ' ' . $attrib . '>' . "\n";
            $value = dev_value_to_array($value);
            global ${$varname};
            foreach ($value as $a => $b) {
                if (is_array($b)) {
                    $output .= "\t" . '<optgroup label="' . $a . '">' . "\n";
                    foreach ($b as $c => $d) {
                        $output .= "\t\t" . '<option value="' . $d . '"';
                        //if the select option being drawn is the same as the
                        //variable by the same name of this element, mark it as selected
                        if (${$varname} == $d) {
                            $output .= ' selected="selected"';
                        }
                        $output .= '>' . $c . '</option>' . "\n";
                    }
                    $output .= "\t" . '</optgroup>' . "\n";
                } else {
                    $output .= "\t" . '<option value="' . $b . '"';
                    //if the select option being drawn is the same as the
                    //variable by the same name of this element, mark it as selected
                    if (${$varname} == $b) {
                        $output .= ' selected="selected"';
                    }
                    $output .= '>' . $a . '</option>' . "\n";
                }
            }
            $output .= '</select><br />';
            break;
        case 'multiple':
            $output .= $label_text . ' <br />' . "\n";
            $output .= '<select name="' . $name . '" ' . $disabled . ' ' . $id . ' ' . $attrib . ' size="6" multiple="multiple">' . "\n";
            $value = dev_value_to_array($value);
            global ${$varname};
            foreach ($value as $a => $b) {
                if (is_array($b)) {
                    $output .= "\t" . '<optgroup label="' . $a . '">' . "\n";
                    foreach ($b as $c => $d) {
                        $output .= "\t\t" . '<option value="' . $d . '"';
                        //if the select option being drawn is the same as the
                        //variable by the same name of this element, mark it as selected
                        if (is_array(${$varname})) {
                            if (in_array($d, ${$varname})) {
                                $output .= ' selected="selected"';
                            } elseif (${$varname} == $d) {
                                $output .= ' selected="selected"';
                            }
                        }
                        $output .= '>' . $c . '</option>' . "\n";
                    }
                    $output .= "\t" . '</optgroup>' . "\n";
                } else {
                    $output .= "\t" . '<option value="' . $b . '"';
                    //if the select option being drawn is the same as the
                    //variable by the same name of this element, mark it as selected
                    if (is_array(${$varname})) {
                        if (in_array($b, ${$varname})) {
                            $output .= ' selected="selected"';
                        } elseif (${$varname} == $b) {
                            $output .= ' selected="selected"';
                        }
                    }
                    $output .= '>' . $a . '</option>' . "\n";
                }
            }
            $output .= '</select><br />';
            break;
        case 'hidden':
            foreach ($value as $a) {
                $output .= '<input type="hidden" ' . $disabled . ' name="' . $name . '" ' . $id . ' value="' . $a . '" />';
            }
            break;
        case 'checkbox':
            if (dev_is_assoc($value)) {
                $output .= ($required ? '*' : '') . $label . '<br />';
                $i = 1;
                foreach ($value as $a => $b) {
                    $output .= '<input ' . $attrib . '  type="checkbox" ' . $disabled . ' name="' . $name . '" ' . substr_replace($id, $i . '"', -1, strlen($id));
                    global ${$varname};
                    if (${$varname} == $b) {
                        $output .= ' checked="checked"';
                    }
                    $output .= ' value="' . $b . '" />';
                    $output .= '<label for="' . $varname . $i . '">' . substr($a, 0, strlen($a)) . " </label><br /> \n";
                    $i++;
                }
            } else {
                foreach ($value as $a) {
                    $output .= '<input type="checkbox" ' . $disabled . ' name="' . $name . '" ' . $id;
                    global ${$varname};
                    if (${$varname} == $a) {
                        $output .= ' checked="checked"';
                    }
                    $output .= ' value="' . $a . '" /> ';
                    $output .= '<label for="' . $varname . '">' . substr($label, 0, strlen($label)) . " </label><br /> \n";
                }
            }
            break;
        case 'radio':
            if (dev_is_assoc($value)) {
                $output .= ($required ? '*' : '') . $label . '<br />';
                $i = 1;
                foreach ($value as $a => $b) {
                    $output .= '<input ' . $attrib . '  type="radio" ' . $disabled . ' name="' . $name . '" ' . substr_replace($id, $i . '"', -1, strlen($id));
                    global ${$varname};
                    if (${$varname} == $b) {
                        $output .= ' checked="checked"';
                    }
                    $output .= ' value="' . $b . '" />';
                    $output .= '<label for="' . $varname . $i . '">' . substr($a, 0, strlen($a)) . " </label><br /> \n";
                    $i++;
                }
            } else {
                foreach ($value as $a) {
                    $output .= '<input type="radio" ' . $disabled . ' name="' . $name . '" ' . $id;
                    global ${$varname};
                    if (${$varname} == $a) {
                        $output .= ' checked="checked"';
                    }
                    $output .= ' value="' . $a . '" /> ';
                    $output .= '<label for="' . $varname . '">' . substr($label, 0, strlen($label)) . " </label><br /> \n";
                }
            }
            break;
        case 'date':
            $output .= dev_draw_date_select($name, $label, $value[0], $readonly);
            break;
        case 'calendar':
            $output .= $label_text . "\n\t" . '<SCRIPT LANGUAGE="JavaScript" ID="js' . $name . '">
	var cal' . $name . ' = new CalendarPopup("datediv1");
	cal' . $name . '.setCssPrefix("DATE");
</SCRIPT>
<SCRIPT LANGUAGE="JavaScript">writeSource("js' . $name . '");</SCRIPT>
<input type="text" ' . $disabled . ' name="' . $name . '" ' . $id . ' value="' . $value[0] . '" ' . $attrib . ' />
<A HREF="#" onclick="cal' . $name . '.select(document.getElementById(\'' . $name . '\'),\'anchor' . $name . '\',\'yyyy-MM-dd\'); return false;" TITLE="cal' . $name . '.select(document.getElementById(\'' . $id . '\'),\'anchor1x\',\'yyyy-MM-dd\'); return false;" NAME="anchor' . $name . '" ID="anchor' . $name . '"><img src="' . $image_path . 'calendar.gif" alt="select" title="select" border="0" /></A><br />';
            break;
        case 'time':
            $output .= dev_draw_time_select($name, $label);
            break;
        case 'file':
            foreach ($value as $a) {
                if (!$readonly && $a == '') {
                    $output .= $label_text . ' - ' . $a . ' <br />' . "\n\t" . '<input type="file" ' . $disabled . ' name="' . $name . '" ' . $id . ' /><br />';
                } else {
                    $output = dev_draw_form_field('checkbox', $name, $label . ' (' . $a . ')', $a, $required, $name, $readonly, $properties);
                }
            }
            break;
        case 'richtext':
            foreach ($value as $a) {
                //Code provided by Kevin Roth at www.kevinroth.com/rte/demo.htm
                //Requires following form header:
                /*
                		<script language="JavaScript" type="text/javascript">
                		<!--
                		function submitForm() {
                			//make sure hidden and iframe values are in sync before submitting form
                			//to sync only 1 rte, use updateRTE(rte)
                			//to sync all rtes, use updateRTEs
                			//updateRTE(\'rte1\');
                			updateRTEs();
                			
                			//change the following line to true to submit form
                			return true;
                		}
                		
                		//Usage: initRTE(imagesPath, includesPath, cssFile, genXHTML)
                		initRTE("images/", "", "", true);
                		//-->
                		</script>
                */
                //and included JS file and 'onsubmit="return submitForm();"' in form.
                $output .= '
		<noscript>';
                $output .= dev_draw_form_field('textarea', $name, $label, $a, '', $id, $readonly);
                $output .= '
		</noscript>
		
		<script language="JavaScript" type="text/javascript">
		<!--
		var ' . $name . '_val = "";
		';
                //$output .= "\n";
                $a = html_entity_decode($a);
                $val_search = array('"', '</script>', '</textarea>', '</noscript>');
                $val_replace = array('\\"', '&lt;/script&gt;', '&lt;/textarea&gt;', '&lt;/noscript&gt;');
                $a = str_replace($val_search, $val_replace, $a);
                $val_array = explode("\n", $a);
                //foreach ($val_array as $a) $output .= $name . '_val += "' . html_entity_decode(rtrim($a)) . '\n";' . "\n";
                foreach ($val_array as $var) {
                    $output .= $name . '_val += "' . rtrim($var) . '\\n";' . "\n";
                }
                $output .= '
		//-->
		</script>
		';
                //$output .= dev_draw_form_field('hidden', $name . '_hidden', '', $a);
                if ($id == 'id="big"') {
                    $w = '100%';
                    $h = 400;
                } else {
                    $w = 450;
                    $h = 200;
                }
                $output .= '
		<script language="JavaScript" type="text/javascript">
		<!--
		' . $name . '_val = ' . $name . '_val.replace(/&lt;\\/script&gt;/gi, "<" + "/script>");
		' . $name . '_val = ' . $name . '_val.replace(/&lt;\\/textarea&gt;/gi, "<" + "/textarea>");
		' . $name . '_val = ' . $name . '_val.replace(/&lt;\\/noscript&gt;/gi, "<" + "/noscript>");
		writeRichText(\'' . $name . '\', ' . $name . '_val, \'' . $w . '\', \'' . $h . '\', true, ' . ($readonly ? 'true' : 'false') . ');
		//-->
		</script>
				';
            }
            break;
        case 'static':
            foreach ($value as $a) {
                $output .= $label . '<br /><span ' . implode(' ', $attribs) . ' name="' . $name . '" ' . $id . '>' . $a . '</span>';
                $output .= dev_draw_form_field('hidden', $name, '', $a);
            }
            break;
        case 'submit':
            foreach ($value as $a) {
                $output .= '<input type="submit" ' . $disabled . ' name="' . $name . '" ' . $id . ' value="' . $a . '" onclick="this.disabled=false;this.value=' . dev_prep_input($label != '' ? $label : 'Submitting...') . ';" ' . $attrib . ' /><br />';
            }
            break;
        case 'reset':
            foreach ($value as $a) {
                $output .= '<input type="reset" ' . $disabled . ' name="' . $name . '" ' . $id . ' value="' . $a . '" ' . $attrib . ' /><br />';
            }
            break;
        case 'button':
            foreach ($value as $a) {
                $output .= '<input type="button" ' . $disabled . ' name="' . $name . '" ' . $id . ' value="' . $a . '" ' . $attrib . ' /><br />';
            }
            break;
    }
    if ($label != '' && $type != 'hidden') {
        $output .= "<br />\n";
    }
    return $output;
}
Exemplo n.º 3
0
 function createWhereCase($table = '', $member, $value = '')
 {
     $table = dev_is_null($table) ? $this->getReferenceTable() : $table;
     $where = '';
     $where_r = array();
     $condition = $this->getCondition($member);
     $condition_str = is_array($condition) ? $condition[0] : $condition;
     if (dev_not_empty($this->getField($member))) {
         //Allow for fulltext searches
         if (strtoupper($condition_str) == 'MATCH') {
             $match_var = $this->getConditionKey($member);
             if (strpos($match_var, ',')) {
                 $match_r = explode(',', $match_var);
                 foreach ($match_r as $c => $d) {
                     $match_r[$c] = "{$table}." . trim($d);
                 }
                 $match_str = implode(', ', $match_r);
             } elseif (array_key_exists($member, $this->_conditional_vars)) {
                 $match_str = "{$table}.{$member}";
             }
             if (is_array($value)) {
                 foreach ($value as $a) {
                     if (dev_not_null($a)) {
                         $where_r[] = "MATCH({$match_str}) AGAINST (" . dev_prep_input($a) . ")";
                     }
                 }
                 $where = implode(' OR ', $where_r);
             } else {
                 $where = "MATCH({$match_str}) AGAINST (" . dev_prep_input($value) . ")";
             }
         } elseif (strtoupper($condition_str) == 'IN') {
             if (is_array($value)) {
                 foreach ($value as $a) {
                     if (dev_not_null($a)) {
                         $where_r[] = $table . ".{$member} " . (array_key_exists($member, $this->_conditional_vars) ? "{$condition} " : "= ") . $a;
                     }
                     $where = implode(' OR ', $where_r);
                 }
             } else {
                 $where = $table . ".{$member} " . (array_key_exists($member, $this->_conditional_vars) ? $condition : " = ") . "( {$value} )";
             }
         } elseif (strtoupper($condition_str) == 'NOT IN') {
             if (is_array($value)) {
                 foreach ($value as $a) {
                     if (dev_not_null($a)) {
                         $where_r[] = $table . ".{$member} " . (array_key_exists($member, $this->_conditional_vars) ? "{$condition} " : "= ") . $a;
                     }
                     $where = implode(' OR ', $where_r);
                 }
             } else {
                 $where = $table . ".{$member} " . (array_key_exists($member, $this->_conditional_vars) ? $condition : " = ") . "( {$value} )";
             }
         } else {
             if (is_array($value)) {
                 $count = 0;
                 foreach ($value as $a) {
                     if (dev_not_null($a)) {
                         $temp_where = '';
                         $temp_where = $table . ".{$member} " . (array_key_exists($member, $this->_conditional_vars) ? is_array($condition) ? $condition[$count] : $condition : " = ");
                         if ($condition_str == 'Like') {
                             $a = "{$a}%";
                         } elseif ($condition_str == 'likE') {
                             $a = "%{$a}";
                         } elseif (strtoupper($condition_str) == 'LIKE') {
                             $a = "%{$a}%";
                         }
                         $temp_where .= dev_prep_input($a);
                         $where_r[] = $temp_where;
                         $count++;
                     }
                 }
                 $where = implode(is_array($condition) ? ' AND ' : ' OR ', $where_r);
             } else {
                 $where = $table . ".{$member} " . (array_key_exists($member, $this->_conditional_vars) ? $condition : " = ");
                 if ($condition_str == 'Like') {
                     $value = "{$value}%";
                 } elseif ($condition_str == 'likE') {
                     $value = "%{$value}";
                 } elseif (strtoupper($condition_str) == 'LIKE') {
                     $value = "%{$value}%";
                 }
                 $where .= dev_prep_input($value);
             }
         }
         //$where_r[] = $where;
         if (dev_not_null($where)) {
             $where = "({$where}) ";
         }
     }
     return $where;
 }