orocrm /
crm
| @@ 209-222 (lines=14) @@ | ||
| 206 | /** |
|
| 207 | * @return string |
|
| 208 | */ |
|
| 209 | protected function getFillCartEmailActivityListQuery() |
|
| 210 | { |
|
| 211 | $sql = 'INSERT INTO %s (activitylist_id, cart_id)' . |
|
| 212 | ' SELECT al.id, rel.cart_id' . |
|
| 213 | ' FROM oro_activity_list al' . |
|
| 214 | ' JOIN %s rel ON rel.email_id = al.related_activity_id' . |
|
| 215 | ' AND al.related_activity_class = :class'; |
|
| 216 | ||
| 217 | return sprintf( |
|
| 218 | $sql, |
|
| 219 | $this->activityListExtension->getAssociationTableName('orocrm_magento_cart'), |
|
| 220 | $this->activityExtension->getAssociationTableName('oro_email', 'orocrm_magento_cart') |
|
| 221 | ); |
|
| 222 | } |
|
| 223 | ||
| 224 | /** |
|
| 225 | * @return string |
|
| @@ 227-240 (lines=14) @@ | ||
| 224 | /** |
|
| 225 | * @return string |
|
| 226 | */ |
|
| 227 | protected function getFillCartCallActivityListQuery() |
|
| 228 | { |
|
| 229 | $sql = 'INSERT INTO %s (activitylist_id, cart_id)' . |
|
| 230 | ' SELECT al.id, rel.cart_id' . |
|
| 231 | ' FROM oro_activity_list al' . |
|
| 232 | ' JOIN %s rel ON rel.call_id = al.related_activity_id' . |
|
| 233 | ' AND al.related_activity_class = :class'; |
|
| 234 | ||
| 235 | return sprintf( |
|
| 236 | $sql, |
|
| 237 | $this->activityListExtension->getAssociationTableName('orocrm_magento_cart'), |
|
| 238 | $this->activityExtension->getAssociationTableName('orocrm_call', 'orocrm_magento_cart') |
|
| 239 | ); |
|
| 240 | } |
|
| 241 | ||
| 242 | /** |
|
| 243 | * @return string |
|
| @@ 245-258 (lines=14) @@ | ||
| 242 | /** |
|
| 243 | * @return string |
|
| 244 | */ |
|
| 245 | protected function getFillOrderEmailActivityListQuery() |
|
| 246 | { |
|
| 247 | $sql = 'INSERT INTO %s (activitylist_id, order_id)' . |
|
| 248 | ' SELECT al.id, rel.order_id' . |
|
| 249 | ' FROM oro_activity_list al' . |
|
| 250 | ' JOIN %s rel ON rel.email_id = al.related_activity_id' . |
|
| 251 | ' AND al.related_activity_class = :class'; |
|
| 252 | ||
| 253 | return sprintf( |
|
| 254 | $sql, |
|
| 255 | $this->activityListExtension->getAssociationTableName('orocrm_magento_order'), |
|
| 256 | $this->activityExtension->getAssociationTableName('oro_email', 'orocrm_magento_order') |
|
| 257 | ); |
|
| 258 | } |
|
| 259 | ||
| 260 | /** |
|
| 261 | * @return string |
|
| @@ 263-276 (lines=14) @@ | ||
| 260 | /** |
|
| 261 | * @return string |
|
| 262 | */ |
|
| 263 | protected function getFillOrderCallActivityListQuery() |
|
| 264 | { |
|
| 265 | $sql = 'INSERT INTO %s (activitylist_id, order_id)' . |
|
| 266 | ' SELECT al.id, rel.order_id' . |
|
| 267 | ' FROM oro_activity_list al' . |
|
| 268 | ' JOIN %s rel ON rel.call_id = al.related_activity_id' . |
|
| 269 | ' AND al.related_activity_class = :class'; |
|
| 270 | ||
| 271 | return sprintf( |
|
| 272 | $sql, |
|
| 273 | $this->activityListExtension->getAssociationTableName('orocrm_magento_order'), |
|
| 274 | $this->activityExtension->getAssociationTableName('orocrm_call', 'orocrm_magento_order') |
|
| 275 | ); |
|
| 276 | } |
|
| 277 | } |
|
| 278 | ||
| @@ 172-185 (lines=14) @@ | ||
| 169 | /** |
|
| 170 | * @return string |
|
| 171 | */ |
|
| 172 | protected function getFillContactRequestEmailActivityListQuery() |
|
| 173 | { |
|
| 174 | $sql = 'INSERT INTO %s (activitylist_id, contactrequest_id)' . |
|
| 175 | ' SELECT al.id, rel.contactrequest_id' . |
|
| 176 | ' FROM oro_activity_list al' . |
|
| 177 | ' JOIN %s rel ON rel.email_id = al.related_activity_id' . |
|
| 178 | ' AND al.related_activity_class = :class'; |
|
| 179 | ||
| 180 | return sprintf( |
|
| 181 | $sql, |
|
| 182 | $this->activityListExtension->getAssociationTableName('orocrm_contactus_request'), |
|
| 183 | $this->activityExtension->getAssociationTableName('oro_email', 'orocrm_contactus_request') |
|
| 184 | ); |
|
| 185 | } |
|
| 186 | ||
| 187 | /** |
|
| 188 | * @return string |
|
| @@ 190-203 (lines=14) @@ | ||
| 187 | /** |
|
| 188 | * @return string |
|
| 189 | */ |
|
| 190 | protected function getFillContactRequestCallActivityListQuery() |
|
| 191 | { |
|
| 192 | $sql = 'INSERT INTO %s (activitylist_id, contactrequest_id)' . |
|
| 193 | ' SELECT al.id, rel.contactrequest_id' . |
|
| 194 | ' FROM oro_activity_list al' . |
|
| 195 | ' JOIN %s rel ON rel.call_id = al.related_activity_id' . |
|
| 196 | ' AND al.related_activity_class = :class'; |
|
| 197 | ||
| 198 | return sprintf( |
|
| 199 | $sql, |
|
| 200 | $this->activityListExtension->getAssociationTableName('orocrm_contactus_request'), |
|
| 201 | $this->activityExtension->getAssociationTableName('orocrm_call', 'orocrm_contactus_request') |
|
| 202 | ); |
|
| 203 | } |
|
| 204 | } |
|
| 205 | ||
