Hjdcti

Multi tool use

Giant Toughroad SLR 2 for 200 miles in two days, will it make it?

Why are all the doors on Ferenginar (the Ferengi home world) far shorter than the average Ferengi?

Teaching indefinite integrals that require special-casing

Is there a problem with hiding "forgot password" until it's needed?

What if somebody invests in my application?

Organic chemistry Iodoform Reaction

Indicating multiple different modes of speech (fantasy language or telepathy)

Is there an wasy way to program in Tikz something like the one in the image?

What will be the temperature on Earth when Sun finishes its main sequence?

Reply ‘no position’ while the job posting is still there (‘HiWi’ position in Germany)

Installing PowerShell on 32-bit Kali OS fails

What to do when my ideas aren't chosen, when I strongly disagree with the chosen solution?

Female=gender counterpart?

Is there a good way to store credentials outside of a password manager?

Visiting the UK as unmarried couple

Simulating a probability of 1 of 2^N with less than N random bits

How can I raise concerns with a new DM about XP splitting?

Lifted its hind leg on or lifted its hind leg towards?

What does the "3am" section means in manpages?

Proving by induction of n. Is this correct until this point?

What will be the benefits of Brexit?

How to prevent YouTube from showing already watched videos?

Could solar power be utilized and substitute coal in the 19th century?

Is exact Kanji stroke length important?

magento 1 query generated back tics are wrongly placed

Product Collection for Default CategoryCreate invoice and shipment in magento via cron based on store view and order ageError report in var/report ,what does it mean? and is it serious problem? It keep create those error report and take 1.7 GB space alreadySubselect as main_table on magento collectionsql to query to Magento queryhow can i add shipping carrier column in admin pageMagento 1.9: How to show instock items first in product listing even after using sortingProblem in creating custom reports for inventory forecastingMagento - Add customer attribute to order gridCan't run CRON PDOException Magento 1.9.3.8

0

I have an issue in Magento 1, where the SQL query that is getting generated has the back tics wrongly placed.

This is a piece of the code that helps to provide the collection to the grid layout.

protected function _prepareCollection()

 $accountId = $this->getRequest()->getParam('id');
 $collection = Mage::getResourceModel('testmodule/coupon_collection');


 if (Mage::helper('testmodulecoupon')->isMultiProgram()
 && Mage::helper('core')->isModuleEnabled('Test_module')
 )
 $collection->getSelect()->joinLeft(
 array('p' => $collection->getTable('testmodule/account')),
 'main_table.program_id = p.program_id AND main_table.account_id = p.account_id',
 array()
 )->joinLeft(
 array('r' => $collection->getTable('testmodule/program')),
 'main_table.program_id = r.program_id',
 array('status' => 'IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))')
 );
 else 
 $collection->addFieldToFilter('program_id', array('eq'=>0));
 
 $collection->addFieldToFilter('main_table.account_id',$accountId); 

 $this->setCollection($collection);
 return parent::_prepareCollection();

In the above code, this part of the line is generating the back tics wrongly.

array('status' => 'IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))') 

This is part of SQL query that is generating.

(`IF (main_table`.`program_id = 0, 1, IF(p`.`id AND r`.`use_coupon, 1, 0))` = '1')

I was not able to find a proper solution to fix this. Can anyone help on this ?
thanks

magento-1.9 sql query grid-layout

share|improve this question

asked 14 mins ago

kaushik kumar roykaushik kumar roy

257

add a comment | 

0

I have an issue in Magento 1, where the SQL query that is getting generated has the back tics wrongly placed.

This is a piece of the code that helps to provide the collection to the grid layout.

protected function _prepareCollection()

 $accountId = $this->getRequest()->getParam('id');
 $collection = Mage::getResourceModel('testmodule/coupon_collection');


 if (Mage::helper('testmodulecoupon')->isMultiProgram()
 && Mage::helper('core')->isModuleEnabled('Test_module')
 )
 $collection->getSelect()->joinLeft(
 array('p' => $collection->getTable('testmodule/account')),
 'main_table.program_id = p.program_id AND main_table.account_id = p.account_id',
 array()
 )->joinLeft(
 array('r' => $collection->getTable('testmodule/program')),
 'main_table.program_id = r.program_id',
 array('status' => 'IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))')
 );
 else 
 $collection->addFieldToFilter('program_id', array('eq'=>0));
 
 $collection->addFieldToFilter('main_table.account_id',$accountId); 

 $this->setCollection($collection);
 return parent::_prepareCollection();

In the above code, this part of the line is generating the back tics wrongly.

array('status' => 'IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))') 

This is part of SQL query that is generating.

(`IF (main_table`.`program_id = 0, 1, IF(p`.`id AND r`.`use_coupon, 1, 0))` = '1')

I was not able to find a proper solution to fix this. Can anyone help on this ?
thanks

magento-1.9 sql query grid-layout

share|improve this question

asked 14 mins ago

kaushik kumar roykaushik kumar roy

257

add a comment | 

I have an issue in Magento 1, where the SQL query that is getting generated has the back tics wrongly placed.

This is a piece of the code that helps to provide the collection to the grid layout.

protected function _prepareCollection()

 $accountId = $this->getRequest()->getParam('id');
 $collection = Mage::getResourceModel('testmodule/coupon_collection');


 if (Mage::helper('testmodulecoupon')->isMultiProgram()
 && Mage::helper('core')->isModuleEnabled('Test_module')
 )
 $collection->getSelect()->joinLeft(
 array('p' => $collection->getTable('testmodule/account')),
 'main_table.program_id = p.program_id AND main_table.account_id = p.account_id',
 array()
 )->joinLeft(
 array('r' => $collection->getTable('testmodule/program')),
 'main_table.program_id = r.program_id',
 array('status' => 'IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))')
 );
 else 
 $collection->addFieldToFilter('program_id', array('eq'=>0));
 
 $collection->addFieldToFilter('main_table.account_id',$accountId); 

 $this->setCollection($collection);
 return parent::_prepareCollection();

In the above code, this part of the line is generating the back tics wrongly.

array('status' => 'IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))') 

This is part of SQL query that is generating.

(`IF (main_table`.`program_id = 0, 1, IF(p`.`id AND r`.`use_coupon, 1, 0))` = '1')

I was not able to find a proper solution to fix this. Can anyone help on this ?
thanks

magento-1.9 sql query grid-layout

share|improve this question

asked 14 mins ago

kaushik kumar roykaushik kumar roy

257

protected function _prepareCollection()

 $accountId = $this->getRequest()->getParam('id');
 $collection = Mage::getResourceModel('testmodule/coupon_collection');


 if (Mage::helper('testmodulecoupon')->isMultiProgram()
 && Mage::helper('core')->isModuleEnabled('Test_module')
 )
 $collection->getSelect()->joinLeft(
 array('p' => $collection->getTable('testmodule/account')),
 'main_table.program_id = p.program_id AND main_table.account_id = p.account_id',
 array()
 )->joinLeft(
 array('r' => $collection->getTable('testmodule/program')),
 'main_table.program_id = r.program_id',
 array('status' => 'IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))')
 );
 else 
 $collection->addFieldToFilter('program_id', array('eq'=>0));
 
 $collection->addFieldToFilter('main_table.account_id',$accountId); 

 $this->setCollection($collection);
 return parent::_prepareCollection();

array('status' => 'IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))') 

(`IF (main_table`.`program_id = 0, 1, IF(p`.`id AND r`.`use_coupon, 1, 0))` = '1')

share|improve this question

asked 14 mins ago

kaushik kumar roykaushik kumar roy

257

share|improve this question

asked 14 mins ago

kaushik kumar roykaushik kumar roy

257

asked 14 mins ago

kaushik kumar roykaushik kumar roy

257

asked 14 mins ago

kaushik kumar roykaushik kumar roy

257

1 Answer
1

active

oldest

votes

0

Try to build that part of the query using Zend_Db_Expr object. This way should work correctly:

array('status' => new Zend_Db_Expr('IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))'))

share

answered 5 mins ago

HelgeBHelgeB

2,8031321

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f267355%2fmagento-1-query-generated-back-tics-are-wrongly-placed%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Try to build that part of the query using Zend_Db_Expr object. This way should work correctly:

array('status' => new Zend_Db_Expr('IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))'))

share

answered 5 mins ago

HelgeBHelgeB

2,8031321

add a comment | 

0

Try to build that part of the query using Zend_Db_Expr object. This way should work correctly:

array('status' => new Zend_Db_Expr('IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))'))

share

answered 5 mins ago

HelgeBHelgeB

2,8031321

add a comment | 

Try to build that part of the query using Zend_Db_Expr object. This way should work correctly:

array('status' => new Zend_Db_Expr('IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))'))

share

answered 5 mins ago

HelgeBHelgeB

2,8031321

array('status' => new Zend_Db_Expr('IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))'))

share

answered 5 mins ago

HelgeBHelgeB

2,8031321

answered 5 mins ago

HelgeBHelgeB

2,8031321

answered 5 mins ago

HelgeBHelgeB

2,8031321