Comments by nathan666

nathan666 24-Apr-13 3:39am View

so it would be

"<input type="text" name="timeOff" class="DatePicker-needed">|"

and as the loop runs it creats multiple instances of name="timeOff" with class="DatePicker-needed"?

nathan666 24-Apr-13 3:01am View

Below is the jquery initialized

$(function() {
$("#timeOff").datepicker({ dateFormat: "dd/mm/yy", yearRange: 'c:c+10', changeMonth: true, changeYear: true});
$('#timeOff2').each(function(){
$(this).datepicker({ dateFormat: "dd/mm/yy", yearRange: 'c:c+10', changeMonth: true, changeYear: true});
});

and this is where the datepicker instance is created

<input id="timeOff2" class="datepicker"/></input>
}

nathan666 21-May-12 5:01am View

Deleted

sorry the code is below, dont know if this is what you asking
defined('DTC_PATH_ROOT')
|| define('DTC_PATH_ROOT',
realpath(dirname(__FILE__)
. DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR).DIRECTORY_SEPARATOR);

$section = 'site';

require_once DTC_PATH_ROOT . 'lib' . DIRECTORY_SEPARATOR . 'init.php';

nathan666 21-May-12 5:00am View

require_once DTC_PATH_ROOT . 'lib' . DIRECTORY_SEPARATOR . 'init.php';

nathan666 17-Feb-12 4:45am View

It was just a php varaible that was not set

nathan666 17-Feb-12 4:44am View

thanks , sorted this issue out , appreciatte your reply

nathan666 2-Feb-12 2:50am View

public function editDeskdropItem($deskdropId = null){
$app = Wow_Application::getInstance();
$deskdropId = Wow_Utility::getGPValue('deskdropId');
$deskdrop = new Wow_Deskdrop_Model;
$deskdrop->load($deskdropId);
$html = Wow_Deskdrop_View_Admin::listMenu();
$html .= Wow_Deskdrop_View_Admin::deskDropForm($deskdrop);
$app->document->addHtmlToId('content', $html);
}

nathan666 29-Dec-11 7:40am View

Deleted

and now, the returning value comes to this JSON function on the view page

function loadRep(){
$.ajax({
type: "POST",
dataType: "json",
url: '{$ajaxUrl}' + '&act=loadRep',
data: 'storeId={$storeId}',
success: function(data){
$('#representative').replaceWith('<span id="representative">' + data['html'] + '</span>');
}
});
}

nathan666 29-Dec-11 7:39am View

Deleted

the ajax controller function

public function loadRep($dealerId,$userType=null){
$app = Wow_Application::getInstance();
$dealerId = Wow_Utility::getGPValue('storeId');
if($dealerId){
$dealer = new Wow_Dealerstore_Model;
$dealer->load($dealerId);
$rep = $dealer->loadRep($dealerId,$userType);
$output['representative'] = $rep;
$this->document->loadJson(Zend_Json::encode($output));
}
}

nathan666 29-Dec-11 7:38am View

Deleted

ok, here is the function , the model function

public static function loadRep($dealerId,$userType=null){
$app = Wow_Application::getInstance();
$sql = "SELECT firstName,userType FROM users WHERE userType = 'REP' AND dealerStoreId = {$dealerId} AND deleted = 0";
$result = $app->db->fetchAssoc($sql);
return $result;
}

nathan666 23-Dec-11 1:22am View

Deleted

Morning guys , I got pass the error above , however the statement still runs in phpmyadmin , but now its giving me this syntax error in my php page,

Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli prepare error: You have an error in your SQL syntax;

nathan666 22-Dec-11 8:04am View

tried that already , does not run

nathan666 22-Dec-11 8:01am View

const sqlSelect = "
SELECT
s.id,
s.groupId,
s.name,
s.managerId,
s.paymentType,
s.mustHave,
u.userType,
s.deleted
FROM
`dealer_stores` s
INNER JOIN users u
ON s.id = u.dealerStoreId
AND u.userType= 'Rep'";

protected $sqlSelect = self::sqlSelect;

nathan666 22-Dec-11 7:59am View

and that is only when i place it in my php code

nathan666 22-Dec-11 7:58am View

this is the error

Uncaught exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli prepare error: Column 'id' in where clause is ambiguous' in C:\www\htdocs\sony\lib\Zend\Db\Statement\Mysqli.php:77

nathan666 22-Dec-11 7:58am View

if you can solve it could you please send me the code exactly like it should be,im killing myself this side just to make this statement work,lol :)

nathan666 22-Dec-11 7:52am View

its still not working on my side when i paste it in my page

nathan666 22-Dec-11 7:42am View

Deleted

oops sorry man

Comments by nathan666 (Top 18 by date)