/**
 * CreateDropDown
 * @param name -- string (name and id of field)
 * @param data -- data source
 * @param val  -- string (value from data source (field name if data, or "" for array)
 * @param dis  -- string (display value from data source (field name if data, or "" for array)
 * @param args[] -- type (d=data,a=array,m=multi array) Default = d
 * @param args[] -- size (int) Default = 0
 * @param args[] -- default (string) Default = "--Select--"
 * @param args[] -- class (string) Default = "form-control"
 * @param args[] -- group (string)
 * @param args[] -- groupbyfirst (string) //group by first letter
 * @param args[] -- script (string)
 * @param args[] -- datafield (string), used for Attributes
 * @param args[] -- reset (string)
 * @param args[] -- relatedfield (string)
 * @param args[] -- required (bool)
 * */
function CreateDropDown($name="",$data="",$val="",$dis="",$selectedvalue="",$args=[]) {
		
	//handle args
	$type=(!empty($args["type"])) ? $args["type"] : "d";
	$size=(!empty($args["size"])) ? $args["size"] : 0;
	$default=(!empty($args["default"])) ? $args["default"] : "--Select--";
	$hasdefault=(isset($args["hasdefault"])) ? false : true;
	$class=(!empty($args["class"])) ? " class=\"form-control ".$args["class"]."\"" : " class=\"form-control\"";
	$groupBy=(!empty($args["group"])) ? $args["group"] : "";
	$groupByFirst=(!empty($args["groupbyfirst"])) ? $args["groupbyfirst"] : "";
	$script=(!empty($args["script"])) ? $args["script"] : "";
	$dataField=(!empty($args["datafield"])) ? $args["datafield"] : "";
	$relatedField=(!empty($args["relatedfield"])) ? " data-related=\"".$args["relatedfield"]."\"" : "";
	$resetData=(!empty($args["reset"])) ? "" : "kill";
	$required=(!empty($args["required"])) ? " required" : "";
	$readonly=(!empty($args["readonly"])) ? " disabled" : "";
	$multiple=(isset($args["multiple"])) ? " multiple" : "";
	$style=(!empty($args["style"])) ? " style=\"{$args["style"]}\"" : "";

	//rebuild id
	$id=preg_replace("([\[\]]+)","",$name);
		
	$build="<select name=\"$name\" id=\"$id\" size=\"{$size}\"{$class}{$style}{$script}{$relatedField}{$readonly}{$required}{$multiple}><br/>";
		
	if(!empty($default) && $hasdefault) {
		$build.="<option value=\"\">$default</option><br/>";
	}
		
	//check type
	switch($type) {
		case "d":
			$tGroup="";
			while($r=mysqli_fetch_array($data)) {
			
				$whatGroup=(empty($args["groupbyfirst"])) ? $r["$groupBy"] : strtoupper(substr($r[$dis],0,1));
					
				//group
				if(!empty($groupBy) && empty($groupByFirst)) {
					if($tGroup!=$whatGroup) {
						$build.="<optgroup label=\"".(($whatGroup=="1") ? "Active" : (($whatGroup=="0") ? "Inactive" : $whatGroup))."\">";
					}
				} elseif(empty($groupBy) && !empty($groupByFirst)) {
					if($tGroup!=$whatGroup) {
						$build.="<optgroup label=\"".$whatGroup."\">";
					}
				}
					
				//data attribute
				$dataAttr=($r[$dataField]) ? " data-field=\"".$r[$dataField]."\"" : "";
					
				$sel=($selectedvalue==$r[$val]) ? " selected=\"selected\"" : "";
				$build.="<option value=\"".$r[$val]."\"$sel$dataAttr>";
				$build.=$r[$dis];
				$build.="</option><br/>";
					
				$tGroup=(empty($args["groupbyfirst"])) ? $r["$groupBy"] : strtoupper(substr($r[$dis],0,1));
					
				//group
				if(!empty($groupBy)) {
					if($tGroup!=$whatGroup) {
						$build.="</optgroup>";
					}
				}
					
			}
				
			//do you want to reset the data
			if(!empty($resetData)){
				mysqli_free_result($data);
			} else {
				mysqli_data_seek($data, 0);
			}
			break;
		case "a":
			if(is_array($data)) {
				for($x=0;$x<sizeof($data);$x++) {
					$sel=($data[$x]==$selectedvalue && $selectedvalue!="") ? " selected=\"selected\"" : "";
					$build.="<option value=\"".$data[$x]."\"$sel>".$data[$x]."</option>";
				}
			}
				
			break;
		case "m":
				
			if(is_array($data)) {
				foreach($data as $key=>$value) {
					$sel=($key==$selectedvalue && $selectedvalue!="") ? " selected=\"selected\"" : "";
					$build.="<option value=\"".$key."\"$sel>".$value."</option>";
				}
			}
				
			break;
	}
	$build.="</select>";
	return $build;
}