<?php

if ($model_info->customStatus == 0) {
	echo "this model does not allow custom content!";
} else {

	if (isset($model_info->model_id) && isset($_POST['category']) && isset($_POST['duration']) && isset($_POST['delivery_time']) && isset($_POST['description'])) {
		$postcategory = $_POST['category'];
		$postduration = $_POST['duration'];
		$postdelivery_time = $_POST['delivery_time'];
		$postdescription = $_POST['description'];
		
		if (empty($_POST['category'])) {
			$msgSystem = msgSystem("Category was not filled out.", "error");
		}

		if (empty($_POST['duration'])) {
			$msgSystem = msgSystem("Duration was not filled out.", "error");
		}

		if (empty($_POST['delivery_time'])) {
			$msgSystem = msgSystem("Delivery Time was not filled out.", "error");
		}

		if (empty($_POST['description'])) {
			$msgSystem = msgSystem("Description was not filled out.", "error");
		}

		if (!empty($_POST['category']) && !empty($_POST['duration']) && !empty($_POST['delivery_time']) && !empty($_POST['description'])) {

			if (isset($member_id) && $member_id > 0) {
				include_once ('functions_cart.php');
				
				$category = mysql_real_escape_string($_POST['category']);
				$duration = mysql_real_escape_string($_POST['duration']);
				$delivery_time = mysql_real_escape_string($_POST['delivery_time']);
				$description = mysql_real_escape_string($_POST['description']);

				
				$insert = mysql_query("INSERT INTO cms_billing_custom SET
									memberID = '".$member_id."',
									modelID = '".$model_info->model_id."',
									customType = '2',
									categoryID = '".$category."',
									cvpoIDduration = '".$duration."',
									cvpoIDdelivery = '".$delivery_time."',
									description = '".$description."',
									timestamp = '".$timestamp."'") or die(mysql_error());
				
				$customID = mysql_insert_id();
				$customPrice = cartCustomPrice($model_info->model_id,$category,$duration,$delivery_time);
				 /*
				if (mysql_insert_id() > 0) {
					$msgSystem = msgSystem("Thank you, your custom request has been submitted.", "success");
				} else {
					$msgSystem = msgSystem("There was an error submitting your custom request.", "error");
				}
				*/
				$msgSystem = cartAdd($member_id, $model_info->model_id, '3', $customID, $customPrice);
				//cartAdd($memberID, $itemID, $itemType, $itemName, $itemPrice)
			} else {
				$msgSystem = msgSystem("You must be logged in to request a custom video.", "error");
			}
		}
	} else {
		$postcategory = 0;
		$postduration = 0;
		$postdelivery_time = 0;
		$postdescription = "";
	}
?>
	<div style="font-size: 20px; font-weight: bold;">CUSTOM VIDEO CLIPS</div>
	<div style="color: grey;">let me make your fantasy come true</div>
<?php

	echo '<div style="text-align: center; margin-top: 20px;">';

	if (isset($msgSystem)) {
		echo $msgSystem;
	}

	if (isset($member_id) && $member_id > 0) {

// create check if variables exist

		?>
		<span class="brown24px" style="margin-bottom: 20px;">Create a custom video.</span><br />
		<form action="" method="POST" style="text-align: left;">
			<div style="float: left; width: 100px;">Category:</div>
			<div style="float: left; margin-bottom: 15px;"><select name="category" id="customCategory">
				<option value="" selected="selected" data-price="0">- Select -</option>
				<?php

					$categories_sql = mysql_query("SELECT * FROM cms_categories") or die(mysql_error());

					if (mysql_num_rows($categories_sql) > 0) {
						while ($category = mysql_fetch_object($categories_sql)) {

							$model_pricing_info_sql = mysql_query("SELECT * FROM `cms_cvpo_match` WHERE `model_id` = '" . $model_info->model_id . "' AND `category_id` = '" . $category->id . "'") or die(mysql_error());

							if (mysql_num_rows($model_pricing_info_sql) == 1) {
			
								$model_pricing_info = mysql_fetch_object($model_pricing_info_sql);
								if($postcategory == $category->id) { $add = ' selected="selected"'; } else { $add = ''; }
								echo '<option value="' . $category->id . '" data-price="' . $model_pricing_info->price . '"'.$add.'>' . $category->category . '</option>';

							}
						}
					}

				?>
			</select></div>
			<div style="float: left; width: 100px; clear: both;">Duration:</div>
			<div style="float: left; margin-bottom: 15px;"><select name="duration" id="customDuration">
				<option value="" selected="selected" data-price="0">- Select -</option>
				<?php

					$length_sql = mysql_query("SELECT * FROM `cms_custom_video_pricing_options` WHERE `type` = 'length'") or die(mysql_error());

					if (mysql_num_rows($length_sql) > 0) {
						while ($length = mysql_fetch_object($length_sql)) {

							$model_pricing_info_sql = mysql_query("SELECT * FROM `cms_cvpo_match` WHERE `model_id` = '" . $model_info->model_id . "' AND `cvpo_id` = '" . $length->id . "'") or die(mysql_error());

							if (mysql_num_rows($model_pricing_info_sql) == 1) {

								$model_pricing_info = mysql_fetch_object($model_pricing_info_sql);
								if($postduration == $length->id) { $add = ' selected="selected"'; } else { $add = ''; }
								echo '<option value="' . $length->id . '" data-price="' . $model_pricing_info->price . '"'.$add.'>' . $length->cvpo_name . '</option>';

							}
						}
					}

				?>
			</select></div>
			<div style="float: left; width: 100px; clear: both;">Delivery Time:</div>
			<div style="float: left; margin-bottom: 15px;"><select name="delivery_time" id="customDelivery">
				<option value="" selected="selected" data-price="0">- Select -</option>
				<?php

					$delivery_sql = mysql_query("SELECT * FROM `cms_custom_video_pricing_options` WHERE `type` = 'delivery'") or die(mysql_error());

					if (mysql_num_rows($delivery_sql) > 0) {
						while ($delivery = mysql_fetch_object($delivery_sql)) {

							$model_pricing_info_sql = mysql_query("SELECT * FROM `cms_cvpo_match` WHERE `model_id` = '" . $model_info->model_id . "' AND `cvpo_id` = '" . $delivery->id . "'") or die(mysql_error());

							if (mysql_num_rows($model_pricing_info_sql) == 1) {

								$model_pricing_info = mysql_fetch_object($model_pricing_info_sql);
								if($postdelivery_time == $delivery->id) { $add = ' selected="selected"'; } else { $add = ''; }
								echo '<option value="' . $delivery->id . '" data-price="' . $model_pricing_info->price . '"'.$add.'>' . $delivery->cvpo_name . '</option>';

							}
						}
					}

				?>
			</select></div>
			<div style="float: left; width: 100px; clear: both;">Description:</div>
			<div style="float: left; margin-bottom: 15px;"><textarea name="description" cols="70" rows="7"><?php echo $postdescription; ?></textarea></div>
			<div style="clear: both; text-align: center;">
				<div style="font-size: 20px; color: green; font-weight:  bold;">Price: $<span id="customPrice">0</span></div>
				<input type="submit" value="     submit custom     " style="width:170px; background: -webkit-linear-gradient(#dd4462, #cf0c38); background: -o-linear-gradient(#dd4462, #cf0c38); background: -moz-linear-gradient(#dd4462, #cf0c38); background: linear-gradient(#dd4462, #cf0c38); moz-box-shadow: inset 0 0 8px #C690A0; -webkit-box-shadow: inset 0 0 8px #C690A0; box-shadow: inset 0 0 8px #C690A0; border: 1px solid #B2042C; border-radius: 3px 3px 3px 3px; -webkit-border-radius: 3px 3px 3px 3px; margin-top: 6px; height: 35px; padding: 8px; color: white; font-size: 14px; font-weight: bold;">
			</div>
		</form>
		<?php
	} else {
		echo '<a href="join.php">you must be registered to request a custom video.</a>';
	}

	echo '</div>';

}
?>