<?php
$smarty->assign('customer_id', 	$VAR['customer_id']);
$smarty->assign('customer_name', 	$VAR['customer_name']);

if(isset($VAR['submit'])) {

	$q = "INSERT INTO ".PRFX."CUSTOMER_NOTES SET
			CUSTOMER_ID	=". $db->qstr( $VAR['customer_id']	) .",
			DATE			=". $db->qstr(	time() 					) .",
			NOTE			=". $db->qstr( $VAR['memo']				);

	if(!$rs = $db->execute($q)) {
		force_page('core', 'error&error_msg=MySQL Error: '.$db->ErrorMsg().'&menu=1&type=database');
		exit;
	}
	force_page('customer', 'customer_details&page_title='.$VAR['customer_name'].'&customer_id='.$VAR['customer_id']);
} else {

	if($VAR['action'] == 'delete') {
		$q = "DELETE FROM ".PRFX."CUSTOMER_NOTES WHERE ID=".$db->qstr( $VAR['note_id'] );

		if(!$rs = $db->execute($q)) {
			force_page('core', 'error&error_msg=MySQL Error: '.$db->ErrorMsg().'&menu=1&type=database');
			exit;
		}

	force_page('customer', 'customer_details&page_title='.$VAR['customer_name'].'&customer_id='.$VAR['customer_id']);

	} else {

		$smarty->display('customer'.SEP.'memo.tpl');
	}
}
?>